[OpenSIPS-Users] Fwd: opensips usrloc deregistration failure
Stefan Tobé
stefan.tobe at pmfactory.nl
Mon Oct 9 10:23:23 EDT 2017
Hi Razvan, please find both pcap and query of mysql backend (location
table) attached.
> no we dont see failover, single DB backend being used.
> regards
> Stefan
>
>
> On Mon, Oct 9, 2017 at 2:39 PM, Răzvan Crainea <razvan at opensips.org>
> wrote:
>
>> Hi, Stefan!
>>
>> Indeed, there is no "Deleted" state in the db, not even in opensips'
>> memory.
>> Can you paste the records of two bindings that should not be there?
>> Since you are using db_virtual, are you experiencing any failover?
>>
>> Best regards,
>>
>> Răzvan Crainea
>> OpenSIPS Developerwww.opensips-solutions.com
>>
>> On 10/09/2017 02:48 PM, Stefan Tobé wrote:
>>
>> Hi Razvan,
>> thanks for replying
>>
>> I notice that the bindings remain in the DB for a while (at least >
>> 5min), sometimes they are deleted immediately (as I would expect), some
>> other times they remain in the table.
>> So reregistering returns 200OK (2 bindings or 3 , increasing). Re
>> querying the DB shows an increment of equal bindings for a client until the
>> limit is reached for max amount of registrations in the config (10 by
>> default I believe?).
>>
>> If I decrease that setting lets say to modparam("registrar",
>> "max_contacts", 2) then I will very soon get an error reply back. Note that
>> this behavior (increment of bindings) is not consequently observed (it is
>> intermittent).
>>
>> The DB setting in the config (config was attached to original email as
>> well as pcap) is:
>>
>> #### USeR LOCation module
>> loadmodule "usrloc.so"
>> #modparam("usrloc", "nat_bflag", "NAT")
>> modparam("usrloc", "db_mode", 3)
>> modparam("usrloc", "db_url","virtual://pmset")
>>
>>
>> You mention a '*Deleted*' state, but I was unable to find that flag .
>> Should that be in *opensips.location* table?
>>
>> On Mon, Oct 9, 2017 at 11:21 AM, Răzvan Crainea <razvan at opensips.org>
>> wrote:
>>
>>> Hi, Stefan!
>>>
>>> Are you saying that the Contacts "leak" in the database (they are never
>>> deleted), or that they are not deleted immediately after the client is
>>> deregistering (but they are a bit later)?
>>>
>>> What is the db_mode setting[1] you are using for the usrloc module?
>>> Also, note that the Contacts might still be present in the database after
>>> they are deleted, but with a Deleted state. If that's the case, this is
>>> perfectly fine.
>>>
>>> [1] http://www.opensips.org/html/docs/modules/2.3.x/usrloc.html#
>>> idp5620912
>>>
>>> Best regards,
>>>
>>> Răzvan Crainea
>>> OpenSIPS Developerwww.opensips-solutions.com
>>>
>>> On 10/09/2017 11:57 AM, Stefan Tobé wrote:
>>>
>>>
>>> Hi there,
>>> I noticed that opensips 2.2.5-1 intermittently does NOT flush the
>>> contact when the client is deregistering.
>>> It is reproducable with multple sip clients. opensips 2.3 also suffers
>>> from this issue.
>>>
>>> When I check the mysql database backend I can see that the entry is
>>> table opensips.location is not consistently deleted.
>>> It works for several times and the subsequently it does not flush the
>>> contact showing two bindings the next time the client is registered.
>>>
>>>
>>> I can unfortunately not monitor the sql queries because opensips is
>>> using tls for secure transmission.
>>> I use mysql as backend and the config is attached as well as the local
>>> wireshark trace I took
>>>
>>>
>>>
>>>
>>>
>>> --
>>> mvg
>>> Stefan Tobé
>>>
>>>
>>> PM Factory B.V.
>>> Bolderweg 2
>>> 1332 AT Almere
>>> tel: 06 21 26 59 68
>>> email: stefan.tobe at pmfactory.nl <stefan.tobe at privatemobility.nl>
>>> PGP public key: click here to download
>>> <https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>
>>>
>>>
>>>
>>> _______________________________________________
>>> Users mailing listUsers at lists.opensips.orghttp://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
>>>
>>>
>>
>>
>> --
>> mvg
>> Stefan Tobé
>>
>>
>> PM Factory B.V.
>> Bolderweg 2
>> 1332 AT Almere
>> tel: 06 21 26 59 68
>> email: stefan.tobe at pmfactory.nl <stefan.tobe at privatemobility.nl>
>> PGP public key: click here to download
>> <https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>
>>
>>
>>
>> _______________________________________________
>> Users mailing listUsers at lists.opensips.orghttp://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
>>
>>
>
>
> --
> mvg
> Stefan Tobé
>
>
> PM Factory B.V.
> Bolderweg 2
> 1332 AT Almere
> tel: 06 21 26 59 68
> email: stefan.tobe at pmfactory.nl <stefan.tobe at privatemobility.nl>
> PGP public key: click here to download
> <https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>
>
> <http://www.privatemobility.nl>
>
--
mvg
Stefan Tobé
PM Factory B.V.
Bolderweg 2
1332 AT Almere
tel: 06 21 26 59 68
email: stefan.tobe at pmfactory.nl <stefan.tobe at privatemobility.nl>
PGP public key: click here to download
<https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>
<http://www.privatemobility.nl>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20171009/e31ef80f/attachment-0001.html>
-------------- next part --------------
mysql> select * from location;
+------------+--------------+--------+---------------------------------------------------+----------+------+---------------------+-------+------------+------+---------------------+-------+--------+--------------------------------+-----------------------+---------+--------------+------+
| contact_id | username | domain | contact | received | path | expires | q | callid | cseq | last_modified | flags | cflags | user_agent | socket | methods | sip_instance | attr |
+------------+--------------+--------+---------------------------------------------------+----------+------+---------------------+-------+------------+------+---------------------+-------+--------+--------------------------------+-----------------------+---------+--------------+------+
| 14 | +31621265968 | NULL | sip:+31621265968 at 10.230.1.61;line=ac9b84da7e3fa49 | NULL | NULL | 2017-10-09 16:50:03 | -1.00 | 1551117011 | 2 | 2017-10-09 15:50:03 | 0 | | Linphone/3.6.1 (eXosip2/4.1.0) | udp:10.230.1.121:5060 | NULL | NULL | NULL |
| 15 | +31621265968 | NULL | sip:+31621265968 at 10.230.1.61;line=b7343efdba1c922 | NULL | NULL | 2017-10-09 16:50:13 | -1.00 | 1538752751 | 2 | 2017-10-09 15:50:13 | 0 | | Linphone/3.6.1 (eXosip2/4.1.0) | udp:10.230.1.121:5060 | NULL | NULL | NULL |
+------------+--------------+--------+---------------------------------------------------+----------+------+---------------------+-------+------------+------+---------------------+-------+--------+--------------------------------+-----------------------+---------+--------------+------+
2 rows in set (0,18 sec)
mysql>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 20171009-opensips-deregistration-failure.pcapng
Type: application/x-pcapng
Size: 9268 bytes
Desc: not available
URL: <http://lists.opensips.org/pipermail/users/attachments/20171009/e31ef80f/attachment-0001.bin>
More information about the Users
mailing list