[sr-dev] [kamailio/kamailio] kamailio startup failed when switch to mongodb (#1300)

wavestudio notifications at github.com
Fri Nov 3 12:18:27 CET 2017 

I have a task to change the backend database of kamailio to mongodb. I have updated the DBURL to a valid URL of mongodb. Kamailio startup successfully firsttime when i insert some documents into the  version collection. But after a user registed into kamailio, a location collection will be created. In this case i stop kamailio and try to start kamailio again, kamailio failed to startup. The log is:
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:349]: db_mongodb_get_columns(): 20 columns returned from the query
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:158]: db_allocate_columns(): allocate 160 bytes for result names at 0x7f934f907a30
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:169]: db_allocate_columns(): allocate 80 bytes for result types at 0x7f934f8fe290
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[0] named: username
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:403]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7f934f907b38
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:438]: db_mongodb_get_columns(): use DB1_STRING result type
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:467]: db_mongodb_get_columns(): RES_NAMES(0x7f934f907b38)[0]=[username] (2)
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[1] named: contact
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:403]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[1] at 0x7f934f907bb0
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:438]: db_mongodb_get_columns(): use DB1_STRING result type
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:467]: db_mongodb_get_columns(): RES_NAMES(0x7f934f907bb0)[1]=[contact] (2)
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[2] named: expires
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:403]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[2] at 0x7f934f907c28
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:428]: db_mongodb_get_columns(): use DB1_DATETIME result type
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:467]: db_mongodb_get_columns(): RES_NAMES(0x7f934f907c28)[2]=[expires] (9)
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[3] named: q
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:403]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[3] at 0x7f934f907ca0
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:423]: db_mongodb_get_columns(): use DB1_DOUBLE result type
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:467]: db_mongodb_get_columns(): RES_NAMES(0x7f934f907ca0)[3]=[q] (1)
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[4] named: callid
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:403]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[4] at 0x7f934f907d18
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:438]: db_mongodb_get_columns(): use DB1_STRING result type
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:467]: db_mongodb_get_columns(): RES_NAMES(0x7f934f907d18)[4]=[callid] (2)
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[5] named: cseq
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:403]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[5] at 0x7f934f907d90
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:413]: db_mongodb_get_columns(): use DB1_INT result type
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:467]: db_mongodb_get_columns(): RES_NAMES(0x7f934f907d90)[5]=[cseq] (16)
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[6] named: flags
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:403]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[6] at 0x7f934f907e08
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:413]: db_mongodb_get_columns(): use DB1_INT result type
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:467]: db_mongodb_get_columns(): RES_NAMES(0x7f934f907e08)[6]=[flags] (16)
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[7] named: cflags
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:403]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[7] at 0x7f934f9150e0
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:413]: db_mongodb_get_columns(): use DB1_INT result type
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:467]: db_mongodb_get_columns(): RES_NAMES(0x7f934f9150e0)[7]=[cflags] (16)
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[8] named: user_agent
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:403]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[8] at 0x7f934f915158
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:438]: db_mongodb_get_columns(): use DB1_STRING result type
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:467]: db_mongodb_get_columns(): RES_NAMES(0x7f934f915158)[8]=[user_agent] (2)
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[9] named: received
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: db_mongodb [mongodb_dbase.c:387]: db_mongodb_get_columns(): field [received] not found in result iterator
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: db_mongodb [mongodb_dbase.c:752]: db_mongodb_store_result(): failed to set the columns
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: db_mongodb [mongodb_dbase.c:931]: db_mongodb_query(): failed to store result
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: db_mongodb [mongodb_dbase.c:940]: db_mongodb_query(): failed to do the query
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:79]: db_free_columns(): freeing 20 columns
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[0] at 0x7f934f907b38
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[1] at 0x7f934f907bb0
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[2] at 0x7f934f907c28
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[3] at 0x7f934f907ca0
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[4] at 0x7f934f907d18
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[5] at 0x7f934f907d90
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[6] at 0x7f934f907e08
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[7] at 0x7f934f9150e0
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[8] at 0x7f934f915158
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:96]: db_free_columns(): freeing result names at 0x7f934f907a30
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:101]: db_free_columns(): freeing result types at 0x7f934f8fe290
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: <core> [db_res.c:138]: db_free_result(): freeing result set at 0x7f934f8fe158
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: usrloc [udomain.c:457]: preload_udomain(): db_query failed
Nov  3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: usrloc [usrloc_mod.c:429]: child_init(): child(1): failed to preload domain 'location'

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/1300
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-dev/attachments/20171103/75771f6a/attachment.html>

More information about the sr-dev mailing list