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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Duplicate
    • Affects Version/s: 3.4.1
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None

      Description

      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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: