[asterisk-bugs] [JIRA] Commented: (ASTERISK-4628) asterisk freeze if mySQL server unreachable

[Ksenia (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-4628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=197320#comment-197320 ] 

Ksenia commented on ASTERISK-4628:
----------------------------------

I have a similar issue - when mySQL server becomes unreachable, it's impossible to make and take calls. Only unloading of cdr_mysql module helps while the server is unreachable. When I connect to the console of course there are messages like 'cannot connect to database ...'. I can provide any information which can be helpfull to resolve this issue. I'm using asterisk 1.8.15.0 on Gentoo. 

> asterisk freeze if mySQL server unreachable
> -------------------------------------------
>
>                 Key: ASTERISK-4628
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-4628
>             Project: Asterisk
>          Issue Type: Bug
>          Components: CDR/General
>            Reporter: Matthew Simpson
>            Severity: Minor
>
> If mySQL server dies/unreachable, Asterisk freezes and has to be kill'ed -9.  
> ****** ADDITIONAL INFORMATION ******
> I will pay a bounty to anyone willing to fix this steaming pile.  For bounty to be paid:
> * patch must be entered into CVS-HEAD
> * patch must be able to gracefully handle a SQL server going away. I'm open to ideas on how best to do this, but at a minimum no CDRs should be lost [cached somewhere until SQL write can occur], and there should be a way to poke the CDR_mysql process to attemt to make a new connection to mysql and start processing CDRs again if a replication slave has to take over processing
> * patch should move CDR processing out of main asterisk thread to keep problems from hosing asterisk
> email me at matthew at txlink.net to set up payment arrangements and value of bounty.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira