Database query failed

Started by BonsaiJoe, May 31, 2013, 10:23:26 PM

Previous topic - Next topic

BonsaiJoe

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

Victor Kirhenshtein

Hi!

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

Best regards,
Victor

BonsaiJoe

Thanks

The errors are gone after restarting the server