Database errors when DCI from templates deleted

Started by Dani@M3T, June 21, 2014, 11:36:35 AM

Previous topic - Next topic

Dani@M3T

When I delete DCIs from templates (not from nodes) I always get errors like this:

Critical SYS_DB_QUERY_FAILED Database query failed (Query: DELETE FROM idata_1174 WHERE item_id=1354; Error: 42P01 ERROR:  relation "idata_1174" does not exist
LINE 1: DELETE FROM idata_1174 WHERE item_id=1354
Critical SYS_DB_QUERY_FAILED Database query failed (Query: DELETE FROM idata_384 WHERE item_id=526; Error: 42P01 ERROR:  relation "idata_384" does not exist
LINE 1: DELETE FROM idata_384 WHERE item_id=526
Critical SYS_DB_QUERY_FAILED Database query failed (Query: DELETE FROM idata_1139 WHERE item_id=825; Error: 42P01 ERROR:  relation "idata_1139" does not exist
LINE 1: DELETE FROM idata_1139 WHERE item_id=825


It's for older and for newly created DCIs in templates. NetXMS is V1.2.14.

Dani@M3T

Has anybody an idea, it is a problem in our database or a known bug?

Alex Kirhenshtein

Yes, it's known, low priority issue - it does not affect anything except scary record in log file (server tries to delete collected data for template itself - and fails, since idata_* tables are created only for nodes).

Dani@M3T