Zabbix – [1118] Row size too large.



Some readers have reported upgrade failure because of the error in the log “[Z3005] query failed: [1118] Row size too large“.

[Z3005] query failed: [1118] Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs ...

If you recive error above try to disable “innodb_strict_mode“.

a) Disable innodb strict mode:

mysql -uroot -p'rootDBpass' zabbix -e "set global innodb_strict_mode='OFF';"

b) Restart Zabbix server:

systemctl restart zabbix-server 

And check if upgrade was successful with the command “cat /var/log/zabbix/zabbix_server.log | grep database“.

c) Enable innodb strick mode back:

mysql -uroot -p'rootDBpass' zabbix -e "set global innodb_strict_mode='ON';"