[OpenSIPS-Users] Fwd: opensips usrloc deregistration failure

[Răzvan Crainea]

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 Developer
www.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 
> <mailto: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
>     <http://www.opensips.org/html/docs/modules/2.3.x/usrloc.html#idp5620912>
>
>     Best regards,
>
>     Răzvan Crainea
>     OpenSIPS Developer
>     www.opensips-solutions.com <http://www.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
>>     <mailto:stefan.tobe at privatemobility.nl>
>>     PGP public key: click here to download
>>     <https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>
>>
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>     <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>     <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 <mailto:stefan.tobe at privatemobility.nl>
> PGP public key: click here to download 
> <https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20171009/ad75ae75/attachment-0001.html>