QueueMetrics forum

QueueMetrics => Running QueueMetrics => Topic started by: cuban_cigar on May 09, 2009, 00:56:10

Title: table queuemetrics/queue_log is marked as crashed and should be repaired[solved]
Post by: cuban_cigar on May 09, 2009, 00:56:10

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?

Title: Re: "table queuemetrics/queue_log is marked as crashed and should be repaired"
Post by: QueueMetrics on May 10, 2009, 19:49:50

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

Title: Re: "table queuemetrics/queue_log is marked as crashed and should be repaired"
Post by: cuban_cigar on May 11, 2009, 18:41:41

Thanks for the reply, it seems to have worked.