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