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: [email protected] Skype: aseaudi LinkedIn: www.linkedin.com/in/aseaudi Telephone: +2012 84644 733 On Mon, Jan 1, 2018 at 3:17 PM, Rafi A. <[email protected]> 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 [ > [email protected]] - was [3] > > 10(13882) DEBUG: ims_registrar_scscf [save.c:519]: > update_contacts_helper(): updating the contacts for IMPU < > sip:[email protected]> > > 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:[email protected]: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:[email protected]: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:[email protected]:57230;transport=udp] > > 10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:280]: > mem_insert_scontact(): Created new contact in memory with AOR: [ > sip:[email protected]:57230;transport=udp] and hash [300] > > 10(13882) DEBUG: ims_usrloc_scscf [usrloc_db.c:289]: db_insert_ucontact(): > DB: inserting ucontact [sip:[email protected]: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:[email protected]:57230; > transport=udp], was 1 > > 10(13882) DEBUG: ims_usrloc_scscf [impurecord.c:1225]: > link_contact_to_impu(): number of contacts for IMPU [ > sip:[email protected]] 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:[email protected]], contact [ > sip:[email protected]:57230;transport=udp] > > 10(13882) ERROR: ims_usrloc_scscf [impurecord.c:1227]: > link_contact_to_impu(): Failed to update DB linking contact [ > sip:[email protected]:57230;transport=udp] to IMPU [ > sip:[email protected]]...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:[email protected]:57230; > transport=udp], was 2 > > > > Best Regards, > > Rafael A. > > > > > > _______________________________________________ > Kamailio (SER) - Users Mailing List > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
