-
Problem report
-
Resolution: Commercial support required
-
Trivial
-
None
-
None
-
None
-
None
centos 6.5 x86-64
I install the zabbix 2.4 rpm with zabbix repo
and install mysqld 5.1 rpm (yum)
change MYISAM to InnoDB in mysqld 5.1
and I upgrade mysqld 5.1 to mysqld 5.6 binary
mysqldump out to a sql file from mysqld5.1 and source zabbix.sql into mysqld5.6
here it goes well.
Now I upgrade zabbix to 3.4 fails(yum install from zabbix repo)
here is the logs:
and I find out it is ok from zabbix 2.4
to zabbix 3.0 3.2
any ideas? am I doing something wrong?
tail /var/log/zabbix/zabbix_server.log 31278:20180130:152200.819 IPv6 support: YES 31278:20180130:152200.819 TLS support: YES 31278:20180130:152200.819 ****************************** 31278:20180130:152200.819 using configuration file: /etc/zabbix/zabbix_server.conf 31278:20180130:152200.824 current database version (mandatory/optional): 03030004/03030004 31278:20180130:152200.824 required mandatory version: 03040000 31278:20180130:152200.824 optional patches were found 31278:20180130:152200.824 starting automatic database upgrade 31278:20180130:152200.872 [Z3005] query failed: [1091] Can't DROP 'c_dservices_2'; check that column/key exists [alter table dservices drop foreign key c_dservices_2] 31278:20180130:152200.872 database upgrade failed
desc dservices; +------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------------+------+-----+---------+-------+ | dserviceid | bigint(20) unsigned | NO | PRI | NULL | | | dhostid | bigint(20) unsigned | NO | MUL | NULL | | | type | int(11) | NO | | 0 | | | key_ | varchar(255) | NO | | | | | value | varchar(255) | NO | | | | | port | int(11) | NO | | 0 | | | status | int(11) | NO | | 0 | | | lastup | int(11) | NO | | 0 | | | lastdown | int(11) | NO | | 0 | | | dcheckid | bigint(20) unsigned | NO | MUL | NULL | | | ip | varchar(39) | NO | | | | | dns | varchar(64) | NO | | | | +------------+---------------------+------+-----+---------+-------+ 12 rows in set (0.00 sec)