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 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

所以去修改该文件。