[OpenSIPS-Users] Opensips fifo - dp_reload hangs

[Bogdan-Andrei Iancu]

Hi Dan,

As expected, the "debug" function strikes again (some unhandled  return 
if data was null was causing a deadlock)..

Fixed, tested and backported to 1.5.

Thanks again for your help,

Regards,
Bogdan

Dan-Cristian Bogos wrote:
> Hi Bogdan,
>
> I have updated to trunk and tested again. Here is what I found out:
>
> * First "dp_reload" is successful.
> * Second "dp_reload" hangs, even for empty dialplan table.
>
> Let me know if you need any further tests.
>
> Ta,
> DanB
>
>
> On Mon, 2009-04-06 at 19:14 +0300, Bogdan-Andrei Iancu wrote:
>   
>> Hi Dan,
>>
>> I found the bug and fixed it - for the moment the fix is on trunk only 
>> and if you could test it before backport to 1.5, it will be great.
>>
>> Thanks and regards,
>> Bogdan
>>
>> Dan-Cristian Bogos wrote:
>>     
>>> Hi Bogdan,
>>>
>>> I have managed to make some more tests for the "dp_reload" issue, and came out the following:
>>>
>>> * The issue is not server dependent. I have installed an opensips server on a completely different machine with different architecture, and same issue came up again.
>>> * The issue is not data dependent. On the test machine I have emptied completely the dialplan table and issued a dp_reload command, same thing happened, fifo was destroyed and the command hanged (tried other commands later and no response).
>>> * "dp_translate" command works fine.
>>>
>>> Bellow you can find the debug for the "dp_reload" with empty dialplan table in the database. 
>>>
>>> Can u try my scenario in your labs? I am not doing anything specific, so if this is a bug, it can be common one.
>>>
>>> Ta,
>>> DanB
>>>
>>> wtdev1:/etc/opensips# opensipsctl fifo dp_reload
>>> Apr  6 13:53:27 [8508] DBG:mi_fifo:mi_fifo_server: entered consume
>>> Apr  6 13:53:27 [8508] DBG:mi_fifo:mi_fifo_server: **** done consume
>>> Apr  6 13:53:27 [8508] DBG:mi_fifo:mi_fifo_server: done parsing the mi tree
>>> Apr  6 13:53:27 [8508] DBG:dialplan:dp_load_db: init
>>> Apr  6 13:53:27 [8508] DBG:core:db_do_query: SYNC-DBG - SELECT successfully executed!
>>> Apr  6 13:53:27 [8508] DBG:core:db_new_result: allocate 28 bytes for result set at 0x8174dc8
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: 8 columns returned from the query
>>> Apr  6 13:53:27 [8508] DBG:core:db_allocate_columns: allocate 128 bytes for result columns at 0x8174e60
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8174e80)[0]=[dpid]
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: use DB_INT result type
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8174e88)[1]=[pr]
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: use DB_INT result type
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8174e90)[2]=[match_op]
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: use DB_INT result type
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8174e98)[3]=[match_exp]
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8174ea0)[4]=[match_len]
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: use DB_INT result type
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8174ea8)[5]=[subst_exp]
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8174eb0)[6]=[repl_exp]
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8174eb8)[7]=[attrs]
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
>>> Apr  6 13:53:27 [8508] DBG:db_mysql:db_mysql_fetch_result: no rows returned from the query
>>> Apr  6 13:53:27 [8508] WARNING:dialplan:dp_load_db: no data in the db
>>>
>>>
>>>
>>>
>>>   
>>>       
>
>
>