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:[email protected]:5060' AND
callid='[email protected]'
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:[email protected]:5060' AND
callid='[email protected]'
5 Query insert into location
(username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified
) values ('2012049699','sip:[email protected]:5060','2012-04-27 05:31:16',0.80
,'[email protected]',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:[email protected]:5060' AND
callid='[email protected]'
5 Query insert into location
(username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified
) values ('2012049699','sip:[email protected]:5060','2012-04-27
05:35:53',0.80,'[email protected]',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:[email protected]:5060' AND
callid='[email protected]'
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:[email protected]:5060' AND
callid='[email protected]'
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:[email protected]:5060' AND
callid='[email protected]'
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.
_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
