[asterisk-bugs] [JIRA] (ASTERISK-16674) Random deadlock in res_config_mysql

[Matt Jordan (JIRA)]

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

Matt Jordan commented on ASTERISK-16674:
----------------------------------------

Please note that {{res_config_mysql}} is an extended support module. Developer resources for it typically come from the open source community. Response times may reflect that.
                
> Random deadlock in res_config_mysql
> -----------------------------------
>
>                 Key: ASTERISK-16674
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-16674
>             Project: Asterisk
>          Issue Type: Bug
>          Components: Addons/res_config_mysql
>            Reporter: Ricardo Landim
>            Severity: Minor
>         Attachments: asterisk-bt-full-20100916-153646.txt, asterisk-bt-full-20100916-153833.txt, asterisk-bt-full-20100916-154026.txt, asterisk-bt-full-20100917-111315.txt
>
>
> Asterisk randomly stops processing SIP calls. I cannot find a pattern of external events triggering it. I have around 700 registers in realtime....
> Asterisk version 1.4.32
> I have compiled asterisk with DEBUG_THREADS. When this happers 'core show locks' presents this... I am reporting 4 events (core show locks)...
> I believe this bug is the same issue ASTERISK-14113 (fixed for 1.6.x but not fixed for 1.4.x)
> ****** ADDITIONAL INFORMATION ******
> Event 1)
> =======================================================================
> === Currently Held Locks ==============================================
> =======================================================================
> ===
> === <file> <line num> <function> <lock name> <lock addr> (times locked)
> ===
> === Thread ID: -1213891696 (do_monitor           started at [17123] chan_sip.c restart_monitor())
> === ---> Lock #0 (chan_sip.c): MUTEX 16790 sipsock_read &netlock 0xb7b06140 (1)
> === ---> Lock #1 (chan_sip.c): MUTEX 4873 find_call &p->lock 0x90f1f58 (1)
> === ---> Lock #2 (res_config_mysql.c): MUTEX 330 update_mysql &mysql_lock 0xb7601680 (1)
> === -------------------------------------------------------------------
> ===
> =======================================================================
> Event 2)
> =======================================================================
> === Currently Held Locks ==============================================
> =======================================================================
> ===
> === <file> <line num> <function> <lock name> <lock addr> (times locked)
> ===
> === Thread ID: -1213334640 (do_monitor           started at [17123] chan_sip.c restart_monitor())
> === ---> Lock #0 (chan_sip.c): MUTEX 17069 do_monitor &monlock 0xb7b8de80 (1)
> === ---> Lock #1 (res_config_mysql.c): MUTEX 330 update_mysql &mysql_lock 0xb7689680 (1)
> === -------------------------------------------------------------------
> ===
> === Thread ID: -1229177968 (pbx_thread           started at [ 2645] pbx.c ast_pbx_start())
> === ---> Waiting for Lock #0 (chan_sip.c): MUTEX 17112 restart_monitor &monlock 0xb7b8de80 (1)
> === --- ---> Locked Here: chan_sip.c line 17069 (do_monitor)
> === -------------------------------------------------------------------
> ===
> =======================================================================
> Event 3)
> =======================================================================
> === Currently Held Locks ==============================================
> =======================================================================
> ===
> === <file> <line num> <function> <lock name> <lock addr> (times locked)
> ===
> === Thread ID: -1213777008 (do_monitor           started at [17123] chan_sip.c restart_monitor())
> === ---> Lock #0 (chan_sip.c): MUTEX 16790 sipsock_read &netlock 0xb7b22140 (1)
> === ---> Lock #1 (chan_sip.c): MUTEX 4873 find_call &p->lock 0x8458da8 (1)
> === ---> Lock #2 (res_config_mysql.c): MUTEX 330 update_mysql &mysql_lock 0xb761d680 (1)
> === -------------------------------------------------------------------
> ===
> =======================================================================
> Event 4)
> =======================================================================
> === Currently Held Locks ==============================================
> =======================================================================
> ===
> === <file> <line num> <function> <lock name> <lock addr> (times locked)
> ===
> === Thread ID: -1211081840 (do_devstate_changes  started at [  363] devicestate.c ast_device_state_engine_init())
> === ---> Waiting for Lock #0 (res_config_mysql.c): MUTEX 115 realtime_mysql &mysql_lock 0xb760f680 (1)
> === --- ---> Locked Here: res_config_mysql.c line 330 (update_mysql)
> === -------------------------------------------------------------------
> ===
> === Thread ID: -1213834352 (do_monitor           started at [17123] chan_sip.c restart_monitor())
> === ---> Lock #0 (chan_sip.c): MUTEX 16790 sipsock_read &netlock 0xb7b14140 (1)
> === ---> Lock #1 (chan_sip.c): MUTEX 4873 find_call &p->lock 0x8bc45f8 (1)
> === ---> Lock #2 (res_config_mysql.c): MUTEX 330 update_mysql &mysql_lock 0xb760f680 (1)
> === -------------------------------------------------------------------
> ===
> =======================================================================

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira