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

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 56 (Sep 2019), Sprint 55 (Aug 2019), Sprint 57 (Oct 2019)
    • Story Points:
      1

      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:
              vso Vladislavs Sokurenko
              Reporter:
              aigars.kadikis Aigars Kadikis
              Votes:
              15 Vote for this issue
              Watchers:
              35 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: