Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-16465

Not possible to insert create.sql.gz on MariaDB 10.3.17

XMLWordPrintable

    • Sprint 56 (Sep 2019), Sprint 55 (Aug 2019), Sprint 57 (Oct 2019)
    • 1

      Hi Team,

      While it may not be a direct Zabbix issue I will still state it here:

      Inserting a plain schema on MariaDB server 10.3.16 works.

      On 10.3.17 server it states:

      zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix
Enter password:
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.

       

      The majority of procedures I follow from:

      https://www.zabbix.com/download?zabbix=4.0&os_distribution=centos&os_version=7&db=mysql

      Steps to reproduce:

      cat <<'EOF'> /etc/yum.repos.d/MariaDB.repo
# MariaDB 10.3 CentOS repository list - created 2018-05-31 08:48 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF

rpm -ivh https://repo.zabbix.com/zabbix/4.2/rhel/7/x86_64/zabbix-release-4.2-1.el7.noarch.rpm

yum makecache fast

yum -y install MariaDB-server MariaDB-client

systemctl start mariadb

mysql <<< 'create database zabbix character set utf8 collate utf8_bin;'
mysql <<< 'grant all privileges on zabbix.* to "zabbix"@"localhost" identified by "zabbix";'

yum -y install zabbix-server-mysql

zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -pzabbix zabbix

       

            vso Vladislavs Sokurenko
            aigars.kadikis Aigars Kadikis
            Team A
            Votes:
            15 Vote for this issue
            Watchers:
            34 Start watching this issue

              Created:
              Updated:
              Resolved: