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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 3.0.3, 3.0.4
    • Fix Version/s: None
    • Component/s: Proxy (P)
    • Labels:
      None

      Description

      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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: