asterisk users - Jun 2006 - shutting down a mysql server renders cdr_mysql dead and asterisk nolonger makes or receives calls

At approximately 3:15pm I shut down the office MySQL server to change
out some hardware.  Shortly after I received a call from one of two
customers whose asterisk servers output CDR data to that server.  They
could not place or receive calls.  Shortly after that I received a call
from the other customer.  I'm below providing output from the message
log (At debug level).  I don't see much of use and would greatly
appreciate any help that could be given.

Andrew


Jun  9 15:16:05 ERROR[29101] cdr_addon_mysql.c: cdr_mysql: Unknown
connection error: (2013) Lost connection to MySQL server during query
Jun  9 15:29:49 ERROR[29382] cdr_addon_mysql.c: cdr_mysql: Unknown
connection error: (2013) Lost connection to MySQL server during query
Jun  9 15:31:51 WARNING[4918] channel.c: Avoided initial deadlock for
'0x2aaab35009c0', 10 retries!
Jun  9 15:31:51 WARNING[4918] channel.c: Avoided initial deadlock for
'0x2aaab35009c0', 10 retries!
Jun  9 15:32:58 ERROR[29382] cdr_addon_mysql.c: cdr_mysql: cannot
connect to database server 208.64.32.55.
Jun  9 15:36:08 ERROR[29647] cdr_addon_mysql.c: cdr_mysql: cannot
connect to database server 208.64.32.55.
Jun  9 15:36:08 NOTICE[4928] pbx.c: Cannot find extension context
'did-incomig'
Jun  9 15:39:41 ERROR[29796] cdr_addon_mysql.c: cdr_mysql: cannot
connect to database server 208.64.32.55.
Jun  9 16:19:21 NOTICE[22239] cdr.c: CDR simple logging enabled.
Jun  9 16:19:22 WARNING[22239] cdr_addon_mysql.c: MySQL database sock
file not specified.  Using default
Jun  9 16:19:23 WARNING[22239] pbx_config.c: No closing parenthesis
found? 'MeetMe(50667|Msipr}'
Jun  9 16:19:23 WARNING[22239] pbx_config.c: No closing parenthesis
found? 'MeetMe(31391|Msipr}'
Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
'50667', priority 1 in 'did-incoming', already in use
Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
extension at line 103
Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
'82612', priority 1 in 'did-incoming', already in use
Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
extension at line 104
Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
'61908', priority 1 in 'did-incoming', already in use
Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
extension at line 105
Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
'24104', priority 1 in 'did-incoming', already in use
Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
extension at line 106
Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
'83416', priority 1 in 'did-incoming', already in use
Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
extension at line 107
Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
'90780', priority 1 in 'did-incoming', already in use
Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
extension at line 108
Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
'77252', priority 1 in 'did-incoming', already in use
Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
extension at line 110
Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
'77604', priority 1 in 'did-incoming', already in use
Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
extension at line 111
Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
'25647', priority 1 in 'did-incoming', already in use
Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
extension at line 112

well.. whats the question...

if you shut down an essential servic eof course you will have this..

its like saying i removed the drive and all crashed.



On 6/9/06, Andrew Kirch <akirch@allthingsit.com>
wrote:
>
> At approximately 3:15pm I shut down the office MySQL server to change
> out some hardware.  Shortly after I received a call from one of two
> customers whose asterisk servers output CDR data to that server.  They
> could not place or receive calls.  Shortly after that I received a call
> from the other customer.  I'm below providing output from the message
> log (At debug level).  I don't see much of use and would greatly
> appreciate any help that could be given.
>
> Andrew
>
>
> Jun  9 15:16:05 ERROR[29101] cdr_addon_mysql.c: cdr_mysql: Unknown
> connection error: (2013) Lost connection to MySQL server during query
> Jun  9 15:29:49 ERROR[29382] cdr_addon_mysql.c: cdr_mysql: Unknown
> connection error: (2013) Lost connection to MySQL server during query
> Jun  9 15:31:51 WARNING[4918] channel.c: Avoided initial deadlock for
> '0x2aaab35009c0', 10 retries!
> Jun  9 15:31:51 WARNING[4918] channel.c: Avoided initial deadlock for
> '0x2aaab35009c0', 10 retries!
> Jun  9 15:32:58 ERROR[29382] cdr_addon_mysql.c: cdr_mysql: cannot
> connect to database server 208.64.32.55.
> Jun  9 15:36:08 ERROR[29647] cdr_addon_mysql.c: cdr_mysql: cannot
> connect to database server 208.64.32.55.
> Jun  9 15:36:08 NOTICE[4928] pbx.c: Cannot find extension context
> 'did-incomig'
> Jun  9 15:39:41 ERROR[29796] cdr_addon_mysql.c: cdr_mysql: cannot
> connect to database server 208.64.32.55.
> Jun  9 16:19:21 NOTICE[22239] cdr.c: CDR simple logging enabled.
> Jun  9 16:19:22 WARNING[22239] cdr_addon_mysql.c: MySQL database sock
> file not specified.  Using default
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: No closing parenthesis
> found? 'MeetMe(50667|Msipr}'
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: No closing parenthesis
> found? 'MeetMe(31391|Msipr}'
> Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
> '50667', priority 1 in 'did-incoming', already in use
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
> extension at line 103
> Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
> '82612', priority 1 in 'did-incoming', already in use
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
> extension at line 104
> Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
> '61908', priority 1 in 'did-incoming', already in use
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
> extension at line 105
> Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
> '24104', priority 1 in 'did-incoming', already in use
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
> extension at line 106
> Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
> '83416', priority 1 in 'did-incoming', already in use
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
> extension at line 107
> Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
> '90780', priority 1 in 'did-incoming', already in use
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
> extension at line 108
> Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
> '77252', priority 1 in 'did-incoming', already in use
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
> extension at line 110
> Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
> '77604', priority 1 in 'did-incoming', already in use
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
> extension at line 111
> Jun  9 16:19:23 WARNING[22239] pbx.c: Unable to register extension
> '25647', priority 1 in 'did-incoming', already in use
> Jun  9 16:19:23 WARNING[22239] pbx_config.c: Unable to register
> extension at line 112
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> Asterisk-Users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>


-- 
Mike
Sales Manager
http://www.theclubvoip.com
Making it happen
1.888.470.7253
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20060609/56f696ea/attachment.htm

Well, it looks like you have realtime DB. The errors appear to be because it
couldn't connect to the DB to resolve the extensions that the people were
entering.

bp


On 6/9/06, Andrew Kirch <akirch@allthingsit.com>
wrote:
>
> At approximately 3:15pm I shut down the office MySQL server to change
> out some hardware.  Shortly after I received a call from one of two
> customers whose asterisk servers output CDR data to that server.  They
> could not place or receive calls.  Shortly after that I received a call
> from the other customer.  I'm below providing output from the message
> log (At debug level).  I don't see much of use and would greatly
> appreciate any help that could be given.
>
> Andrew
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20060609/d7fe35ef/attachment.htm