[sr-dev] [tracker] Task opened: Kamailio looses track of location entries

[sip-router]

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY.

A new Flyspray task has been opened.  Details are below. 

User who did this - Jon Tsiros (CiscoGeek) 

Attached to Project - sip-router
Summary - Kamailio looses track of location entries
Task Type - Bug Report
Category - Core
Status - Unconfirmed
Assigned To - 
Operating System - All
Severity - Low
Priority - Normal
Reported Version - Development
Due in Version - Undecided
Due Date - Undecided
Details - Over a period of time, location entries in memory become out of sync with entries in the database. I managed to capture the MySQL queries that attempt to update a particular entry after it is deleted from the database:

5 Query     update location set expires='2012-04-27 05:21:55',q=0.80      ,cseq=393,flags=0,cflags=0,user_agent='PolycomSoundPointIP-SPIP_550-UA/3.2.4.0267',received='sip:xx.xx.xx.xx:5060',path='<sip:xx.xx.xx.xx;lr;received=\"sip:xx.xx.xx.xx:5060\">',socket='udp:xx.xx.xx.xx:5060',methods=8159,last_modified='2012-04-27 05:16:18' where username='2012049699' AND contact='sip:2012049699 at xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3 at 192.168.1.7'

5 Query     update location set expires='2012-04-27 05:26:36',q=0.80      ,cseq=395,flags=0,cflags=0,user_agent='PolycomSoundPointIP-SPIP_550-UA/3.2.4.0267',received='sip:xx.xx.xx.xx:5060',path='<sip:xx.xx.xx.xx;lr;received=\"sip:xx.xx.xx.xx:5060\">',socket='udp:xx.xx.xx.xx:5060',methods=8159,last_modified='2012-04-27 05:20:59' where username='2012049699' AND contact='sip:2012049699 at xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3 at 192.168.1.7'

5 Query     insert into location (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified ) values ('2012049699','sip:2012049699 at xx.xx.xx.xx:5060','2012-04-27 05:31:16',0.80      ,'54f18079-9ca165bc-9eed12e3 at 192.168.1.7',396,0,0,'PolycomSoundPointIP-SPIP_550-UA/3.2.4.0267','sip:xx.xx.xx.xx:5060','<sip:xx.xx.xx.xx;lr;received=\"sip:xx.xx.xx.xx:5060\">','udp:xx.xx.xx.xx:5060',8159,'2012-04-27 05:25:39')

5 Query     delete from location where username='2012049699' AND contact='sip:2012049699 at xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3 at 192.168.1.7'

5 Query     insert into location (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified ) values ('2012049699','sip:2012049699 at xx.xx.xx.xx:5060','2012-04-27 05:35:53',0.80,'54f18079-9ca165bc-9eed12e3 at 192.168.1.7',398,0,0,'PolycomSoundPointIP-SPIP_550-UA/3.2.4.0267','sip:xx.xx.xx.xx:5060','<sip:xx.xx.xx.xx;lr;received=\"sip:xx.xx.xx.xx:5060\">','udp:xx.xx.xx.xx:5060',8159,'2012-04-27 05:30:16')

5 Query     delete from location where username='2012049699' AND contact='sip:2012049699 at xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3 at 192.168.1.7'

5 Query     update location set expires='2012-04-27 05:40:30',q=0.80      ,cseq=399,flags=0,cflags=0,user_agent='PolycomSoundPointIP-SPIP_550-UA/3.2.4.0267',received='sip:xx.xx.xx.xx:5060',path='<sip:xx.xx.xx.xx;lr;received=\"sip:xx.xx.xx.xx:5060\">',socket='udp:xx.xx.xx.xx:5060',methods=8159,last_modified='2012-04-27 05:34:53' where username='2012049699' AND contact='sip:2012049699 at xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3 at 192.168.1.7'

5 Query     update location set expires='2012-04-27 05:45:07',q=0.80      ,cseq=401,flags=0,cflags=0,user_agent='PolycomSoundPointIP-SPIP_550-UA/3.2.4.0267',received='sip:xx.xx.xx.xx:5060',path='<sip:xx.xx.xx.xx;lr;received=\"sip:xx.xx.xx.xx:5060\">',socket='udp:xx.xx.xx.xx:5060',methods=8159,last_modified='2012-04-27 05:39:30' where username='2012049699' AND contact='sip:2012049699 at xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3 at 192.168.1.7'

More information can be found at the following URL:
http://sip-router.org/tracker/index.php?do=details&task_id=226

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.