30 Apr
2012
30 Apr
'12
11:11 p.m.
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(a)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(a)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(a)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(a)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(a)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(a)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.