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:[email protected]:5060 17.07.2015 17:44 -1.00
[email protected] SIPPER for PhonerLite
udp:192.168.0.5:5060 10271225 sip:[email protected]:5060 16.07.2015
15:39 -1.00 [email protected] SIPPER for
PhonerLite udp:192.168.0.5:5060 10271225
sip:[email protected]:5060 18.07.2015
16:01 -1.00 [email protected] SIPPER for
PhonerLite udp:192.168.0.5:5060 10271225
sip:[email protected]:5060 21.07.2015
10:00 -1.00 [email protected] SIPPER for
PhonerLite udp:192.168.0.5:5060 10271225
sip:[email protected]:5060 17.07.2015
9:55 -1.00 [email protected] 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
[email protected]: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
[email protected]: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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
