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 1111@sip.erinaco.ru 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:1111@192.168.10.100 received: NULL path: NULL expires: 1970-01-01 03:00:00 q: 1.00 callid: dfjrewr12386fd6-343@kamailio.mi 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 '1111@sip.erinaco.ru' 'sip:1111@192.168.10.100'

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='dfjrewr12386fd6-343@kamailio.mi',instance=NULL,reg_id=0,contact='sip:1111@192.168.10.100' 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:1111@192.168.10.100','1970-01-01 03:00:00',1.00 ,'dfjrewr12386fd6-343@kamailio.mi',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 '1111@sip.erinaco.ru' 'sip:1111@192.168.10.100'

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='dfjrewr12386fd6-343@kamailio.mi',instance=NULL,reg_id=0,contact='sip:1111@192.168.10.100' 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#comment15...

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.