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

Zabbix 3.4 upgrade: [Z3005] query failed: [1091] Can't DROP 'multiplier'; check that column/key exists

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 3.4.1
    • Server (S)
    • None

      I have been continuously upgrading Zabbix until version 3.2.7. Today I upgraded to 3.4.1. The upgrade stopped on this error:

        5068:20170904:105024.677 Starting Zabbix Server. Zabbix 3.4.1 (revision 71734).
  5068:20170904:105024.677 ****** Enabled features ******
  5068:20170904:105024.677 SNMP monitoring:           YES
  5068:20170904:105024.678 IPMI monitoring:            NO
  5068:20170904:105024.678 Web monitoring:            YES
  5068:20170904:105024.678 VMware monitoring:         YES
  5068:20170904:105024.678 SMTP authentication:        NO
  5068:20170904:105024.678 Jabber notifications:       NO
  5068:20170904:105024.678 Ez Texting notifications:  YES
  5068:20170904:105024.678 ODBC:                      YES
  5068:20170904:105024.678 SSH2 support:              YES
  5068:20170904:105024.680 IPv6 support:               NO
  5068:20170904:105024.680 TLS support:               YES
  5068:20170904:105024.680 ******************************
  5068:20170904:105024.680 using configuration file: /opt/zabbix/etc/zabbix_server.conf
  5068:20170904:105024.695 current database version (mandatory/optional): 03020000/03020000
  5068:20170904:105024.695 required mandatory version: 03040000
  5068:20170904:105024.695 starting automatic database upgrade
  5068:20170904:105024.706 completed 0% of database upgrade
  5068:20170904:105028.917 slow query: 4.210511 sec, "alter table items modify snmp_oid varchar(512) default '' not null"
  5068:20170904:105028.918 completed 1% of database upgrade
  5068:20170904:105029.017 completed 2% of database upgrade
  5068:20170904:105029.053 completed 3% of database upgrade
  5068:20170904:105029.098 completed 4% of database upgrade
  5068:20170904:105029.136 completed 5% of database upgrade
  5068:20170904:105029.164 completed 6% of database upgrade
  5068:20170904:105029.260 completed 7% of database upgrade
  5068:20170904:105029.275 completed 8% of database upgrade
  5068:20170904:105030.198 completed 9% of database upgrade
  5068:20170904:105032.709 Got signal [signal:15(SIGTERM),sender_pid:5341,sender_uid:497,reason:0]. Exiting ...
  5366:20170904:105035.940 Starting Zabbix Server. Zabbix 3.4.1 (revision 71734).
  5366:20170904:105035.941 ****** Enabled features ******
  5366:20170904:105035.941 SNMP monitoring:           YES
  5366:20170904:105035.941 IPMI monitoring:            NO
  5366:20170904:105035.941 Web monitoring:            YES
  5366:20170904:105035.941 VMware monitoring:         YES
  5366:20170904:105035.941 SMTP authentication:        NO
  5366:20170904:105035.941 Jabber notifications:       NO
  5366:20170904:105035.941 Ez Texting notifications:  YES
  5366:20170904:105035.941 ODBC:                      YES
  5366:20170904:105035.941 SSH2 support:              YES
  5366:20170904:105035.941 IPv6 support:               NO
  5366:20170904:105035.941 TLS support:               YES
  5366:20170904:105035.941 ******************************
  5366:20170904:105035.941 using configuration file: /opt/zabbix/etc/zabbix_server.conf
  5366:20170904:105035.952 current database version (mandatory/optional): 03030018/03030018
  5366:20170904:105035.952 required mandatory version: 03040000
  5366:20170904:105035.952 starting automatic database upgrade
  5366:20170904:105035.953 [Z3005] query failed: [1091] Can't DROP 'multiplier'; check that column/key exists [alter table items drop column multiplie
r]
  5366:20170904:105035.953 database upgrade failed

      I have not dropped that column manually myself; It may have been done during some of the upgrades up to 3.2.7?
      In any case, it would be nice if this error would be ignored by the upgrade process and upgrade would continue.

      Workaround: Create column items.multiplier and restart Zabbix server to complete db upgrade

            Unassigned Unassigned
            ronny.pettersen Ronny Pettersen
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: