SOLVED SQLSTATE[HY000]: General error: 145 Table './asterisk/kvstore' is marked as crashed and should be re

[kenn10]

Running FreePBX 12 on Asterisk 11 and PIAF Green. I've never seen this error before:

I had an accidental power loss to my PIAF server and now I get this message when I try to access the system via GUI. Asterisk is still running but I can't access FreePBX.

Any suggestions? I Googled and tried a few things listed but I get a message that root does not have access to the SQL tables.

 

[kenn10]

SOLVED with the following command line:

mysqlcheck --repair --all-databases --password=passw0rd

 

[cfvasquez]

SOLVED with the following command line:

mysqlcheck --repair --all-databases --password=passw0rd

------------------------------------------------------------------------------------
My setup:
Ast 11.3.0-rc1 FreePBX 12.0.1rc7
Incredible PBX 3.11.7 for Raspberry Pi B
RAM: 78060 54.61°C/130.29°F Disk: 3.4G
I have the same issue but the command did not work. Here is what I get:
+------------------+--------+----------+-----------------------------------------------------------------------------+
| asterisk.kvstore | repair | info | Found link that points at 4122259523532648563 (outside data file) at 196196 |
| asterisk.kvstore | repair | info | Found block with too small length at 202888; Skipped |
| asterisk.kvstore | repair | info | Found block with too small length at 335408; Skipped |
| asterisk.kvstore | repair | info | Found block that points outside data file at 340228 |
| asterisk.kvstore | repair | info | Found block that points outside data file at 342276 |
| asterisk.kvstore | repair | info | Found block that points outside data file at 343384 |
| asterisk.kvstore | repair | info | Found block that points outside data file at 343752 |
| asterisk.kvstore | repair | info | Found block with too small length at 451108; Skipped |
| asterisk.kvstore | repair | error | Not enough memory for blob at 456216 (need 2036888354) |
| asterisk.kvstore | repair | info | Found link that points at 4122259523532648563 (outside data file) at 196196 |
| asterisk.kvstore | repair | info | Found block with too small length at 202888; Skipped |
| asterisk.kvstore | repair | info | Found block with too small length at 335408; Skipped |
| asterisk.kvstore | repair | info | Found block that points outside data file at 340228 |
| asterisk.kvstore | repair | info | Found block that points outside data file at 342276 |
| asterisk.kvstore | repair | info | Found block that points outside data file at 343384 |
| asterisk.kvstore | repair | info | Found block that points outside data file at 343752 |
| asterisk.kvstore | repair | info | Found block with too small length at 451108; Skipped |
| asterisk.kvstore | repair | error | Not enough memory for blob at 456216 (need 2036888354) |
| asterisk.kvstore | repair | status | Operation failed |

+------------------+--------+----------+-----------------------------------------------------------------------------+

 

[xrobau]

The error's pretty self explanatory. You don't have enough memory.

This is often because you're on a small VM without any swap

 

[cfvasquez]

The error's pretty self explanatory. You don't have enough memory.

This is often because you're on a small VM without any swap

What I meant is how I can go about fixing the problem as I do understand the reason why its failing. What did not know based on your answer was that the asterisk version on the raspberry pi was a Virtual Machine as you mention in your reply. Can you take a second look at my problem and actually point me to a fix.