Summary:ASTERISK-14630: Asterisk Network Connectivity Stops when MySQL Server Not Available
Reporter:Leo Brown (netfuse)Labels:
Date Opened:2009-08-11 02:58:17Date Closed:2011-06-07 14:08:12
Versions:Frequency of
Description:We have found that if the MySQL server dies, all Asterisk servers are found with console messages 'maximum retries exceeded' to ALL relevant hosts. The server is mostly unresponsive and Asterisk needs a restart to become useful again. Unloading cdr_addon_mysql.so resolves it until the MySQL server is back up.

I am happy to provide more data but at this time can not think of anything that could be particularly helpful. I know of no reason why Asterisk would stall because of the CDR engine's delays.
Comments:By: Leif Madsen (lmadsen) 2009-08-17 12:54:16

I know this isn't really the answer you want, but I'd suggest trying out writing these CDRs via the ODBC engine as it is much more reliable and better able to handle database outages and reconnecting.

By: Leif Madsen (lmadsen) 2009-08-20 14:37:31

I'm closing this issue due to lack of response. Really, the MySQL stuff from addons isn't really all that great compared to the ODBC implementations, so I would suggest you use that.