<p>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:<br>
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<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:158]: db_allocate_columns(): allocate 160 bytes for result names at 0x7f934f907a30<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:169]: db_allocate_columns(): allocate 80 bytes for result types at 0x7f934f8fe290<br>
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<br>
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<br>
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<br>
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)<br>
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<br>
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<br>
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<br>
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)<br>
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<br>
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<br>
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<br>
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)<br>
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<br>
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<br>
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<br>
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)<br>
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<br>
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<br>
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<br>
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)<br>
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<br>
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<br>
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<br>
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)<br>
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<br>
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<br>
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<br>
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)<br>
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<br>
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<br>
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<br>
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)<br>
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<br>
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<br>
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<br>
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)<br>
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<br>
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<br>
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<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: db_mongodb [mongodb_dbase.c:931]: db_mongodb_query(): failed to store result<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: db_mongodb [mongodb_dbase.c:940]: db_mongodb_query(): failed to do the query<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:79]: db_free_columns(): freeing 20 columns<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:83]: db_free_columns(): freeing RES_NAMES[0] at 0x7f934f907b38<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:83]: db_free_columns(): freeing RES_NAMES[1] at 0x7f934f907bb0<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:83]: db_free_columns(): freeing RES_NAMES[2] at 0x7f934f907c28<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:83]: db_free_columns(): freeing RES_NAMES[3] at 0x7f934f907ca0<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:83]: db_free_columns(): freeing RES_NAMES[4] at 0x7f934f907d18<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:83]: db_free_columns(): freeing RES_NAMES[5] at 0x7f934f907d90<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:83]: db_free_columns(): freeing RES_NAMES[6] at 0x7f934f907e08<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:83]: db_free_columns(): freeing RES_NAMES[7] at 0x7f934f9150e0<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:83]: db_free_columns(): freeing RES_NAMES[8] at 0x7f934f915158<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:96]: db_free_columns(): freeing result names at 0x7f934f907a30<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:101]: db_free_columns(): freeing result types at 0x7f934f8fe290<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: DEBUG: [db_res.c:138]: db_free_result(): freeing result set at 0x7f934f8fe158<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: usrloc [udomain.c:457]: preload_udomain(): db_query failed<br>
Nov 3 18:53:38 kamailio-1 ./kamailio[40735]: ERROR: usrloc [usrloc_mod.c:429]: child_init(): child(1): failed to preload domain 'location'</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/issues/1300">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AF36Za0dL_4lfNTqZLReWnwWzHftPVl5ks5syvaDgaJpZM4QQ8kG">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AF36ZfSXTF19oV72kj1Qq1rF4s1jMIBHks5syvaDgaJpZM4QQ8kG.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/kamailio/kamailio/issues/1300"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/kamailio/kamailio","title":"kamailio/kamailio","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/kamailio/kamailio"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"kamailio startup failed when switch to mongodb (#1300)"}],"action":{"name":"View Issue","url":"https://github.com/kamailio/kamailio/issues/1300"}}}</script>