<div dir="ltr">Hello Daniel,<div><br></div><div>I tried with mongoc 1.8.0 (the trace I have sent) and also mongoc 1.9.2. The result is the same : a "failed to parse" with as indication "unrecognized field 'table_version'" when using mongo server version 3.6.2.</div><div><br></div><div>Both mongoc versions are running fine with a mongo server version 3.0.15.</div><div><br></div><div>Kind regards,</div><div>Stephane</div><div><br></div><div> </div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 28 February 2018 at 15:25, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>I see in the pcap that the returned error contains:</p>
<p>Failed to parse: { find: "version", filter: { table_name:
"location" }, table_version: 1, $readPreference: { mode:
"secondaryPreferred" }, $db: "kamailio" }. Unrecognized field
'table_version'.</p>
<p>What is the version of mongoc library? I tried to quick search on
google and found a similar report :</p>
<p> - <a class="m_-5784163451845740932moz-txt-link-freetext" href="https://github.com/mongodb/mongo-php-driver/issues/516" target="_blank">https://github.com/mongodb/<wbr>mongo-php-driver/issues/516</a><br>
</p>
On the other hand, it works with same lib but for different versions
of mongo server ... so might be something different.<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div class="m_-5784163451845740932moz-cite-prefix">On 27.02.18 11:26, Stephane wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hello Daniel,
<div><br>
</div>
<div>You will find two pcap files in attachment. I am using the
same mongoc library version in both cases.</div>
<div>Let me know if you need more info.</div>
<div><br>
</div>
<div>Kind regards,</div>
<div>Stephane</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 27 February 2018 at 09:01,
Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>can you send here the requests sent by kamailio for the
two mongodb versions? To compare and see where it can be
fixed.</p>
<p>Also, were you using the same mongoc library version in
both cases?</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div>
<div class="m_-5784163451845740932h5"> <br>
<div class="m_-5784163451845740932m_5123662677759671320moz-cite-prefix">On
26.02.18 12:57, Stephane wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hello,
<div>I made some additional tests. </div>
<div>The problem is only present when kamailio is
facing mongo release 3.2 (or higher). </div>
<div>With mongo version 3.0 (or lower), the
request sent by kamailio is different: it
contains $query and $table_version elements and
mongo accepts it.</div>
<div>Kind regards,<br>
</div>
<div>Stephane</div>
<div><br>
</div>
<div class="gmail_extra">
<div class="gmail_quote">On 23 February 2018 at
10:48, Stephane <span dir="ltr"><<a href="mailto:mandalavoip@gmail.com" target="_blank">mandalavoip@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hello Daniel,
<div><br>
</div>
<div>I took a pcap trace. And I see the
following in the answer sent by mongo</div>
<div><br>
</div>
<div>Failed to parse: { find: "version",
filter: { table_name: "location" },
table_version: 1, $db: "kamailio",
$readPreference: { mode:
"primaryPreferred" }, $clusterTime: {
clusterTime: Timestamp(1519379980, 1),
signature: { hash: BinData(0,
000000000000000000000000000000<wbr>0000000000),
keyId: 0 } } }. Unrecognized field
'table_version'.code<span style="white-space:pre-wrap"> </span>codeNameFailedToParseoperation<wbr>TimeZ$clusterTimeXclusterTimeZ<wbr>signature3hashkeyId</div>
<div><br>
</div>
<div>Kind regards,</div>
<div>Stephane</div>
</div>
<div class="m_-5784163451845740932m_5123662677759671320HOEnZb">
<div class="m_-5784163451845740932m_5123662677759671320h5">
<div class="gmail_extra"><br>
<div class="gmail_quote">On 23
February 2018 at 09:39,
Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>I don't know if you can see
the result sent back by
mongodb in its logs, it
doesn't show it there. Maybe
you can sniff the traffic on
the network and see if mongodb
sends the proper response
back. Kamailio logs like
nothing was retrieved.<br>
</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div>
<div class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138h5">
<br>
<div class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138m_17351067677194617moz-cite-prefix">On
22.02.18 18:02, Stephane
Focant wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138h5">
<div dir="ltr">
<div>Hello,</div>
<div>I have an issue
when I try to use
kamailio 5.1 with
usrloc and db_mongdb
modules.</div>
<div>When I try to start
kamailio, I get the
following error:</div>
<div><br>
</div>
<div>0(22216) DEBUG:
<core>
[db.c:314]:
db_do_init2():
connection
0x7f735b5c4100 not
found in pool</div>
<div> 0(22216) DEBUG:
db_mongodb
[mongodb_connection.c:55]:
db_mongodb_new_connection(): connection open to: mongodb://<a href="http://10.0.12.149" target="_blank">10.0.12.149</a>,10.0.12.<wbr>150,<a href="http://10.0.12.151/kamailio?replicaSet=sre_location&slaveOk=true&readPreference=primaryPreferred" target="_blank">10.0.12.151/kamailio?repli<wbr>caSet=sre_location&slaveOk=tru<wbr>e&readPreference=primaryPrefer<wbr>red</a></div>
<div> 0(22216) DEBUG:
db_mongodb
[mongodb_dbase.c:864]:
db_mongodb_query():
query to collection
[version]</div>
<div> 0(22216) DEBUG:
db_mongodb
[mongodb_dbase.c:898]:
db_mongodb_query():
query filter: {
"table_name" :
"location" }</div>
<div> 0(22216) DEBUG:
db_mongodb
[mongodb_dbase.c:917]:
db_mongodb_query():
columns filter: {
"table_version" : 1 }</div>
<div> 0(22216) DEBUG:
<core>
[db_res.c:120]:
db_new_result():
allocate 56 bytes for
result set at
0x7f735b5c4450</div>
<div> 0(22216) DEBUG:
db_mongodb
[mongodb_dbase.c:746]:
db_mongodb_store_result(): no result from mongodb</div>
<div> 0(22216) DEBUG:
<core>
[db.c:404]:
db_table_version(): no
row for table location
found</div>
<div> 0(22216) ERROR:
<core>
[db.c:450]:
db_check_table_version():
invalid version 0 for
table location found,
expected 9 (check
table structure and
table "version")</div>
<div> 0(22216) ERROR:
usrloc [dlist.c:659]:
register_udomain():
error during table
version check.</div>
<div> 0(22216) DEBUG:
<core>
[db_pool.c:100]:
pool_remove():
removing connection
from the pool</div>
<div> 0(22216) ERROR:
registrar
[registrar.c:651]:
domain_fixup(): failed
to register domain</div>
<div> 0(22216) ERROR:
<core>
[core/route.c:1154]:
fix_actions(): fixing
failed (code=-1) at
cfg:/usr/local/kamailio-5.1/et<wbr>c/kamailio/kamailio.cfg:660</div>
<div> 0(22216) ERROR:
<core>
[core/rvalue.c:3860]:
fix_rval_expr():
failure in cfg at
line: 660 col: 22</div>
<div> 0(22216) ERROR:
<core>
[core/rvalue.c:3860]:
fix_rval_expr():
failure in cfg at
line: 660 col: 22</div>
<div> 0(22216) ERROR:
<core>
[core/route.c:1154]:
fix_actions(): fixing
failed (code=-1) at
cfg:/usr/local/kamailio-5.1/et<wbr>c/kamailio/kamailio.cfg:663</div>
<div>ERROR: error -1
while trying to fix
configuration</div>
<div> 0(22216) DEBUG: tm
[t_funcs.c:85]:
tm_shutdown(): start</div>
<div> 0(22216) DEBUG: tm
[t_funcs.c:88]:
tm_shutdown():
emptying hash table</div>
<div> 0(22216) DEBUG: tm
[t_funcs.c:90]:
tm_shutdown():
removing semaphores</div>
<div> 0(22216) DEBUG: tm
[t_funcs.c:92]:
tm_shutdown():
destroying tmcb lists</div>
<div> 0(22216) DEBUG: tm
[t_funcs.c:95]:
tm_shutdown(): done</div>
<div> 0(22216) INFO:
<core>
[core/sctp_core.c:53]:
sctp_core_destroy():
SCTP API not
initialized</div>
<div> 0(22216) DEBUG:
<core>
[core/mem/shm.c:261]:
shm_destroy_manager():
destroying memory
manager: q_malloc</div>
<div> 0(22216) DEBUG:
<core>
[core/mem/q_malloc.c:1165]:
qm_shm_lock_destroy():
destroying the shared
memory lock</div>
<div> 0(22216) DEBUG:
<core>
[core/mem/pkg.c:91]:
pkg_destroy_manager():
destroying memory
manager: q_malloc</div>
<div><br>
</div>
<div><br>
</div>
<div>In mongoDB, I have
the collection
"version" in the db
kamailio, and the
entries needed for
usrloc (location and
location_attrs):</div>
<div>sre_location:PRIMARY>
use kamailio</div>
<div>switched to db
kamailio</div>
<div>sre_location:PRIMARY>
db.getCollection("version").fi<wbr>nd()</div>
<div>{ "_id" :
ObjectId("5a8ec43c601b262bef82<wbr>a595"),
"table_name" :
"location",
"table_version" : 9 }</div>
<div>{ "_id" :
ObjectId("5a8edb72a3ec40427577<wbr>b8d0"),
"table_name" :
"location_attrs",
"table_version" : 1 }</div>
<div><br>
</div>
<div><br>
</div>
<div>And logs in mongo
show the following
info when kamailio
starts:</div>
<div><br>
</div>
<div>2018-02-22T17:13:02.604+0100
I NETWORK [conn90]
received client
metadata from <a href="http://10.0.12.180:56320" target="_blank">10.0.12.180:56320</a>
conn: { driver: {
name: "mongoc",
version: "1.9.2" },
os: { type: "Linux",
name: "CentOS",
version: "6.9
(Final)",
architecture: "x86_64"
}, platform:
"cfg=0x1563000
posix=200809 CC=GCC
4.4.7 20120313 (Red
Hat 4.4.7-18)
CFLAGS="" LDFLAGS="""
}</div>
<div>2018-02-22T17:13:02.604+0100
I COMMAND [conn90]
command admin.$cmd
command: isMaster {
isMaster: 1, client: {
driver: { name:
"mongoc", version:
"1.9.2" }, os: { type:
"Linux", name:
"CentOS", version:
"6.9 (Final)",
architecture: "x86_64"
}, platform:
"cfg=0x1563000
posix=200809 CC=GCC
4.4.7 20120313 (Red
Hat 4.4.7-18)
CFLAGS="" LDFLAGS="""
}, compression: [],
$readPreference: {
mode:
"secondaryPreferred"
}, $db: "admin" }
numYields:0 reslen:716
locks:{}
protocol:op_query 0ms</div>
<div>2018-02-22T17:13:02.604+0100
I COMMAND [conn90]
command kamailio.$cmd
command: find { find:
"version", filter: {
table_name: "location"
}, table_version: 1,
$db: "kamailio",
$readPreference: {
mode:
"primaryPreferred" },
$clusterTime: {
clusterTime:
Timestamp(1519315979,
1), signature: { hash:
BinData(0,
000000000000000000000000000000<wbr>0000000000),
keyId: 0 } } }
numYields:0 reslen:531
locks:{}
protocol:op_msg 0ms</div>
<div>2018-02-22T17:13:02.605+0100
I NETWORK [conn90]
end connection <a href="http://10.0.12.180:56320" target="_blank">10.0.12.180:56320</a>
(9 connections now
open)</div>
<div><br>
</div>
<div>I probably miss
something: it is not
clear to me why
kamailio is not able
to retrieve the value
of table_version for
the table_name
location. Any idea
would be very welcome
!</div>
<div><br>
</div>
<div>I use
mongo-c-driver 1.9.2
and mongodb 3.6</div>
<div><br>
</div>
<div>Thank you.</div>
<div>Stephane</div>
</div>
<br>
<fieldset class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138m_17351067677194617mimeAttachmentHeader"></fieldset>
<br>
</div>
</div>
<pre>______________________________<wbr>_________________
Kamailio (SER) - Users Mailing List
<a class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138m_17351067677194617moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a>
<a class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138m_17351067677194617moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">https://lists.kamailio.org/cgi<wbr>-bin/mailman/listinfo/sr-users</a><span class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138HOEnZb"><font color="#888888">
</font></span></pre>
<span class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138HOEnZb"><font color="#888888"> </font></span></blockquote>
<span class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138HOEnZb"><font color="#888888"> <br>
<pre class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138m_17351067677194617moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138m_17351067677194617moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138m_17351067677194617moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - March 5-7, 2018, Berlin - <a class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138m_17351067677194617moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank">www.asipto.com</a>
Kamailio World Conference - May 14-16, 2018 - <a class="m_-5784163451845740932m_5123662677759671320m_6111474070442354138m_17351067677194617moz-txt-link-abbreviated" href="http://www.kamailioworld.com" target="_blank">www.kamailioworld.com</a></pre>
</font></span></div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
<pre class="m_-5784163451845740932m_5123662677759671320moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="m_-5784163451845740932m_5123662677759671320moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a class="m_-5784163451845740932m_5123662677759671320moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - March 5-7, 2018, Berlin - <a class="m_-5784163451845740932m_5123662677759671320moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank">www.asipto.com</a>
Kamailio World Conference - May 14-16, 2018 - <a class="m_-5784163451845740932m_5123662677759671320moz-txt-link-abbreviated" href="http://www.kamailioworld.com" target="_blank">www.kamailioworld.com</a></pre>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre class="m_-5784163451845740932moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="m_-5784163451845740932moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a class="m_-5784163451845740932moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - March 5-7, 2018, Berlin - <a class="m_-5784163451845740932moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank">www.asipto.com</a>
Kamailio World Conference - May 14-16, 2018 - <a class="m_-5784163451845740932moz-txt-link-abbreviated" href="http://www.kamailioworld.com" target="_blank">www.kamailioworld.com</a></pre>
</div></div></div>
</blockquote></div><br></div>