[OpenSIPS-Users] Usrloc Write-Back scheme doesn't delete expired contacts from location. 1.10

[Bogdan-Andrei Iancu]

Hi Igor,

What contact matching algorithm do you use ?
http://www.opensips.org/html/docs/modules/1.10.x/usrloc.html#matching-mode

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 21.07.2015 22:28, Игорь Павлов wrote:
> Hi all. We have a problem with USRLOC, we are using write-back scheme 
> with 90 seconds timer_interval. In location table presents expired 
> contacts like this:
>
> username 	contact 	expires 	q 	callid 	user_agent 	socket
> 10271225 	sip:10271225 at 192.168.0.100:5060 
> <http://sip:10271225@192.168.0.100:5060> 	17.07.2015 17:44 	-1.00 
> 000AD87F-8E28-E511-95FA-ED5AA7718DC4 at 79.120.58.194 
> <mailto:000AD87F-8E28-E511-95FA-ED5AA7718DC4 at 79.120.58.194> 	SIPPER 
> for PhonerLite 	udp:192.168.0.5:5060 <http://192.168.0.5:5060>
> 10271225 	sip:10271225 at 192.168.0.100:5060 
> <http://sip:10271225@192.168.0.100:5060> 	16.07.2015 15:39 	-1.00 
> 0018FF86-8E28-E511-B071-73FCC3C39125 at 79.120.58.194 
> <mailto:0018FF86-8E28-E511-B071-73FCC3C39125 at 79.120.58.194> 	SIPPER 
> for PhonerLite 	udp:192.168.0.5:5060 <http://192.168.0.5:5060>
> 10271225 	sip:10271225 at 192.168.0.100:5060 
> <http://sip:10271225@192.168.0.100:5060> 	18.07.2015 16:01 	-1.00 
> 805B93D6-8E2B-E511-B232-C3E27EBE0AEC at 79.120.58.194 
> <mailto:805B93D6-8E2B-E511-B232-C3E27EBE0AEC at 79.120.58.194> 	SIPPER 
> for PhonerLite 	udp:192.168.0.5:5060 <http://192.168.0.5:5060>
> 10271225 	sip:10271225 at 192.168.0.100:5060 
> <http://sip:10271225@192.168.0.100:5060> 	21.07.2015 10:00 	-1.00 
> 80612236-8A2C-E511-B771-23AC57084C2D at 79.120.58.194 
> <mailto:80612236-8A2C-E511-B771-23AC57084C2D at 79.120.58.194> 	SIPPER 
> for PhonerLite 	udp:192.168.0.5:5060 <http://192.168.0.5:5060>
> 10271225 	sip:10271225 at 192.168.0.100:5060 
> <http://sip:10271225@192.168.0.100:5060> 	17.07.2015 9:55 	-1.00 
> 807832C3-8E28-E511-AFE6-E49E9283A1CD at 79.120.58.194 
> <mailto:807832C3-8E28-E511-AFE6-E49E9283A1CD at 79.120.58.194> 	SIPPER 
> for PhonerLite 	udp:192.168.0.5:5060 <http://192.168.0.5:5060>
>
>
> At same time, in syslog, I can see this:
>
> Jul 21 18:59:36 [37186]: 
> CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error 
> (1062): Duplicate entry '10271225-domain-sip:1027
> 1225 at 192.168.0.100:5060-00705664-8' for key 'account_contact_idx'
> Jul 21 18:59:36 [37186]: ERROR:usrloc:db_update_ucontact: updating 
> database failed
> Jul 21 18:59:36 [37186]: ERROR:usrloc:wb_timer: updating contact in db 
> failed
> Jul 21 19:01:07 [37186]: 
> CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error 
> (1062): Duplicate entry '10271225-domain-sip:1027
> 1225 at 192.168.0.100:5060-00705664-8' for key 'account_contact_idx'
> Jul 21 19:01:07 [37186]: ERROR:usrloc:db_update_ucontact: updating 
> database failed
> Jul 21 19:01:07 [37186]: ERROR:usrloc:wb_timer: updating contact in db 
> failed
>
>
> ____________
> Best regards,
> Igor Pavlov
>
>
> _______________________________________________
> 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/20150804/3005c023/attachment.htm>