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
_______________________________________________
Kamailio (SER) - Development Mailing List
[email protected]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-dev
