Somebody met such problem? add: version: opensips 1.10.4-tls (x86_64/linux) flags: STATS: On, USE_IPV6, USE_TCP, USE_TLS, DISABLE_NAGLE, USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535 poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. @(#) $Id$ main.c compiled on 00:06:21 Apr 3 2015 with gcc 4.4.7
____________ Best regards, Igor Pavlov 2015-07-21 23:28 GMT+04:00 Игорь Павлов <[email protected]>: > 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
