[asterisk-bugs] [JIRA] (ASTERISK-26601) res_odbc: Deadlock when getting connection

[Carl Fortin (JIRA)]

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

Carl Fortin commented on ASTERISK-26601:
----------------------------------------

We are using unixODBC 2.2.14. It's the latest available with yum under CentOS 6.However I was able to install the latest version from source on my test machine. I was thinking about updating it on my production system too. What about the mySQL engine ? Could it make a difference? We are using MyISAM.



> res_odbc: Deadlock when getting connection
> ------------------------------------------
>
>                 Key: ASTERISK-26601
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26601
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_voicemail, Resources/res_odbc, Resources/res_pjsip
>    Affects Versions: 14.1.1
>         Environment: Asterisk Realtime 14.1.0 rc1
> PJSIP Driver
> mysql Ver 5.1.73
> pjproject 2.5.5
> spandsp 0.0.6
> jansson 2.7
> CentOS 6.6 64 bits on Vmware
> Number of phones : 700
> Average concurrent calls: 16
>            Reporter: Carl Fortin
>            Assignee: Carl Fortin
>         Attachments: backtrace-threads_2.txt, backtrace-threads.txt, backtrace-threads.txt, backtrace-threads.txt, Channel_list.txt, Channel_list.txt, Channel_list.txt, Console_output.txt, Console_output.txt, Console_output.txt, core-show-locks.txt, core-show-locks.txt, core-show-locks.txt, core-show-locks.txt, Debug_Asterisk_Backtrace.sh, Debug_log.txt, extconfig.conf, full, full-log-before- restarting.txt, full.txt, messages.txt, messages.txt, ODBC pool.txt, res_odbc.conf, sorcery.conf, task_procesor.txt, Task_processors_list2.txt, Task_processors_list.txt, Task_processors_list.txt, Task_processors_list.txt, Task_processors_list.txt, Task_Processor_Starting_Asterisk.txt, top-output.txt, top-output.txt, voicemail.conf, voicemail_messages.sql, voicemail_users.sql
>
>
> I had Asterisk 14.1.0-rc1  running for 3 weeks, and all of the sudden PJSIP stopped working. Nothing in the console.
> I had time to save the task_processor output before restarting asterisk.
> After doing a restart to get the system back on I can see this in the log files:
> taskprocessor.c: The 'app_voicemail' task processor queue reached 500 scheduled tasks.
> I did not find any message concerning taskprocessor before the system stopped functioning.
> I'm aware that I am running an RC release, but looking at the release note, there were nothing concerning deadlock so I was thinking updating later.
>  



--
This message was sent by Atlassian JIRA
(v6.2#6252)