NetXMS Support Forum

English Support => General Support => Topic started by: BonsaiJoe on May 31, 2013, 10:23:26 PM

Title: Database query failed
Post by: BonsaiJoe on May 31, 2013, 10:23:26 PM
Hi all,

we are playing around with netxms now since some weeks and everything Looks grate untill now. But today we get a lot of Errors in Event Monitor:

31.05.2013 21:13:31   servername   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: DELETE FROM idata_3290 WHERE item_id=958; Error: Table 'netxms.idata_3290' doesn't exist)
31.05.2013 21:13:31   servername   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: DELETE FROM idata_3290 WHERE item_id=957; Error: Table 'netxms.idata_3290' doesn't exist)
31.05.2013 21:13:31   servername   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: DELETE FROM idata_3290 WHERE item_id=956; Error: Table 'netxms.idata_3290' doesn't exist)
31.05.2013 21:12:43   servername   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: DELETE FROM idata_3282 WHERE item_id=973; Error: Table 'netxms.idata_3282' doesn't exist)
31.05.2013 21:12:43   servername   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: DELETE FROM idata_3282 WHERE item_id=972; Error: Table 'netxms.idata_3282' doesn't exist)
31.05.2013 21:12:43   servername   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: DELETE FROM idata_3282 WHERE item_id=971; Error: Table 'netxms.idata_3282' doesn't exist)
31.05.2013 21:11:52   servername   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: DELETE FROM idata_3281 WHERE item_id=967; Error: Table 'netxms.idata_3281' doesn't exist)
31.05.2013 21:11:51   servername   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: DELETE FROM idata_3281 WHERE item_id=966; Error: Table 'netxms.idata_3281' doesn't exist)
31.05.2013 21:11:51   servername   Critical   SYS_DB_QUERY_FAILED   Database query failed (Query: DELETE FROM idata_3281 WHERE item_id=965; Error: Table 'netxms.idata_3281' doesn't exist)

any idea what that means?

thanks
Title: Re: Database query failed
Post by: Victor Kirhenshtein on June 03, 2013, 01:22:57 PM
Hi!

Looks like broken database. Can you try to stop the server and run database check (with command nxdbmgr check)?

Best regards,
Victor
Title: Re: Database query failed
Post by: BonsaiJoe on June 14, 2013, 11:45:10 PM
Thanks

The errors are gone after restarting the server