[ZBX-16472] query failed when proxy receives configuration from server Created: 2019 Aug 07  Updated: 2019 Aug 09  Resolved: 2019 Aug 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 4.2.5
Fix Version/s: None

Type: Incident report Priority: Blocker
Reporter: Oleksii Zagorskyi Assignee: Andris Zeila
Resolution: Duplicate Votes: 0
Labels: preprocessing, proxy, sql
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBX-16473 preprocessing steps are ignored for c... Closed

 Description   

Having this key:

zabbix[host,,maintenance]

for a host, monitored by zabbix proxy and this item has a pre-processing step (don't ask me why).
When proxy received configuration, it gets this errors:

 20473:20190806:235257.280 received configuration data from server at "127.0.0.1", datalen 3957
 20473:20190806:235257.282 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`proxy4.2`.`item_preproc`, CONSTRAINT `c_item_preproc_1` FOREIGN KEY (`itemid`) REFERENCES `items`
 (`itemid`) ON DELETE CASCADE) [insert into item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values (7461,29271,1,6,'',0,'');
]
 20473:20190806:235257.282 failed to update local proxy configuration copy: database error

Reproducible in 4.2.5, so recent ZBX-16308 fix does not cover this case.

 Comments   
Comment by Vladislavs Sokurenko [ 2019 Aug 07 ]

If not easily reproducible then could be same logic as this one:
ZBX-16445

Comment by Vladislavs Sokurenko [ 2019 Aug 09 ]

Thank you for your report, this will be fixed under ZBX-16473

Generated at Thu Jun 26 08:21:45 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.