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

[Joshua Colp (JIRA)]

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

Joshua Colp commented on ASTERISK-26601:
----------------------------------------

Unless you are using a unixODBC version greater than 2.3.1 I do not recommend enabling multiple connections like you've done. The older versions do not handle it well at all and can crash as well as corrupt memory. Using the latest version of everything would work.

> 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: Unassigned
>         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)