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@xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3@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@xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3@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@xx.xx.xx.xx:5060','2012-04-27 05:31:16',0.80 ,'54f18079-9ca165bc-9eed12e3@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@xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3@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@xx.xx.xx.xx:5060','2012-04-27 05:35:53',0.80,'54f18079-9ca165bc-9eed12e3@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@xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3@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@xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3@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@xx.xx.xx.xx:5060' AND callid='54f18079-9ca165bc-9eed12e3@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.