THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY. The following task has a new comment added:
FS#448 - usrloc driver error on query: Duplicate entry 'XXXXXXXXXXXX' for key 'ruid_idx' User who did this - Savolainen Dmitri (sdi) ---------- i have tested of course. before reboot user [email protected] exists <code> mysql>select * from location where username='1111' and domain='sip.erinaco.ru' \G *************************** 1. row *************************** id: 112154 ruid: ulcx-53b65903-dec-1 username: 1111 domain: sip.erinaco.ru contact: sip:[email protected] received: NULL path: NULL expires: 1970-01-01 03:00:00 q: 1.00 callid: [email protected] cseq: 1 last_modified: 1970-01-01 03:00:00 flags: 0 cflags: 0 user_agent: SIP Router MI Server socket: NULL methods: NULL instance: NULL reg_id: 0 1 row in set (0.00 sec) </code> [snen@sw4]# ./kamctl restart [snen@sw4]# ./kamctl ul add '[email protected]' 'sip:[email protected]' let's have a look at kamailio log: Jul 11 11:55:58 sw4 ./kamailio[28446]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Duplicate entry 'ulcx-53b65903-dec-1' for key 'ruid_idx' Jul 11 11:57:58 sw4 ./kamailio[28446]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Duplicate entry 'ulcx-53b65903-dec-1' for key 'ruid_idx' Jul 11 11:59:58 sw4 ./kamailio[28446]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Duplicate entry 'ulcx-53b65903-dec-1' for key 'ruid_idx' let's have a look at mysql query log: <code> 1453 Query update location set expires='1970-01-01 03:00:00',q=1.00 ,cseq=1,flags=0,cflags=0,user_agent='SIP Router MI Server',received=NULL,path=NULL,socket=NULL,methods=NULL,last_modified='1970-01-01 03:00:00',callid='[email protected]',instance=NULL,reg_id=0,contact='sip:[email protected]' where ruid='ulcx-53b65903-dec-1' 1453 Query insert into location (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,ruid,instance,reg_id,domain ) values ('1111','sip:[email protected]','1970-01-01 03:00:00',1.00 ,'[email protected]',1,0,0,'SIP Router MI Server',NULL,NULL,NULL,NULL,'1970-01-01 03:00:00','ulcx-53b65903-dec-1',NULL,0,'sip.erinaco.ru') </code> now, let's update again (second update after reboot): [snen@sw4]# ./kamctl ul add '[email protected]' 'sip:[email protected]' and look at query log <code> 140711 12:13:58 1453 Query update location set expires='1970-01-01 03:00:00',q=1.00 ,cseq=2,flags=0,cflags=0,user_agent='SIP Router MI Server',received=NULL,path=NULL,socket=NULL,methods=NULL,last_modified='1970-01-01 03:00:00',callid='[email protected]',instance=NULL,reg_id=0,contact='sip:[email protected]' where ruid='ulcx-53b65903-dec-1' </code> so cseq incremented after second update only, and the callid is the same ---------- More information can be found at the following URL: http://sip-router.org/tracker/index.php?do=details&task_id=448#comment1542 You are receiving this message because you have requested it from the Flyspray bugtracking system. If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above. _______________________________________________ sr-dev mailing list [email protected] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
