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

[Игорь Павлов]

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 17.07.2015 17:44 -1.00
000AD87F-8E28-E511-95FA-ED5AA7718DC4 at 79.120.58.194 SIPPER for PhonerLite
udp:192.168.0.5:5060  10271225  sip:10271225 at 192.168.0.100:5060 16.07.2015
15:39 -1.00 0018FF86-8E28-E511-B071-73FCC3C39125 at 79.120.58.194 SIPPER for
PhonerLite udp:192.168.0.5:5060  10271225
sip:10271225 at 192.168.0.100:5060 18.07.2015
16:01 -1.00 805B93D6-8E2B-E511-B232-C3E27EBE0AEC at 79.120.58.194 SIPPER for
PhonerLite udp:192.168.0.5:5060  10271225
sip:10271225 at 192.168.0.100:5060 21.07.2015
10:00 -1.00 80612236-8A2C-E511-B771-23AC57084C2D at 79.120.58.194 SIPPER for
PhonerLite udp:192.168.0.5:5060  10271225
sip:10271225 at 192.168.0.100:5060 17.07.2015
9:55 -1.00 807832C3-8E28-E511-AFE6-E49E9283A1CD at 79.120.58.194 SIPPER for
PhonerLite udp: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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150721/51b8b20f/attachment.htm>