Ad Widget

Collapse

Upgrade 2.2 to 2.4 ([Z3005] query failed: [1452])

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kazaros
    Junior Member
    • Jun 2014
    • 14

    #1

    Upgrade 2.2 to 2.4 ([Z3005] query failed: [1452])

    hello colleagues
    when updating zabbix got this error:
    /var/log/zabbix# cat zabbix_server.log

    535:20160222:173454.514 using configuration file: /etc/zabbix/zabbix_server.conf
    6535:20160222:173454.520 current database version (mandatory/optional): 02020000/02020001
    6535:20160222:173454.520 required mandatory version: 02040000
    6535:20160222:173454.520 starting automatic database upgrade
    6535:20160222:173454.521 completed 0% of database upgrade
    6535:20160222:173454.530 completed 1% of database upgrade
    6535:20160222:173454.533 completed 2% of database upgrade
    6535:20160222:173454.536 completed 3% of database upgrade
    6535:20160222:173454.547 completed 4% of database upgrade
    6535:20160222:173454.562 completed 5% of database upgrade
    6535:20160222:173454.602 completed 6% of database upgrade
    6535:20160222:173454.638 completed 7% of database upgrade
    6535:20160222:173454.639 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`trigger_discovery`, CONSTRAINT `c_trigger_discovery_1` FOREIGN KEY (`triggerid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE) [insert into trigger_discovery (select triggerid,parent_triggerid from trigger_discovery_tmp)]
    6535:20160222:173454.639 database upgrade failed
  • kazaros
    Junior Member
    • Jun 2014
    • 14

    #2
    resolved with reinstall zabbix and
    # apt-get install snmp-mibs-downloader
    # download-mibs

    Comment

    Working...