Dear fellows,
I need your help to fix the following problem. When I try to install zabbis4.4 server on my centos7 box with mariadb-10.4.7 I got the following error message :
ERROR 1118 (42000) at line 1282: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
when I run:
zcat /usr/share/doc/zabbix-server-mysql-4.4.0/create.sql.gz |mysql -uzabbix -p zabbix
Following google advices I already tried all this without any success:
mysql -u root -p -e "SELECT @@GLOBAL.sql_mode;"
mysql -u root -p -e "SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';"
further I canot remove the strict_mode statement editing my.cnf like that:
sql_mode=""
That is answered with an unknow variable error message.
Last I tried is:
ALTER TABLE users ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
If anyone has another idea how to solve this, please let me know.
Many thanks in advance
Uli
I need your help to fix the following problem. When I try to install zabbis4.4 server on my centos7 box with mariadb-10.4.7 I got the following error message :
ERROR 1118 (42000) at line 1282: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
when I run:
zcat /usr/share/doc/zabbix-server-mysql-4.4.0/create.sql.gz |mysql -uzabbix -p zabbix
Following google advices I already tried all this without any success:
mysql -u root -p -e "SELECT @@GLOBAL.sql_mode;"
mysql -u root -p -e "SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';"
further I canot remove the strict_mode statement editing my.cnf like that:
sql_mode=""
That is answered with an unknow variable error message.
Last I tried is:
ALTER TABLE users ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
If anyone has another idea how to solve this, please let me know.
Many thanks in advance
Uli
Comment