[asterisk-bugs] [JIRA] (ASTERISK-25455) Deadlock of PJSIP realtime over res_config_pgsql

[Richard Mudgett (JIRA)]

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

Richard Mudgett commented on ASTERISK-25455:
--------------------------------------------

According to the backtrace the thread holding the reentrancy lock {{pgsql_lock}} is inside the {{libpq.so}} library and presumably waiting for a reply from the database since it is waiting in {{poll()}}.  You may have a connectivity problem with your database or there is a bug in the {{libpq.so}} library itself.

When you enable debug logging do you see the following message?
{noformat}
PostgreSQL query attempt %d failed, trying again
{noformat}

It could be that you have so many database queries on startup that they just take more time to complete.


> Deadlock of PJSIP realtime over res_config_pgsql 
> -------------------------------------------------
>
>                 Key: ASTERISK-25455
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25455
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Channels/chan_pjsip, Resources/res_config_pgsql, Resources/res_pjsip
>    Affects Versions: 13.5.0, 13.6.0
>         Environment: linux 64bit
> kernel 3.10.17
> distro slackware64 14.1 
>            Reporter: mdu113
>            Assignee: Unassigned
>         Attachments: backtrace-threads2.txt, core-show-locks2.txt, core-show-locks.txt, lock-bt-full.txt
>
>
> Asterisk intermittently deadlocks during initial loading of pjsip endpoints. It seems to depend on number of endpoints loaded. With small number of endpoints (up to a 100) it loads ok most of the time. With several hundreds of endpoints it deadlocks sometimes. With several thousand of endpoints it deadlocks most of the time.
> Attached are backtrace and output of "core show locks". The testing was done on asterisk 13.6.0-rc2



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