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 <[email protected]> > 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 <[email protected]> >> 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: [email protected] <[email protected]> >>> PGP public key: click here to download >>> <https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing> >>> >>> >>> >>> _______________________________________________ >>> Users mailing >>> [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >>> >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> 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: [email protected] <[email protected]> >> PGP public key: click here to download >> <https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing> >> >> >> >> _______________________________________________ >> Users mailing >> [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> >> _______________________________________________ >> Users mailing list >> [email protected] >> 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: [email protected] <[email protected]> > 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: [email protected] <[email protected]> PGP public key: click here to download <https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing> <http://www.privatemobility.nl>
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:[email protected];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:[email protected];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>
20171009-opensips-deregistration-failure.pcapng
Description: application/pcapng
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
