vicidial_list Table Crash again and again

[Riddhesh4]

Dear All,

We are using Vicidial 2.0.4 for Callcenter but we see that vicidial_list table is crash again and again. is there any solution to Repair Table permanently.

Please find the below details of server.

Centos 5.4 | Vicidial 2.0.4 Build 90320-0424 | Asterisk 1.4.21.2-vic | Single Server | Digium TE122 Hardware | No Extra Software After Installation | Intel(R) Core(TM)2 Quad CPU Q9550 @ 2.83GHz

Waiting for update.

[williamconley]

1) Please post your installation method (ie: Scratch with a link to your installation instructions or VicidialNOW or GoAutoDial with version).

2) If your hard drive is full, mysql will crash daily as it fills up the HD and then "loses" its log files which makes space available ... then you fix the table and run again and it crashes again when the log fills the HD. (In other words: Check your hard drive, is it full? or over 95%?)

3) There is no perma-fix, but reducing the size of your tables often helps reduce the likelihood of a crash, as does reducing use of the tables during reboot (and avoiding power outages). If you have tables with multiple millions of records, archiving those records (to the same table name with _archive at the end of it ... in case you need the data) may help. And of course, an upgrade to a version that has an archiving script would not hurt either (yep, later versions have a script you can activate to archive logs ...).