<div dir="ltr">Hi,<br><br>please check your cluster definition:<br>You requested parallel operations "8p" on the the connection, so it will write into con1 AND con2. What did you expect? ;-)<br><br>"Command mode is a character among s, r and p. s is for doing serial operations (try first and if fails, try next); r is for doing round robin operations; p - is for doing parallel operations (this is valid only for write operations)."<br><a href="http://www.kamailio.org/docs/modules/devel/modules/db_cluster#db_cluster.p.connection">http://www.kamailio.org/docs/modules/devel/modules/db_cluster#db_cluster.p.connection</a><br><br>Thanks,<br>Carsten<br><div><div><br></div><p style="font-family:Helvetica,Arial;font-size:12px;text-align:justify;color:rgb(0,0,0)"></p></div><img src="http://t.sidekickopen62.com/e1t/o/5/f18dQhb0S7ks8dDMPbW2n0x6l2B9gXrN7sKj6v4LGF6VcW1262m64hLW3xdLSP72TN_3d7C-zj01?si=6230090009280512&pi=639698f8-cdea-473e-b760-d2fb9126d93b" style="display:none!important" height="1" width="1"></div><div class="gmail_extra"><br><div class="gmail_quote">2016-08-09 9:54 GMT+02:00 Jan Hazenberg <span dir="ltr"><<a href="mailto:jenus@cyberchaos.nl" target="_blank">jenus@cyberchaos.nl</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
I have a issue with the db_cluster module. All works fine but when i enable ACC records to the database i get duplicate entry's in the acc table. I have 2 nodes enabled:<br>
<br>
# ----- db_cluster params -----<br>
modparam("db_cluster", "connection",<br>
"con1=>mysql://<a href="http://kamailio:password@10.1.1.1/kamailio" rel="noreferrer" target="_blank">kamailio:passw<wbr>ord@10.1.1.1/kamailio</a>")<br>
modparam("db_cluster", "connection",<br>
"con2=>mysql://<a href="http://kamailio:password@10.1.1.2/kamailio" rel="noreferrer" target="_blank">kamailio:passw<wbr>ord@10.1.1.2/kamailio</a>")<br>
<br>
modparam("db_cluster", "cluster", "cls1=>con1=9s8p;con2=9s8p")<br>
<br>
When i remove one node from the pool the acc records look fine. Could this be a bug? Or should i bypass the db_cluster for accounting?<br>
<br>
I'm running kamailio 4.4.2.<br>
<br>
Thanks,<br>
<br>
Jan Hazenberg<br>
<br>
______________________________<wbr>_________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cg<wbr>i-bin/mailman/listinfo/sr-user<wbr>s</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Carsten Bock<br>CEO (Geschäftsführer)<br><br>ng-voice GmbH<br>Millerntorplatz 1<br>20359 Hamburg / Germany<br><br><a href="http://www.ng-voice.com" target="_blank">http://www.ng-voice.com</a><br>mailto:<a href="mailto:carsten@ng-voice.com" target="_blank">carsten@ng-voice.com</a><br><br>Office +49 40 5247593-40<br>Fax +49 40 5247593-99<br><br>Sitz der Gesellschaft: Hamburg<br>Registergericht: Amtsgericht Hamburg, HRB 120189<br>Geschäftsführer: Carsten Bock<br>Ust-ID: DE279344284<br><br>Hier finden Sie unsere handelsrechtlichen Pflichtangaben:<br><a href="http://www.ng-voice.com/imprint/" target="_blank">http://www.ng-voice.com/imprint/</a></div>
</div>