R.I.P. FATAL ERROR - FreePBX is Unable to Continue message at Login

[howie954]

I am getting the message below all of a sudden. I am also using the latest and greatest: INCREDIBLE PBX 13 WITH RASPBIAN 8 "JESSIE" FOR RASPBERRY PI 2 & 3 on the Pi 2 which has been working perfect and flawlessly up until now. Strange enough, I had a similar issue not long ago using the previous Rasbian version. Any ideas anyone? I do have an image backup of this image to revert to if necessary but I would really like to solve this issue.

FATAL ERROR

FreePBX is Unable to Continue

SQLSTATE[HY000]: General error: 144 Table './asterisk/kvstore' is marked as crashed and last (automatic?) repair failed

Trace Back

/var/www/html/admin/libraries/BMO/DB_Helper.class.php:62 PDO->query()
[0]: SELECT * FROM `kvstore` LIMIT 1

/var/www/html/admin/libraries/BMO/DB_Helper.class.php:132 DB_Helper::checkDatabase()

/var/www/html/admin/libraries/BMO/Hooks.class.php:24 DB_Helper->getConfig()
[0]: hooks

/var/www/html/admin/libraries/BMO/GuiHooks.class.php:206 Hooks->getAllHooks()

/var/www/html/admin/config.php:312 GuiHooks->doConfigPageInits()
[0]: noauth
[1]:

 

[dicko]

http://stackoverflow.com/questions/4582832/repair-all-tables-in-one-go

but just expect that sort of thing to happen on a raspberry if you don't move the file system to something more robust than an sd card

 

[howie954]

I followed the instructions on stack overflow:

mysqlcheck -u root -p --auto-repair --check --all-databases

but I get this error:

mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

and I know I am using the correct password.

 

[dicko]

I would have to respectfully disagree, did you set a mysql password for the root user? if you did it will work, if you didn't then leave out the -p

 

[wardmundy]

Try:

mysqlcheck -u root -ppassw0rd --auto-repair --check --all-databases

 

[howie954]

OK, so I gave that a try. It checked a lot and I see a lot of OK's but this is what I get in two areas:

warning : Table is marked as crashed and last repair failed
warning : 1 client is using or hasn't closed the table properly
warning : Size of indexfile is: 28672 Should be: 4096
error : Found too long record (837) at 129584
error : Corrupt



Repairing tables
asterisk.kvstore
info : Found block with too small length at 129584; Skipped
info : Found block that points outside data file at 132244
info : Found block that points outside data file at 132608
error : Not enough memory for blob at 132708 (need 1044656732)
info : Found block with too small length at 129584; Skipped
info : Found block that points outside data file at 132244
info : Found block that points outside data file at 132608
error : Not enough memory for blob at 132708 (need 1044656732)
status : Operation failed


Then when trying to login from the Web Gui I get the same error which I posted about.

 

[wardmundy]

That's what backups are for.

 

[howie954]

Oh yes I know and i do maintain an image backup. I just wish I knew how to avoid this from happening again if there is a way.

 

[wardmundy]

Might want to switch brands of microSD cards. We have some SanDisk and Kingston cards that have been chugging along well over 2 years with nightly reboots.

 

[howie954]

That is exactly what I am using but you know, the Raspberry Pi was great for the learning experience and introduction to all this, I am beginning to see that the best way to go is with the Virtual Machines. At this very moment I am going through your nerdvittles tut:

http://nerdvittles.com/?p=16791

 

[wardmundy]

Just be aware that CloudAtCost VMs crash about as frequently as SDcards. For reliability, Digital Ocean for $5/mo. with automatic backups for an extra dollar is hard to beat and in a completely different league from CloudAtCost.

 

[howie954]

I see what you mean on that. They still accepting the TAKE70 so I went for it anyway, after all, in any case how can you go wrong for $10.50 I take it as just a learning experience. It's like having a crappy PC when I need it for a few bucks. They are definitely slow, reboot time is so long and it shows that my memory usage is like 51%

I love Vitelity but they so expensive.