Database problems
-
Hi,
Server Platform:
Netxms 1.2.16
Database: MySQL
OS: Windows Server 2008 R2I'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 -
looks like you have had some disk problem.
maybe no diskspace or so.you can try to repair this table (and probably other tables as well) by running:
mysqlcheck --auto-repair <database name> -u root -pgive the password for mysql root user.
This will check all the tables in de database and try to fix them. -
Hi,
Thanks for that, there is plenty of disk space but the server did get dumped when the battery in the UPS failed and there was a power outage.
I've run the MySQL repair and will see how it goes, NetXMS core started without errors which is a good sign.Regards,
David
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login