Azkban上传文件报错installation Failed.Error chunking

末蓝、 2022-06-10 02:46 168阅读 0赞

## Azkban上传文件报错installation Failed.Error chunking ##

[Azkban上传文件报错installation Failed.Error chunking][Azkban_installation Failed.Error chunking]

[mysql max\_allowed\_packet查询和修改][mysql max_allowed_packet]

[Linux安装mysql 在/etc下没有my.cnf 解决办法][Linux_mysql _etc_my.cnf]

azkaban 上传文件报错  
Caused by: java.sql.SQLException: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the re  
do log size using innodb\_log\_file\_size

修改mysql文件中my.cnf innodb\_log\_file\_size=48M 为 2000M  
innodb\_log\_file\_size=2000M

===================================================================  
Mycat 需要修改mysql的my.cnf文件

lower\_case\_table\_names = 1 //mycat搭建需要修改该文件  
max\_allowed\_packet=200M  
innodb\_log\_file\_size=2000M

重启服务时报错如下

[root@ etc]# service mysqld restart
    error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 2
    Fatal error in defaults handling. Program aborted
    error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 2
    Fatal error in defaults handling. Program aborted
    error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 2
    Fatal error in defaults handling. Program aborted
    error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 2
    Fatal error in defaults handling. Program aborted
    Stopping mysqld:                                           [  OK  ]
    Starting mysqld:                                           [  OK  ]

发现配置文件是 /etc/mysql/my.cnf

所以去修改该文件。

[Azkban_installation Failed.Error chunking]: http://www.cnblogs.com/atomicbomb/p/6945128.html
[mysql max_allowed_packet]: http://blog.csdn.net/quincylk/article/details/19401695
[Linux_mysql _etc_my.cnf]: http://www.cnblogs.com/dsitn/p/7079967.html