dj-wasabi / ansible-zabbix-server

Installing and maintaining zabbix-server for RedHat/Debian/Ubuntu.
https://galaxy.ansible.com/dj-wasabi/zabbix-server/
MIT License
176 stars 150 forks source link

Workaround for importing create.sql.gz issue on Debian 10 #157

Closed banzayats closed 4 years ago

banzayats commented 4 years ago

Description of PR Debian 10 comes with MariaDB 10.3.17:

~$ cat /etc/debian_version 
10.1
~$ mysql -V
mysql  Ver 15.1 Distrib 10.3.17-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

When importing a schema into a database, a problem arises:

ERROR 1118 (42000) at line 1278: 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.

Details can be found here: https://support.zabbix.com/browse/ZBX-16465

As a workaround we can disable InnoDB strict mode before importing.

Type of change Bugfix Pull Request

Fixes an issue

dj-wasabi commented 4 years ago

Thanks! 👍