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

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

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

mysql max_allowed_packet查询和修改

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> show variables like 'max_allowed_packet';+--------------------+------------+| Variable_name | Value |+--------------------+------------+| max_allowed_packet | 1073741824 | 1073741824/1024/1024 = 1024+--------------------+------------+mysql> show variables like 'innodb_log_file_size';+----------------------+----------+| Variable_name | Value |+----------------------+----------+| innodb_log_file_size | 50331648 | 50331648/1024/1024 = 48+----------------------+----------+

修改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 restarterror: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 2Fatal error in defaults handling. Program abortederror: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 2Fatal error in defaults handling. Program abortederror: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 2Fatal error in defaults handling. Program abortederror: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 2Fatal error in defaults handling. Program abortedStopping mysqld:                                           [  OK  ]Starting mysqld:                                           [  OK  ]

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

所以去修改该文件。