<div dir="ltr"><div><div><div>Hi Razvan,<br></div>any news on this issue?<br></div>regards<br></div>Stefan<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 10, 2017 at 11:21 AM, Stefan Tobé <span dir="ltr"><<a href="mailto:stefan.tobe@pmfactory.nl" target="_blank">stefan.tobe@pmfactory.nl</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"><div><div>Hi Razvan,<br>mode is PARALLEL<br><br>modparam("db_virtual", "db_urls", "define pmset PARALLEL")<br><br></div>yes I have again verified that the virtdb has only one member in my config, the same that is used for both registration and de-registration</div><div><br></div><div>currently running on real mysql db backend which is doing OK consistently for test.<span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"><div><br></div>Stefan<br></font></span><div><div><br><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Tue, Oct 10, 2017 at 9:13 AM, Răzvan Crainea <span dir="ltr"><<a href="mailto:razvan@opensips.org" target="_blank">razvan@opensips.org</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<div text="#000000" bgcolor="#FFFFFF">
<tt>Hi, Stefan!<br>
<br>
What is the mode[1] you are using for db_virtual? Are you sure the
query is not ran on a different database/URL?<br>
<br>
[1]
<a class="m_-7495087240071550043m_6898754551421120470moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/2.3.x/db_virtual.html#idp4722368" target="_blank">http://www.opensips.org/html/d<wbr>ocs/modules/2.3.x/db_virtual.h<wbr>tml#idp4722368</a><br>
<br>
Best regards,</tt><span>
<pre class="m_-7495087240071550043m_6898754551421120470moz-signature" cols="72">Răzvan Crainea
OpenSIPS Developer
<a class="m_-7495087240071550043m_6898754551421120470moz-txt-link-abbreviated" href="http://www.opensips-solutions.com" target="_blank">www.opensips-solutions.com</a></pre>
</span><span><div class="m_-7495087240071550043m_6898754551421120470moz-cite-prefix">On 10/09/2017 06:24 PM, Stefan Tobé
wrote:<br>
</div>
<blockquote type="cite">
<div dir="auto">
<div dir="ltr">
<div>
<div>
<div>Hi Razvan<br>
</div>
Interesting detail is that the flushing of binding works
OK<br>
</div>
when I use real backend mysql instead of virtual_db<br>
<br>
</div>
so when I put the following snippet in place in opensips.cfg
it does work correctly/as expected<br>
modparam("usrloc", "db_url","mysql://opensips:ope<wbr>nsipsrw@XXXXXXX/opensips")<br>
### TEMP MOD<br>
#modparam("usrloc", "db_url","virtual://pmset")</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">So the virtdb module does something wrong or at
least delays flushing queries in this case<br>
</div>
</div>
</blockquote>
</span></div>
<br></div></div><span class="">______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a><br>
<br></span></blockquote></div><span class=""><br><br clear="all"><br>-- <br><div class="m_-7495087240071550043gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><span><div>mvg<br>Stefan Tobé<br><br></div><br></span></div><div><div><span>PM Factory B.V.<br>Bolderweg 2<br>1332 AT Almere<br>tel: 06 21 26 59 68<br>email: <a href="mailto:stefan.tobe@privatemobility.nl" target="_blank">stefan.tobe@pmfactory.nl</a><br></span></div><div><span>PGP public key: <a href="https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing" target="_blank">click here to download</a><br></span></div><div><span><br><a href="http://www.privatemobility.nl" target="_blank"></a></span></div></div></div></div></div></div></div></div></div></div>
</span></div></div></div></div>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><span><div>mvg<br>Stefan Tobé<br><br></div><br></span></div><div><div><span>PM Factory B.V.<br>Bolderweg 2<br>1332 AT Almere<br>tel: 06 21 26 59 68<br>email: <a href="mailto:stefan.tobe@privatemobility.nl" target="_blank">stefan.tobe@pmfactory.nl</a><br></span></div><div><span>PGP public key: <a href="https://drive.google.com/file/d/0Bzu42C2IZ1uMNDYzVnM2dkppRVE/view?usp=sharing" target="_blank">click here to download</a><br></span></div><div><span><br><a href="http://www.privatemobility.nl" target="_blank"></a></span></div></div></div></div></div></div></div></div></div></div>
</div>