table queuemetrics/queue_log is marked as crashed and should be repaired[solved]

[cuban_cigar]

When trying to do anything in queuemetrics this error message pops up.

The db connection tester checks out ok,  mysql is running, and queuemetrics was able to be logged in to.


Earlier today the harddrive was full, and huge log files 10 days or older were deleted from tomcat, but it should not have had anything to do with queuemetrics.

How to make it work again?

[QueueMetrics]

Try this from a MySQL shell:

Code: [Select]

REPAIR TABLE queue_log
You should check that data is still there after the repair - it's usually pretty safe but you never can tell.

This is not a QueueMetrics issue, of course, but a general MySQL sysadmin issue

Read this before attempting the repair: http://dev.mysql.com/doc/refman/5.0/en/table-maintenance.html

[cuban_cigar]

Thanks for the reply, it seems to have worked.