<h3>Description</h3>
<p>on upgrade to 5.1.2, db_mongodb broke</p>
<h3>Troubleshooting</h3>
<p>i create a <a href="https://github.com/kamailio/kamailio/pull/1477">PR</a> to print out any mongo query error</p>
<p>then i saw the debug messages below</p>
<h4>Reproduction</h4>
<p>install 5.1.2, use mongo as db for sip_trace module</p>
<h4>Debugging Data</h4>
<pre><code>DEBUG: db_mongodb [mongodb_connection.c:55]: db_mongodb_new_connection(): connection open to: mongodb://user:pass@mongo1.abc.com:17017/collection
DEBUG: db_mongodb [mongodb_dbase.c:904]: db_mongodb_query(): query to collection [version]
DEBUG: db_mongodb [mongodb_dbase.c:938]: db_mongodb_query(): query filter: { "table_name" : "sip_trace" }
DEBUG: db_mongodb [mongodb_dbase.c:966]: db_mongodb_query(): columns filter: { "projection" : { "table_version" : 1 } }
DEBUG: db_mongodb [mongodb_dbase.c:782]: db_mongodb_store_result(): An error occurred: Unsupported projection option: projection: { table_version: 1 }
ERROR: <core> [db.c:450]: db_check_table_version(): invalid version 0 for table sip_trace found, expected 4 (check table structure and table "version")
ERROR: siptrace [siptrace.c:435]: child_init(): error during table version check
ERROR: <core> [core/sr_module.c:942]: init_mod_child(): error while initializing module siptrace (/usr/lib64/kamailio/modules/siptrace.so) (idx: 39 rank: -2 desc: [Http Async Worker])
</code></pre>
<h4>Log Messages</h4>
<h4>SIP Traffic</h4>
<h3>Possible Solutions</h3>
<p>change the way mongo builds the query</p>
<h3>Additional Information</h3>
<ul>
<li><strong>Kamailio Version</strong> - output of <code>kamailio -v</code></li>
</ul>
<pre><code>version: kamailio 5.1.2 (x86_64/linux) 
flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
id: unknown 
compiled on 06:43:15 Mar  9 2018 with gcc 4.8.2

</code></pre>
<ul>
<li><strong>Operating System</strong>:</li>
</ul>

<pre><code>Ubuntu 14.04.1 LTS \n \l

Linux hostname 3.13.0-53-generic #89-Ubuntu SMP Wed May 20 10:34:39 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

</code></pre>

<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/1479">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AF36ZQW30xFH39eb0UVWeLlPyAjbITEDks5tcjShgaJpZM4Sj4Zd">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AF36ZeQdE2aruciKpC3YWnF21G7OmO8Cks5tcjShgaJpZM4Sj4Zd.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/1479"></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":"db_mongodb has a problem with projection (#1479)"}],"action":{"name":"View Issue","url":"https://github.com/kamailio/kamailio/issues/1479"}}}</script>