NetXMS Support Forum

Hi.
I had a powerloss on my netXMS server and now I get the following message when I start it:
"SQL query failed (Query = "INSERT INTO idata_117 (item_id,idata_timestamp,idata_value) VALUES (162,1332911181,'4')"): Incorrect key file for table './netxms/idata_117.MYI'; try to repair it"

Not sure what to make of this, the server starts and seems to be working, but it would be nice to get it fixed just for the sake.

The consequences for this is that collected data is not stored for node with id 117. You can try to stop NetXMS server, connect to your MySQL database, and run

REPAIR TABLE idata_117;

Then I suggest to run

nxdbmgr check

to check database for consistency. Then you can start NetXMS server again.

Best regards,
Victor

Hi.
Thanx, this did the trick.

br /Tops