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

Proxy SQL Upgrade fails to 3.2.0

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 3.0.3, 3.0.4
    • Proxy (P)
    • None

      Updated our zabbix server from 3.0.4 to 3.2.0 where after i upgraded our proxy servers. I received multiple errors during the upgrade scripts for the proxy servers databases. Luckily they were proxy servers and could be dropped and re-created.

      Here's a list of all the errors, not sure which versions they are but database versions are included from all.

       4781:20160917:125638.393 using configuration file: /etc/zabbix/zabbix_proxy.conf
  4781:20160917:125638.398 current database version (mandatory/optional): 03010018/03010018
  4781:20160917:125638.398 required mandatory version: 03020000
  4781:20160917:125638.398 starting automatic database upgrade
  4781:20160917:125638.408 [Z3005] query failed: [1005] Can't create table `zabbix`.`#sql-6af7_da` (errno: 121 "Duplicate key on write or update") [alter table event_recovery add constraint c_event_recovery_1 foreign key (eventid) references events (eventid) on delete cascade]
  4781:20160917:125638.408 database upgrade failed

        24549:20160917:125658.653 using configuration file: /etc/zabbix/zabbix_proxy.conf
 24549:20160917:125658.664 current database version (mandatory/optional): 03010021/03010021
 24549:20160917:125658.664 required mandatory version: 03020000
 24549:20160917:125658.664 starting automatic database upgrade
 24549:20160917:125658.665 [Z3005] query failed: [1060] Duplicate column name 'recovery' [alter table operations add recovery integer default '0' not null]
 24549:20160917:125658.665 database upgrade failed

        19342:20160917:125740.684 using configuration file: /etc/zabbix/zabbix_proxy.conf
 19342:20160917:125740.688 current database version (mandatory/optional): 03010061/03010061
 19342:20160917:125740.688 required mandatory version: 03020000
 19342:20160917:125740.688 starting automatic database upgrade
 19342:20160917:125740.695 [Z3005] query failed: [1005] Can't create table `zabbix`.`#sql-24d9_ee` (errno: 121 "Duplicate key on write or update") [alter table corr_condition_tagpair add constraint c_corr_condition_tagpair_1 foreign key (corr_conditionid) references corr_condition (corr_conditionid) on delete cascade]

        3729:20160917:133406.408 using configuration file: /etc/zabbix/zabbix_proxy.conf
  3729:20160917:133406.414 current database version (mandatory/optional): 03010003/03010003
  3729:20160917:133406.414 required mandatory version: 03020000
  3729:20160917:133406.414 starting automatic database upgrade
  3729:20160917:133406.414 [Z3005] query failed: [1060] Duplicate column name 'recovery_mode' [alter table triggers add recovery_mode integer default '0' not null]

      Last but not least, here is one that worked:
      works:

       32310:20160917:124218.124 current database version (mandatory/optional): 03000000/03000000
 32310:20160917:124218.125 required mandatory version: 03020000

      Might have been other versions that worked but picked this one up at least

            Unassigned Unassigned
            Zimeon Antti Hurme
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: