Ad Widget

Collapse

Templates assingment problem after upgrade from 4.2.6 to 4.4.0

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • polman
    Junior Member
    • Oct 2019
    • 3

    #1

    Templates assingment problem after upgrade from 4.2.6 to 4.4.0

    I try to assigne any template to the host. I am getting following error in Zabbix Frontend:

    Cannot update host
    • Error in query [INSERT INTO items_applications (applicationid,itemid,itemappid) VALUES ('1302','31038','25897')] [Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`items_applications`, CONSTRAINT `c_items_applications_2` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE)]
    • SQL statement execution has failed "INSERT INTO items_applications (applicationid,itemid,itemappid) VALUES ('1302','31038','25897')".
    Item ID 31038 doesn't exist in an items table. Application ID 1302 doesn't exist in an applications table. We didn't touch database schema and didn't modify any records manually.

    DB Version is: 4040000 (SELECT * FROM zabbix.dbversion)

    How can I debug the issue?

    Thank you in advanced.
  • polman
    Junior Member
    • Oct 2019
    • 3

    #2
    I've restarted Zabbix Server (reboot) and Zabbix Database (reboot) and problem disappeared.

    Comment

    Working...