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

[Bogdan-Andrei Iancu]

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"