Ad Widget

Collapse

Upgrade from 2.0.9 to 2.2 MySQL error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Playmobil
    Junior Member
    • Nov 2013
    • 1

    #1

    Upgrade from 2.0.9 to 2.2 MySQL error

    Hi,

    I'm upgrading from 2.0.9 to 2.2, when I start "zabbix_server" for the first time it gives the following error updating Database:

    5436:20131118:124512.378 ODBC: NO
    5436:20131118:124512.378 SSH2 support: YES
    5436:20131118:124512.378 IPv6 support: YES
    5436:20131118:124512.378 ******************************
    5436:20131118:124512.378 using configuration file: /usr/local/etc/zabbix_server.conf
    5436:20131118:124512.383 current database version (mandatory/optional): 02010164/02010164
    5436:20131118:124512.383 required mandatory version: 02020000
    5436:20131118:124512.383 starting automatic database upgrade
    5436:20131118:124512.499 [Z3005] query failed: [1005] Can't create table 'zabbix.#sql-14d8_13' (errno: 150) [alter table interface_discovery add constraint c_interface_discovery_1 foreign key (interfaceid) references interface (interfaceid) on delete cascade]
    5436:20131118:124512.499 database upgrade failed
Working...