Print Page - Incorrect key file for table

Title: Incorrect key file for table
Post by: tops on March 28, 2012, 08:26:17 AM

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.

Title: Re: Incorrect key file for table
Post by: Victor Kirhenshtein on March 28, 2012, 06:02:38 PM

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

Title: Re: Incorrect key file for table
Post by: tops on March 29, 2012, 03:08:57 PM

Hi.
Thanx, this did the trick.

br /Tops

NetXMS Support Forum

English Support => General Support => Topic started by: tops on March 28, 2012, 08:26:17 AM