Mysql Repair Table

[crisward]

After a crash of the host machine, my mariadb instances are crash. I can't connect with mariadb:console, I just get the following error.

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

The logs say the following.

150223 16:04:17 [Note] Server socket created on IP: '0.0.0.0'.
150223 16:04:17 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired
150223 16:04:17 [ERROR] mysqld: Table 'user' is marked as crashed and should be repaired
150223 16:04:17 [Warning] Checking table:   './mysql/user'
150223 16:04:17 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly
150223 16:04:17 [Warning] 'user' entry 'root@dd40882ba0ea' ignored in --skip-name-resolve mode.
150223 16:04:17 [Warning] 'proxies_priv' entry '@ root@dd40882ba0ea' ignored in --skip-name-resolve mode.
150223 16:04:17 [Note] Event Scheduler: Loaded 0 events
150223 16:04:17 [Note] /usr/sbin/mysqld: ready for connections

Any ideas how to recover from this. I could rebuild from a backup (this is just a dev server). However if there is a way of recovering from this, it would could prove very useful. If not, if there is anything I can contribute to making this repairable, I'd be happy to help.

[alfredkam]

this issue should be related to #16, happens after reboot. You should try using the docker mariadb - https://github.com/dockerfile/mariadb, and create a docker container and have ur app connect to it.