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@192.168.0.100:5060 17.07.2015 17:44 -1.00 000AD87F-8E28-E511-95FA-ED5AA7718DC4@79.120.58.194 SIPPER for PhonerLite udp:192.168.0.5:5060 10271225 sip:10271225@192.168.0.100:5060 16.07.2015 15:39 -1.00 0018FF86-8E28-E511-B071-73FCC3C39125@79.120.58.194 SIPPER for PhonerLite udp:192.168.0.5:5060 10271225 sip:10271225@192.168.0.100:5060 18.07.2015 16:01 -1.00 805B93D6-8E2B-E511-B232-C3E27EBE0AEC@79.120.58.194 SIPPER for PhonerLite udp:192.168.0.5:5060 10271225 sip:10271225@192.168.0.100:5060 21.07.2015 10:00 -1.00 80612236-8A2C-E511-B771-23AC57084C2D@79.120.58.194 SIPPER for PhonerLite udp:192.168.0.5:5060 10271225 sip:10271225@192.168.0.100:5060 17.07.2015 9:55 -1.00 807832C3-8E28-E511-AFE6-E49E9283A1CD@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@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@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@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users