vicidial.org

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..

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.