Cannot execute discovery rules

[wsdx]

Hello,

I'm trying to execute several discovery rules on different hosts and with different templates but get the error:

• Error in query [INSERT INTO task_check_now (taskid,itemid) VALUES ('80','89865')] [Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`task_check_now`, CONSTRAINT `c_task_check_now_1` FOREIGN KEY (`taskid`) REFERENCES `task_old` (`taskid`) ON DELETE CASCADE)]
• SQL statement execution has failed "INSERT INTO task_check_now (taskid,itemid) VALUES ('80','89865')".

I've checked - the last record in task_check_now has taskid 79 so 80 looks like to be ok to insert.

Could you please help me with the trouble. Thank you.

[wsdx]

Nobody knows?

[Hamardaban]

You need to fix the database schema. Find the reference schema in the zabbix distribution for your version of Zabbix server and DB server and check all the links and keys for the task_check_now table.

[wsdx]

Thank you. I've found a discrepancy and fixed that.