Asterisk Error cdr_mysql.c: Unable to query table description!! Logging disabled.

scottalanmiller

Asterisk is failing to start on an Elastix 2.4 system. The only error that I see before the process fails is this...

cdr_mysql.c: Unable to query table description!!  Logging disabled.

This was the last line in /var/log/asterisk/full

scottalanmiller

Looks like it was an easy fix. Part of the MySQL database had become corrupted.

Had to stop Asterisk, log into the MySQL console and do this...

repair table asteriskcdrdb.cdr;
quit;

and then /etc/init.d/asterisk start and all looked well.

scottalanmiller

In this case, the drive had filled up at some point and the database corrupted as it was open and was unable to complete writes. Then after the system was rebooted sometime later the database was unable to load the tables. So basically simple file corruption but a little hard to find.

scottalanmiller

For SEO reasons, what had prompted this was finding:

./asterisk status
asterisk dead but subsys locked