配置过max_allowed_packet依然 Error Chunking during uploading files to db..

mysql配置问题,导致上传azkaban上传包时出现

installation Failed
 Error Chunking during uploading files to db..

已经设置过max_allowed_packet了

mysql> show variables like ‘max_allowed_packet‘;
+--------------------+------------+
| Variable_name      | Value      |
+--------------------+------------+
| max_allowed_packet | 1073741824 |
+--------------------+------------+
1 row in set (0.00 sec)

innodb 引擎还需设置innodb_log_file_size,这个值默认50m

最终的my.cnf配置如下

  1 [mysqld]
  2 datadir=/home/homework/shaofengfeng/az/mysql/mysql/data
  3 socket=/home/homework/shaofengfeng/az/mysql/mysql/run/mysql.sock
  4 max_allowed_packet=1024M
  5 innodb_log_file_size=1024M

参考资料

https://github.com/azkaban/azkaban/issues/32

原文地址:https://www.cnblogs.com/lshao/p/12706652.html

时间: 04-15

配置过max_allowed_packet依然 Error Chunking during uploading files to db..的相关文章

[转载]DirectoryEntry配置IIS7出现ADSI Error:未知错误(0x80005000)

一.错误情况 环境:win7+iis7.0 DirectoryEntry配置IIS7出现如下错误 或者是 下面一段代码在IIS6.0下运转正常,但IIS7.0下运转会出错: System.DirectoryServices.DirectoryEntry iisServer;iisServer = new System.DirectoryServices.DirectoryEntry("IIS://localhost/W3SVC/1");System.DirectoryServices.

Redis主从配置异常解决:Error condition on socket for SYNC: Connection refused

Redis主从配置异常解决:Error condition on socket for SYNC: Connection refused 在docker中搭建的redis主从集群时,从服务器上的redis日志报错: 32677:S 08 Feb 16:14:38.947 * Connecting to MASTER 172.168.10.70:6379 32677:S 08 Feb 16:14:38.948 * MASTER <-> SLAVE sync started 32677:S 08

nagios 配置报错,Error: Service has no hosts and/or service_description,解决

Error: Service has no hosts and/or service_description 今天配置nagios的时候,遇到一个报错,颇为头疼了一段时间,特此记录. 环境:centos6.5  nagiso 4.0.8 故障现象: # /usr/local/nagios/bin/nagios -v  /usr/local/nagios/etc/nagios.cfg Nagios Core 4.0.8 Copyright (c) 2009-present Nagios Core

springboot 配置jpa启动报Error processing condition on org.springframework.boot.autoconfigure.data.web.SpringDataWebAutoConfiguration.pageableCustomizer

springboot +gradle 配置jpa启动报Error processing condition on org.springframework.boot.autoconfigure.data.web.SpringDataWebAutoConfiguration.pageableCustomizer 经过一步步查看删选是因为spring-data-jpa包的版本冲突导致. 解决方案: 修改gradle的build.gradle配置文件 a.添加plugin("org.springfram

Error:Cannot compile Groovy files: no Groovy library is defined for module &#39;xxxx&#39; 错误处理

出现 Error:Cannot compile Groovy files: no Groovy library is defined for module 'xxxx' 只要在 project structure 中的modules中左上角的 + 号,然后找到groovy添加即可! 具体可参考: http://stackoverflow.com/questions/43450683/errorcannot-compile-groovy-files-no-groovy-library-is-def

MySQL错误:ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

MySQL错误:ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES在执行MySQL复制的前奏时:为主服务器创建用户以便从服务器连接,出现该错误:GRANT REPLICATION SLAVE ON a_database.* to 'repl'@'domain.test' IDENTIFIED BY 'slavepass';之所以指定数据库我是希望能只复制这个数据库而忽略其他(已创建的或今后会创建的)数据库.因

[DeploymentService:290066]Error occurred while downloading files from admin server for deployment re

上周部署项目到weblogic时候,一直报消息图标 - 错误 [DeploymentService:290066]Error occurred while downloading files from admin server for deployment request "1,428,631,595,356". Underlying error is: "null".具体截图如下: 解决方案如下: 1.经过查找发现,项目本身都是采用UTF-8,项目新增的页面有部分

学习笔记:Planing The Class&#39;s Features--FROM:Uploading Files Securely With PHP

1.什么是Class? Class就是一类相关的变量和函数的集合: 在Class中变量叫做属性,函数叫做方法: 属性和方法都有三个特性:public, protected, private ,对他们通俗的解释如下: public:公共的,公开的,这个属性或者方法大家都能用: protected:受保护的,这个属性或方法只有我和我的儿孙们(继承)能用: private:这是老子私有的,儿子孙子都不能用的: 如果 要使用一个class,你通常需要实例化(也有静态访问的方法),class实例化之后得到

MySQL案例02:ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

MySQL在授权用户时出现报错信息,具体信息如下: 一.错误信息 执行命令: GRANT SELECT,INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION

accept error: Too many open files

今天测试socket服务器同一时间处理多个客户端连接问题,第一次测试1000个的时候没问题,第二次测试1000个服务器accept的时候就报错了 accept error: Too many open files 看来打开的socket数目已经超过单进程最大文件描述符限制了 查看一下系统设置 $ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e)