Asterisk Error cdr_mysql.c: Unable to query table description!! Logging disabled.
-
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
-
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.
-
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.
-
For SEO reasons, what had prompted this was finding:
./asterisk status asterisk dead but subsys locked