[sr-dev] [tracker] Comment added: usrloc driver error on query: Duplicate entry 'XXXXXXXXXXXX' for key 'ruid_idx'

[sip-router]

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 at 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 at 192.168.10.100
     received: NULL
         path: NULL
      expires: 1970-01-01 03:00:00
            q: 1.00
       callid: dfjrewr12386fd6-343 at 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 at sw4]# ./kamctl restart

[snen at sw4]# ./kamctl ul add '1111 at sip.erinaco.ru' 'sip:1111 at 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 at kamailio.mi',instance=NULL,reg_id=0,contact='sip:1111 at 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 at 192.168.10.100','1970-01-01 03:00:00',1.00      ,'dfjrewr12386fd6-343 at 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 at sw4]# ./kamctl ul add '1111 at sip.erinaco.ru' 'sip:1111 at 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 at kamailio.mi',instance=NULL,reg_id=0,contact='sip:1111 at 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#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.