Home / server / Questions / 641174
Accepted
Milos Cuculovic
Asked: 2014-11-01 07:38:14 +0800 CST

MySQL crashed and was not able to restart until clearing a table

  • 772

I have MySQL running on my Ubuntu server and suddenly the MySQL Daemon was down. When trying to restart it, the restart failed due to

xxx table is marked as crashed and last (automatic ) repair failed

So then I have to truncate the table, restart MySQL and everything was fine. We had backups so we were able to recover.

Any idea why this happens and how to check what caused this?

linux

1 Answers

  1. Best Answer

    Have a look in the error log, which would usually record a crash stacktrace . The location can be found with:

    $ mysql -e 'show variables like "log_error"'
+---------------+--------------------------+
| Variable_name | Value                    |
+---------------+--------------------------+
| log_error     | /var/log/mysql/error.log |
+---------------+--------------------------+

    The cause can be anything from a bug in a storage engine to faulty hardware. If it repeats, you could enable query logging and try to determine whether a particular query is causing the crash.

    Also, check whether you are using the latest stable mySQL packages.

    • 0