Text only | Text with Images

NetXMS Support Forum

English Support => General Support => Topic started by: Dani@M3T on June 21, 2014, 11:36:35 AM

Title: Database errors when DCI from templates deleted
Post by: Dani@M3T on June 21, 2014, 11:36:35 AM
When I delete DCIs from templates (not from nodes) I always get errors like this:

Code Select
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.
Title: Re: Database errors when DCI from templates deleted
Post by: Dani@M3T on June 27, 2014, 12:02:14 PM
Has anybody an idea, it is a problem in our database or a known bug?
Title: Re: Database errors when DCI from templates deleted
Post by: Alex Kirhenshtein on June 27, 2014, 02:31:18 PM
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).
Title: Re: Database errors when DCI from templates deleted
Post by: Dani@M3T on June 27, 2014, 02:32:13 PM
Ok, everything clear. Thank's Alex
Text only | Text with Images