[OpenSIPS-Users] cdr accounting on opensips restart

Jayesh Nambiar jayesh.voip at gmail.com
Wed Dec 7 13:27:22 CET 2011 

Hi Razwan,
This is the pastebin of logs after shutdown:
http://pastebin.com/tvmrSqwB

This is the pastebin of logs after start which is huge:
http://pastebin.com/C6K4Jt5y

--- Jayesh


On Wed, Dec 7, 2011 at 5:46 PM, Razvan Crainea
<razvancrainea at opensips.org>wrote:

>  Hi, Jayesh!
>
> I need the logs after opensips restarts. The result might also be pretty
> large.
>
>
> Regards,
>
> --
> Răzvan Crainea
> OpenSIPS Developer
>
>
> On 12/07/2011 02:14 PM, Jayesh Nambiar wrote:
>
> Hi Razwan,
> I have applied the patch and made it working. Do you still only need the
> logs after opensips shutdown or also the logs after opensips restarts.
>
> --- Jayesh
>
> On Wed, Dec 7, 2011 at 4:35 PM, Razvan Crainea <razvancrainea at opensips.org
> > wrote:
>
>>  Hi, Jayesh!
>>
>> It seems like the problem appears while parsing the string got from the
>> database, so after opensips is restarted. The patch attached should give us
>> more information about the error.
>>
>>
>> Regards,
>>
>> --
>> Răzvan Crainea
>> OpenSIPS Developer
>>
>>
>>   On 12/07/2011 12:37 PM, Jayesh Nambiar wrote:
>>
>> This is the string what I see when I query the dialog table for vars:
>>
>> accX_flags#   |accX_db#(  2 1
>>  1000000001 1002
>>                  12013386166
>>  919833171405 0 203.153.53.158 203.153.53.136 0 17 0 2 IP India - Mobile
>> 919 9198 2 1 2 4 0.0150 0.0130 0 0.0000 0.0226 1.0000 6 1 6 1 1 2 2 2
>>  Aal Izz Well
>>  Aal Izz Well 1 3 1.2.3.4|accX_leg#    |accX_core# INVITE/
>> 100eb870-9e3599cb-13c4-50029-3b71-60de50d0-3b71\#
>> 97.208.30.751120+1+31850054+b8c0a68/
>> 100f7670-9e3599cb-13c4-50029-3b71-3c625412-3b71 200 O á=ÃN
>> |accX_created#Ã=ÃN    |
>>
>> --- Jayesh
>>
>> On Wed, Dec 7, 2011 at 4:00 PM, Razvan Crainea <
>> razvancrainea at opensips.org> wrote:
>>
>>>  Hi, Jayesh!
>>>
>>> And what is the string in the database? You can see it in the database
>>> after you kill opensips with the following command:
>>>
>>> select vars from dialog;
>>>
>>>
>>> Regards,
>>>
>>> --
>>> Răzvan Crainea
>>> OpenSIPS Developer
>>>
>>>
>>>   On 12/07/2011 12:24 PM, Jayesh Nambiar wrote:
>>>
>>> Hi Razvan,
>>> Applied the patch and re-tested it. Here the logs that you are
>>> interested in specifically:
>>>
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: Dumping var name: <accX_flags> value: <#026>
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: compare char 22 - 0 - 11
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: compare char 0 - 1 - 12
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: compare char 0 - 2 - 13
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: compare char 0 - 3 - 14
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: Serialized string <accX_flags##026> (16)
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 0) char: a hex: 61
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 1) char: c hex: 63
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 2) char: c hex: 63
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 3) char: X hex: 58
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 4) char: _ hex: 5F
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 5) char: f hex: 66
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 6) char: l hex: 6C
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 7) char: a hex: 61
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 8) char: g hex: 67
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 9) char: s hex: 73
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 10) char: # hex: 23
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 11) char: #026 hex: 16
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 12) char: #000 hex: 00
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 13) char: #000 hex: 00
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 14) char: #000 hex: 00
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: 15) char: | hex: 7C
>>> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]:
>>> DBG:dialog:write_pair: Dumping var name: <accX_db> value: <(>
>>>
>>> Apart from this, I have pasted everything in syslog after opensips
>>> shutdown in the paste-bin here:
>>> http://pastebin.com/gx0ZxFLb
>>>
>>> Let me know if there is anything more to test.
>>>
>>> --- Jayesh
>>>
>>> On Wed, Dec 7, 2011 at 3:36 PM, Razvan Crainea <
>>> razvancrainea at opensips.org> wrote:
>>>
>>>>  Sorr, I forgot to attach it. Here it is.
>>>>
>>>>
>>>> Regards,
>>>>
>>>> --
>>>> Răzvan Crainea
>>>> OpenSIPS Developer
>>>>
>>>>
>>>>   On 12/07/2011 11:59 AM, Jayesh Nambiar wrote:
>>>>
>>>> Hi Razvan,
>>>> I don't see the patch attached !!
>>>>
>>>> --- Jayesh
>>>>
>>>> On Wed, Dec 7, 2011 at 2:57 PM, Razvan Crainea <
>>>> razvancrainea at opensips.org> wrote:
>>>>
>>>>>  Hi, Jayesh !
>>>>>
>>>>> The root of the problem is the accX_flags dialog variable isn't
>>>>> properly serialized. What I'm trying to find out is why this happens,
>>>>> that's why I will need some extra debug as I can't figure out the problem
>>>>> there. So please apply this last patch and try again. It should be applied
>>>>> after the previous patch I've sent you, so you won't need another fresh
>>>>> checkout.
>>>>> This time there will be a lot of dumped info in the log, so I would
>>>>> really appreciate if you could send them over pastebin. The only part that
>>>>> I will be interested in is between these lines:
>>>>>
>>>>>
>>>>> DBG:dialog:write_pair: Dumping var name: <accX_flags> value: <#026>
>>>>>
>>>>>  and
>>>>>
>>>>>
>>>>> DBG:dialog:write_pair: Dumping var name: <accX_db> value: <(>
>>>>>
>>>>>  Thank you very much for testing!
>>>>>  Regards,
>>>>>
>>>>> --
>>>>> Răzvan Crainea
>>>>> OpenSIPS Developer
>>>>>
>>>>>
>>>>>   On 12/06/2011 07:57 PM, Jayesh Nambiar wrote:
>>>>>
>>>>> Hi Razvan,
>>>>> I just did a fresh download from
>>>>> http://opensips.org/pub/opensips/latest/src/. I did apply the patch
>>>>> successfully and I still have the problem of CDR not being recorded after
>>>>> restart. Here is the syslog pasted after opensips was being shut down:
>>>>>
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[
>>>>> 15700]: DBG:dialog:dialog_update_db: inserting new dialog
>>>>> 0x7f3d323bd5f8
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Dumping var name: <accX_flags> value: <#026>
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Serialized string <accX_flags##026> (16)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Dumping var name: <accX_db> value: <(>
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Serialized string <accX_db#(> (263)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Dumping var name: <accX_leg> value: <>
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Serialized string <accX_leg#> (14)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Dumping var name: <accX_core> value: <#006>
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: escaping char 53
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Serialized string <accX_core##006> (165)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Dumping var name: <accX_created> value: <<95>+ÃN>
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Serialized string <accX_created#<95>+ÃN> (22)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_dialog_vars: var string is <accX_flags##026>(480)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Dumping var name: <carrierChannels> value: <1002>
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Serialized string <carrierChannels#1002|> (21)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Dumping var name: <carrierChannels> value: <1003>
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Serialized string <carrierChannels#1003|> (21)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Dumping var name: <carrierChannels> value: <1007>
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_pair: Serialized string <carrierChannels#1007|> (21)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:dialog:write_dialog_profiles: profile string is
>>>>> <carrierChannels#1002|carrierChannels#1003|carrierChannels#1007|>(63)
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:db_mysql:has_stmt_ctx: ctx found for dialog
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: conn=0x810858 (tail=8454488)
>>>>> MC=0x8101b8
>>>>> Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run
>>>>>
>>>>> I hope this will help you figure out something more relevant.
>>>>>
>>>>>
>>>>> --- Jayesh
>>>>>
>>>>>
>>>>> On Tue, Dec 6, 2011 at 7:56 PM, Razvan Crainea <
>>>>> razvancrainea at opensips.org> wrote:
>>>>>
>>>>>>  Hi, Jayesh!
>>>>>>
>>>>>> Can you post your dlg_db_handler.c file on pastebin? I think you are
>>>>>> using an old version of the dialog module, and that's why you have this
>>>>>> problem.
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> --
>>>>>> Răzvan Crainea
>>>>>> OpenSIPS Developer
>>>>>>
>>>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20111207/380c1cbb/attachment-0001.htm>

More information about the Users mailing list