I am facing the same issue, and it's causing me not to be able to perform
any calls, instead i get user not found n HSS.
Abdelmuhaimen Seaudi, CCIE # 25265
Email: aseaudi(a)gmail.com
Skype: aseaudi
LinkedIn:
www.linkedin.com/in/aseaudi
Telephone: +2012 84644 733
On Mon, Jan 1, 2018 at 3:17 PM, Rafi A. <rafi(a)neragon.com> wrote:
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(a)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@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@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@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@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@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@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.gsma-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@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@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@mnc001.mcc001.3gppnetwork.org], contact [
sip:rafi@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@192.168.10.48:57230;transport=udp] to IMPU [
sip:rafi@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@192.168.10.48:57230;
transport=udp], was 2
Best Regards,
Rafael A.
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users