-
Incident report
-
Resolution: Duplicate
-
Critical
-
None
-
3.0.3, 3.0.4
-
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
- duplicates
-
ZBX-11203 database upgrade from Zabbix 3.0 to Zabbix 3.2 fails
- Closed