[Spce-user] [kamailio] Usrloc: cache vs database inconsistencies

[sebastian rojo]

I have noticed a consistent difference between the location records in DB.
and those stored in kamailio chache.


root at sbc:~# ngcp-kamctl proxy ul show |grep Contact

         Contact::
sip:2422 at X.16.10.221:54733;rinstance=48d7e73f599c5826;transport=TCP Q=

         Contact:: sip:2422 at x.1.1.180:36404;rinstance=691517d9fa77703f Q=

         Contact:: sip:4202 at x.1.2.79:43802;rinstance=cd4779b1598d1beb Q=

         Contact:: sip:4202 at x.48.236.198:40862;rinstance=487d6d482fd2cb5f Q=

         Contact:: sip:2420 at x.1.0.175:5060;transport=udp Q=

         Contact::
sip:2420 at x.x.11.213:34945;rinstance=aba2923ddadb6b56;transport=TCP Q=

         Contact:: sip:2420 at x.1.1.12:18584;rinstance=7c30d5a446902dd0 Q=

         Contact:: sip:2421 at x.1.0.232:60492;rinstance=62e978f706b850cd Q=

         Contact:: sip:2417 at x.1.0.180:4750;rinstance=1969d005d5cfd371 Q=

         Contact:: sip:2410 at x.1.0.236:17688;rinstance=bacd6921e1c49d12 Q=

         Contact::
sip:2410 at x.16.10.208:55658;rinstance=0768359aed20d852;transport=UDP Q=

         Contact::
sip:3501 at x.157.133.229:33857;rinstance=36c7a54559d5147a;transport=TCP
Q=

         Contact:: sip:3501 at x.1.0.119:9470;rinstance=7bdf7c5e0c70a752 Q=

         Contact:: sip:s at x.1.0.4:5060 Q=

14 records

On DB see this records.

SELECT username, contact, expires - NOW() FROM kamailio.location;

   username contact expires - NOW()  *3501*
*sip:3501 at X.16.10.243:34959;rinstance=7933832f47243e95;transport=UDP*
*-1918864*  *4202*
*sip:4202 at X.14.26.12:35400;rinstance=9dbc8f7e36af6250;transport=TCP*
*-959457*  *2422*
*sip:2422 at X.16.10.221:47987;rinstance=275352713d6a6325;transport=TCP*
*-958275*  dialcast sip:s at X.1.0.4:5060 29  2410 sip:2410 at X.16.10.208
:55658;rinstance=0768359aed20d852;transport=UDP 95  3501
sip:3501 at X.157.133.229:33857;rinstance=36c7a54559d5147a;transport=TCP 213
4202 Sip:4202 at X.1.2.79:43802;rinstance=cd4779b1598d1beb 240  2420
sip:2420 at X.16.11.213:34945;rinstance=aba2923ddadb6b56;transport=TCP 527
2422 sip:2422 at X.16.10.221:54733;rinstance=48d7e73f599c5826;transport=TCP 715
2417 sip:2417 at X.1.0.180:4750;rinstance=1969d005d5cfd371 1799  2420
sip:2420 at X.1.1.12:18584;rinstance=7c30d5a446902dd0 2298  3501
sip:3501 at X.1.0.119:9470;rinstance=7bdf7c5e0c70a752 7920  2421
sip:2421 at X.1.0.232:60492;rinstance=62e978f706b850cd 8019  2422
sip:2422 at X.1.1.180:36404;rinstance=691517d9fa77703f 8293  4202
sip:4202 at X.48.236.198:40862;rinstance=487d6d482fd2cb5f 8514  2410
sip:2410 at X.1.0.236:17688;rinstance=bacd6921e1c49d12 8925  2420
sip:2420 at X.1.0.175:5060;transport=udp 9927

see this records. already expired records that are not in the cache. but
still the DB

SELECT username, contact, expires FROM kamailio.location WHERE expires <= NOW();

   username contact expires  3501 sip:3501 at 172.16.10.243:34959
;rinstance=7933832f47243e95;transport=UDP 2014-08-26 17:36:44  4202
sip:4202 at 179.14.26.12:35400;rinstance=9dbc8f7e36af6250;transport=TCP 2014-08-27
13:30:51  2422 sip:2422 at 172.16.10.221:47987
;rinstance=275352713d6a6325;transport=TCP 2014-08-27 13:42:33
​
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20140828/9630b360/attachment.html>