Author Topic: table queuemetrics/queue_log is marked as crashed and should be repaired[solved]  (Read 4562 times)

cuban_cigar

  • Newbie
  • *
  • Posts: 37
  • Karma: 0
    • View Profile
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?

« Last Edit: May 11, 2009, 19:16:06 by cuban_cigar »

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • 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
« Last Edit: May 12, 2009, 09:34:33 by QueueMetrics »

cuban_cigar

  • Newbie
  • *
  • Posts: 37
  • Karma: 0
    • View Profile
Thanks for the reply, it seems to have worked.
« Last Edit: May 11, 2009, 18:50:17 by cuban_cigar »