-
Problem report
-
Resolution: Commercial support required
-
Minor
-
None
-
4.0.5
-
None
-
from: zabbix-server-mysql-3.2.11-1.el7.x86_64
to: zabbix-server-mysql-4.0.5-1.el7.x86_64
Steps to reproduce:
- Install Centos 7 and mariadb-server-5.5.60-1.el7_5.x86_64
- Use AWS DMS to import data from RDS (Zabbix 3.2) and export to this new database server
- Install zabbix-server-mysql and start the daemon
- ...
Result:
88278:20190312:185844.378 Starting Zabbix Server. Zabbix 4.0.5 (revision 90164). 88278:20190312:185844.378 ****** Enabled features ****** 88278:20190312:185844.379 SNMP monitoring: YES 88278:20190312:185844.379 IPMI monitoring: YES 88278:20190312:185844.379 Web monitoring: YES 88278:20190312:185844.379 VMware monitoring: YES 88278:20190312:185844.379 SMTP authentication: YES 88278:20190312:185844.379 Jabber notifications: YES 88278:20190312:185844.379 Ez Texting notifications: YES 88278:20190312:185844.379 ODBC: YES 88278:20190312:185844.379 SSH2 support: YES 88278:20190312:185844.379 IPv6 support: YES 88278:20190312:185844.379 TLS support: YES 88278:20190312:185844.379 ****************************** 88278:20190312:185844.379 using configuration file: /etc/zabbix/zabbix_server.conf 88278:20190312:185844.419 current database version (mandatory/optional): 03020000/03020001 88278:20190312:185844.419 required mandatory version: 04000000 88278:20190312:185844.419 optional patches were found 88278:20190312:185844.419 starting automatic database upgrade 88278:20190312:185844.434 completed 0% of database upgrade 88278:20190312:185847.340 slow query: 2.905735 sec, "alter table `items` modify `snmp_oid` varchar(512) default '' not null" 88278:20190312:185847.400 completed 1% of database upgrade 88278:20190312:185847.427 [Z3005] query failed: [1025] Error on rename of './zabbix/dservices' to './zabbix/#sql2-1b6ec-17' (errno: 152) [alter table dservices drop foreign key c_dservices_2] 88278:20190312:185847.427 database upgrade failed
Expected:
Database upgrade with success