Hello Team,

There is a possibility to accidently break the data within the "interface" table on Zabbix proxy side. It was tested on proxy using SQLite3 and MySQL as backend database, please find the description below.

Steps to reproduce:

1. Create a host with two interfaces, monitored by a proxy
2. Create ICMP ping item on the test host which will use one of host interfaces as a target
3. Update the test item to use different host interface
4. Quickly delete the interface from the host

Current behaviour:

If you do Step 3 and Step 4 fast enough, so it most likely is being done in single configuration synchronization, then we can observe in proxy logs error messages like:

2824:20250403:132314.797 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix_proxy`.`items`, CONSTRAINT `c_items_4` FOREIGN KEY (`inteceid`) REFERENCES `interface` (`interfaceid`)) [delete from interface where interfaceid=37]

Expected behaviour:

The data from tables is being deleted/updated in correct order avoiding constraint failures on database side.