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

DB Upgrade fails v4 -> v5

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 4.0.34, 5.0.17
    • None
    • None
    • OpenSUSE Leap 15.3
      MariaDB 10.5
      v4 Package from openSUSE OBS
      v5 Package from Official Zabbix Repo (SLES15)

    Description

      Hi there,

      Trying to update our productive Zabbix at the company I run into following Problems:

      Unable to Upgrade from v4 to v5 since database upgrade fails with following message:

       14350:20211123:094213.782 Starting Zabbix Server. Zabbix 5.0.17 (revision 0a4ac3dabc).
       14350:20211123:094213.782 ****** Enabled features ******
       14350:20211123:094213.783 SNMP monitoring:           YES
       14350:20211123:094213.783 IPMI monitoring:           YES
       14350:20211123:094213.783 Web monitoring:            YES
       14350:20211123:094213.783 VMware monitoring:         YES
       14350:20211123:094213.783 SMTP authentication:       YES
       14350:20211123:094213.783 ODBC:                      YES
       14350:20211123:094213.783 SSH support:               YES
       14350:20211123:094213.784 IPv6 support:              YES
       14350:20211123:094213.784 TLS support:               YES
       14350:20211123:094213.784 ******************************
       14350:20211123:094213.784 using configuration file: /etc/zabbix/zabbix_server.conf
       14350:20211123:094213.803 current database version (mandatory/optional): 04000000/04000006
       14350:20211123:094213.803 required mandatory version: 05000000
       14350:20211123:094213.803 optional patches were found
       14350:20211123:094213.803 starting automatic database upgrade
       14350:20211123:094213.834 completed 0% of database upgrade
       14350:20211123:094213.870 completed 1% of database upgrade
       14350:20211123:094214.110 completed 2% of database upgrade
       14350:20211123:094214.319 completed 3% of database upgrade
       14350:20211123:094214.407 completed 4% of database upgrade
       14350:20211123:094214.591 completed 5% of database upgrade
       14350:20211123:094215.265 completed 6% of database upgrade
       14350:20211123:094215.275 completed 7% of database upgrade
       14350:20211123:094215.711 completed 8% of database upgrade
       14350:20211123:094215.775 completed 9% of database upgrade
       14350:20211123:094215.933 completed 10% of database upgrade
       14350:20211123:094216.001 completed 11% of database upgrade
       14350:20211123:094216.030 completed 12% of database upgrade
       14350:20211123:094216.202 completed 13% of database upgrade
       14350:20211123:094216.490 completed 14% of database upgrade
       14350:20211123:094216.779 completed 15% of database upgrade
       14350:20211123:094217.523 completed 16% of database upgrade
       14350:20211123:094217.596 completed 17% of database upgrade
       14350:20211123:094217.865 completed 18% of database upgrade
       14350:20211123:094218.034 completed 19% of database upgrade
       14350:20211123:094218.064 completed 20% of database upgrade
       14350:20211123:094218.111 completed 21% of database upgrade
       14350:20211123:094218.162 completed 22% of database upgrade
       14350:20211123:094218.736 completed 23% of database upgrade
       14350:20211123:094218.873 completed 24% of database upgrade
       14350:20211123:094218.882 completed 25% of database upgrade
       14350:20211123:094218.914 completed 26% of database upgrade
       14350:20211123:094218.921 completed 27% of database upgrade
       14350:20211123:094218.926 completed 28% of database upgrade
       14350:20211123:094218.957 completed 29% of database upgrade
       14350:20211123:094219.058 completed 30% of database upgrade
       14350:20211123:094219.546 completed 31% of database upgrade
       14350:20211123:094219.616 completed 32% of database upgrade
       14350:20211123:094219.693 completed 33% of database upgrade
       14350:20211123:094219.755 completed 34% of database upgrade
       14350:20211123:094219.835 completed 35% of database upgrade
       14350:20211123:094220.108 completed 36% of database upgrade
       14350:20211123:094220.190 completed 37% of database upgrade
       14350:20211123:094220.228 completed 38% of database upgrade
       14350:20211123:094220.287 completed 39% of database upgrade
       14350:20211123:094220.534 completed 40% of database upgrade
       14350:20211123:094223.334 completed 41% of database upgrade
       14350:20211123:094223.410 completed 42% of database upgrade
       14350:20211123:094223.417 completed 43% of database upgrade
       14350:20211123:094223.752 completed 44% of database upgrade
       14350:20211123:094223.797 completed 45% of database upgrade
       14350:20211123:094223.863 completed 46% of database upgrade
       14350:20211123:094223.929 completed 47% of database upgrade
       14350:20211123:094223.987 completed 48% of database upgrade
       14350:20211123:094224.396 completed 49% of database upgrade
       14350:20211123:094224.448 completed 50% of database upgrade
       14350:20211123:094224.707 completed 51% of database upgrade
       14350:20211123:094224.914 [Z3005] query failed: [1265] Data truncated for column 'note' at row 1 [alter table `auditlog` change column `details` `note` varchar(128) default '0' not null]
       14350:20211123:094224.915 database upgrade failed

      Upgrade to 4.2 goes through but any further version will not work and fail with the same error message from above.

      If you need more information, feel free to ask.

      Greetings,

      Andreas

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            ALoeer Andreas Löer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: