crashed Mysql table on vicidial.

[ruben23]

Hi i have a muti server setup for vicidial 1 asterisk server running Asterisk 1.2.30.2 and a Databased/webserver (mysql,Apache). Using codec g729 with ALL CALLS for record. Softphones for SIP.

Problem is with my servers are running on its peak suddenly i got major power failure problem and shut off my 2 servers automatically then when i run up back the server- i get problem of all list ID which i loaded thousand of leads from start of dial was all gone and zero, aside from it i vicidial wont accepty leads being loaded even set to duplicate. also got this error on mysql

[root@dbweb log]# tail -f mysqld.log
090826 3:23:01 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed
090826 3:23:01 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed
090826 3:24:02 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed
090826 3:24:02 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed
090826 3:25:01 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed
090826 3:25:01 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed
090826 3:26:01 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed
090826 3:26:01 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed
090826 3:27:02 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed
090826 3:27:02 [ERROR] /usr/libexec/mysqld: Table './asterisk/vicidial_list' is marked as crashed and last (automatic?) repair failed

any suggestion correcting such problem..

[mflorell]

There are several posts about this topic.

You need to do myisamchk on all of your tables while MySQL is down, then do a repair on all tables and all should be well. As long as you have free hardrive space that is.