-
Problem report
-
Resolution: Won't fix
-
Blocker
-
None
-
None
-
None
Hi Everyone,
i have upaded my Zabbix version 3.2 to 3.4 with the help of the official documentation https://www.zabbix.com/documentation/3.4/manual/installation/upgrade_packages/rhel_centos
When i'm starting the Zabbix-Server service, in the log i get error for the database upgrade.
24328:20180607:235936.448 Starting Zabbix Server. Zabbix 3.4.9 (revision 80550). 24328:20180607:235936.448 ****** Enabled features ****** 24328:20180607:235936.448 SNMP monitoring: YES 24328:20180607:235936.448 IPMI monitoring: YES 24328:20180607:235936.448 Web monitoring: YES 24328:20180607:235936.448 VMware monitoring: YES 24328:20180607:235936.448 SMTP authentication: YES 24328:20180607:235936.448 Jabber notifications: YES 24328:20180607:235936.448 Ez Texting notifications: YES 24328:20180607:235936.448 ODBC: YES 24328:20180607:235936.449 SSH2 support: YES 24328:20180607:235936.449 IPv6 support: YES 24328:20180607:235936.449 TLS support: YES 24328:20180607:235936.449 ****************************** 24328:20180607:235936.449 using configuration file: /etc/zabbix/zabbix_server.conf 24328:20180607:235936.457 current database version (mandatory/optional): 03030004/03030004 24328:20180607:235936.457 required mandatory version: 03040000 24328:20180607:235936.457 optional patches were found 24328:20180607:235936.457 starting automatic database upgrade 24328:20180607:235936.465 [Z3005] query failed: [1025] Error on rename of './zabbix/dservices' to './zabbix/#sql2-42ce-e3' (errno: 152) [alter table dservices drop fo reign key c_dservices_2] 24328:20180607:235936.465 database upgrade failed
This is table structure:
| dservices | CREATE TABLE `dservices` ( `dserviceid` bigint(20) unsigned NOT NULL, `dhostid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `key_` varchar(255) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', `port` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', `lastup` int(11) NOT NULL DEFAULT '0', `lastdown` int(11) NOT NULL DEFAULT '0', `dcheckid` bigint(20) unsigned NOT NULL, `ip` varchar(39) NOT NULL DEFAULT '', `dns` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`dserviceid`), UNIQUE KEY `dservices_1` (`dcheckid`,`type`,`key_`,`ip`,`port`), KEY `dservices_2` (`dhostid`), CONSTRAINT `_c_dservices_1` FOREIGN KEY (`dhostid`) REFERENCES `dhosts` (`dhostid`) ON DELETE CASCADE, CONSTRAINT `_c_dservices_2` FOREIGN KEY (`dcheckid`) REFERENCES `dchecks` (`dcheckid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
Have got any solution, please ?
Thank you in advance for your time.