Nothing on CLI

[joylovebasu]

I have 10 agent logged in.

It was working perfectly.

All of sudden its NOT.

Manual calls going perfectly

When agents on dialer, nothing on CLI.

When booting it show an error :

etc/wanpipe/wanpipe.1 not found

What could be the problem ?

9 agents logged in on all servers
System Load Average: 0.08

[joylovebasu]

Error
SQL query:

SHOW INDEX FROM `call_log` ;


MySQL said:

#145 - Table './asterisk/call_log' is marked as crashed and should be repaired

[williamconley]

solution for now:
mysqlcheck --auto-repair --all-databases -p
may need to run more than once or perform other repairs as needed

solution for future:
is your hard drive full? delete everything in /var/log/astguiclient
did your system crash (power failure? "off" button?)
Uninterruptible Power Supply and put TAPE over the off button. ONLY use the console to issue a command to shut down so your sql tables won't be corrupted by an interrupted write.

Background:
Vicidial (like standard mysql) uses NORMAL sql tables which are NOT transaction safe. They can't be rolled back. An interrupted write will cause a crashed table, plain and simple. Easy to fix ... but annoying.