[sr-dev] Issue with linking contact to IMPU

[Rafi A.]

Hi there,

 

I need some help here to understand why  the query in [usrloc_db.c:1084] is
empty. This causes the linking of contact to IMPU to fail.

I'm using Kamailio 5.0.4.

 

 

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:1284]:
unref_subscription_unsafe(): un-reffing subscription
[rafi at mnc001.mcc001.3gppnetwork.org] - was [3]

10(13882) DEBUG: ims_registrar_scscf [save.c:519]: update_contacts_helper():
updating the contacts for IMPU <sip:rafi at mnc001.mcc001.3gppnetwork.org>

10(13882) DEBUG: ims_registrar_scscf [save.c:137]: calc_contact_expires():
Calculated expires for contact is 600000

10(13882) DEBUG: ims_registrar_scscf [save.c:548]: update_contacts_helper():
Need to update contact: <sip:rafi at 192.168.10.48:57230;transport=udp>:
q_value [-1],sos: [0],expires [600000]

10(13882) DEBUG: ims_registrar_scscf [save.c:550]: update_contacts_helper():
packing contact information

10(13882) DEBUG: ims_registrar_scscf [save.c:556]: update_contacts_helper():
adding/updating contact based on prior existence

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:748]: get_scontact():
looking for contact [sip:rafi at 192.168.10.48:57230;transport=udp] in slot 300

10(13882) DEBUG: ims_registrar_scscf [save.c:562]: update_contacts_helper():
inserting new contact

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:562]: insert_scontact():
INSERTing ucontact in usrloc module

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.3gpp.cs-voice]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.3gpp.icsi-ref]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [audio]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.oma.sip-im.large-message]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.3gpp.smsip]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [language]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [+g.oma.sip-im]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:118]: new_ucontact(): Checking
param [expires]

10(13882) DEBUG: ims_usrloc_scscf [ucontact.c:173]: new_ucontact():
generating hash based on [sip:rafi at 192.168.10.48:57230;transport=udp]

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:280]: mem_insert_scontact():
Created new contact in memory with AOR:
[sip:rafi at 192.168.10.48:57230;transport=udp] and hash [300]

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:289]: db_insert_ucontact():
DB: inserting ucontact [sip:rafi at 192.168.10.48:57230;transport=udp]

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:311]: db_insert_ucontact():
Converted params to string to insert into db:
[+g.3gpp.cs-voice;+g.3gpp.icsi-ref=urn%3Aurn-7%3A3gpp-application.ims.iari.g
sma-vs;audio;+g.oma.sip-im.large-message;+g.3gpp.smsip;language=en,fr;+g.oma
.sip-im;expires=600000]

10(13882) DEBUG: ims_usrloc_scscf [udomain.c:843]: ref_contact_unsafe():
incrementing ref count on contact
[sip:rafi at 192.168.10.48:57230;transport=udp], was 1

10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:1225]:
link_contact_to_impu(): number of contacts for IMPU
[sip:rafi at mnc001.mcc001.3gppnetwork.org] is 1

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:1065]:
db_link_contact_to_impu(): DB: linking contact to IMPU

10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:1084]:
db_link_contact_to_impu(): QUERY IS [] and len is 0

10(13882) ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver
error on query: Query was empty (1065)

10(13882) ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while
submitting query

10(13882) ERROR: ims_usrloc_scscf [usrloc_db.c:1086]:
db_link_contact_to_impu(): Unable to link impu-contact in DB - impu
[sip:rafi at mnc001.mcc001.3gppnetwork.org], contact
[sip:rafi at 192.168.10.48:57230;transport=udp]

10(13882) ERROR: ims_usrloc_scscf [impurecord.c:1227]:
link_contact_to_impu(): Failed to update DB linking contact
[sip:rafi at 192.168.10.48:57230;transport=udp] to IMPU
[sip:rafi at mnc001.mcc001.3gppnetwork.org]...continuing but db will be out of
sync!

10(13882) DEBUG: ims_usrloc_scscf [udomain.c:852]: unref_contact_unsafe():
decrementing ref count on contact
[sip:rafi at 192.168.10.48:57230;transport=udp], was 2

 

Best Regards,

Rafael A.

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-dev/attachments/20180101/0c8e65aa/attachment.html>