[OpenSIPS-Users] Stale dialogs not being deleted from DB (1.6.4)

[Alan Frisch]

Bogdan,

Looks like the problem has "fallen out" of the DB.  Not seeing any
more stale dialogs, but will keep a watch in case something comes
back.

Thanks!

AF

On Fri, Jan 21, 2011 at 7:30 AM, Bogdan-Andrei Iancu
<bogdan at opensips.org> wrote:
> Hi Alan,
>
> If still in memory, it means the dialog is considered as alive - please also
> print the "state" field (both from fifo and DB).
>
> Even so, the record is strange:
>   start_time  is Thu, 20 Jan 2011 20:00:56 GMT
>   timeout is Sat, 01 Jan 2011 17:23:06 GMT
>
> So timeout is before the start_time :P....
>
> Could you post the out of the fifo cmd dlg_list ?
>
> Regards,
> Bogdan
>
> Alan Frisch wrote:
>>
>> Bogdan,
>>
>> The dialogs are still showing in memory with the FIFO command and in
>> MySQL.
>>
>> I have the following in my opensips.cfg
>>
>> modparam("dialog", "default_timeout", 7500)
>> modparam("dialog", "db_mode", 1)
>>
>> One of my entries is showing this:
>>
>> +------------+------------+
>> | start_time | timeout    |
>> +------------+------------+
>> | 1295553656 | 1293902586 |
>> +------------+------------+
>>
>> The timeout is less than the start time, so it will never timeout.
>>
>> Perhaps I should try removing it and see if it just doesn't come back?
>>
>> On Thu, Jan 20, 2011 at 5:07 AM, Bogdan-Andrei Iancu
>> <bogdan at opensips.org> wrote:
>>
>>>
>>> Hi Alan,
>>>
>>> So those dialogs were removed from memory (you cannot see them listed by
>>> "opensipsctl fifo dlg_list"), but they are still in DB ? If so, what are
>>> the
>>> values for "timeout" field in DB for that those dialogs ?
>>>
>>> Regards,
>>> Bogdan
>>>
>>> Alan Frisch wrote:
>>>
>>>>
>>>> Using the LB module with Dialog and using FreeSwitch/Asterisk to
>>>> handle my media.
>>>>
>>>> Under 1.63 I had the occasional phantom call that hung around, but
>>>> would expire based on the dialog expiry value I had set.
>>>>
>>>> When I upgraded to 1.64 the only change to my opensips.cfg that was
>>>> made was to remove the reference to explicitly load the xlog module.
>>>> However, now I am finding that OpenSIPS is not expiring my old
>>>> dialogs, I am finding ones that are several weeks old in the DB (even
>>>> though my timeout is about 3 hours).
>>>>
>>>> Any ideas on this one?
>>>>
>>>> Thanks!
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>>
>>>
>>> --
>>> Bogdan-Andrei Iancu
>>> OpenSIPS Event - expo, conf, social, bootcamp
>>> 2 - 4 February 2011, ITExpo, Miami,  USA
>>> OpenSIPS solutions and "know-how"
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>
> --
> Bogdan-Andrei Iancu
> OpenSIPS Event - expo, conf, social, bootcamp
> 2 - 4 February 2011, ITExpo, Miami,  USA
> OpenSIPS solutions and "know-how"
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>