Kvstore’ is marked as crashed and last (automatic?) repair failed

FYI, I was fighting this error on a Rapberry Pi and mysqlcheck wouldn’t fix it - I kept getting “error : Not enough memory for blob”…

Thankfully https://b2l.com/freepbx-table-asteriskkvstore-is-marked-as-crashed-and-last-automatic-repair-failed/ came to my rescue with this solution:

service mysqld stop
cd /var/lib/mysql/asterisk/
myisamchk -o kvstore.MYI --sort_buffer_size=1G --max-record-length=$((1024*1024))
service mysqld restart
1 Like

Is this the preferred solution to this issue, just got this after normal shutdown and restart of VM guest (ESXi 5.5) and FreePBX v13 (CENTOS)?

PDOException
SQLSTATE[HY000]: General error: 1194 Table ‘kvstore’ is marked as crashed and should be repaired
File:/var/www/html/admin/libraries/BMO/DB_Helper.class.php:354

service mysqld stop
cd /var/lib/mysql/asterisk/
myisamchk -o kvstore.MYI --sort_buffer_size=1G --max-record-length=$((1024*1024))
service mysqld restart

Found the solution in another post - [quote=“jfinstrom, post:2, topic:24405, full:true”]
mysqlcheck --repair --all-databases
[/quote]