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

    Details

    • Type: Problem report
    • Status: Confirmed
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.0.11
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      MariaDB 10.2.26, 10.3.17, 10.4.7, 10.3.18, 10.4.8
    • Sprint:
      Sprint 56 (Sep 2019), Sprint 55 (Aug 2019)

      Description

      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
      

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                palivoda Rostislav Palivoda
                Reporter:
                aigars.kadikis Aigars Kadikis
              • Votes:
                12 Vote for this issue
                Watchers:
                23 Start watching this issue

                Dates

                • Created:
                  Updated: