16
General Support / Database problems
« on: September 05, 2014, 09:42:29 am »
Hi,
Server Platform:
Netxms 1.2.16
Database: MySQL
OS: Windows Server 2008 R2
I've had some data problems since upgrading to 1.2.16 and I've had to delete some nodes and rebuild them to get around broken data. In the server system logs I'm getting lots of errors from NetXMS Core such as these:
SQL query failed (Query = "INSERT INTO idata_12 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table '.\netxms\idata_12' is marked as crashed and should be repaired
I've no idea where to start on this, any help would be appreciated.
Regards,
David
Server Platform:
Netxms 1.2.16
Database: MySQL
OS: Windows Server 2008 R2
I've had some data problems since upgrading to 1.2.16 and I've had to delete some nodes and rebuild them to get around broken data. In the server system logs I'm getting lots of errors from NetXMS Core such as these:
SQL query failed (Query = "INSERT INTO idata_12 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table '.\netxms\idata_12' is marked as crashed and should be repaired
I've no idea where to start on this, any help would be appreciated.
Regards,
David