[SR-Users] Duplicate ACC records in db when using db_cluster

[Carsten Bock]

Hi,

please check your cluster definition:
You requested parallel operations "8p" on the the connection, so it will
write into con1 AND con2. What did you expect? ;-)

"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)."
http://www.kamailio.org/docs/modules/devel/modules/db_cluster#db_cluster.p.connection

Thanks,
Carsten


2016-08-09 9:54 GMT+02:00 Jan Hazenberg <jenus at cyberchaos.nl>:

> Hi,
>
> 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:
>
> # ----- db_cluster params -----
> modparam("db_cluster", "connection",
>              "con1=>mysql://kamailio:password@10.1.1.1/kamailio")
> modparam("db_cluster", "connection",
>              "con2=>mysql://kamailio:password@10.1.1.2/kamailio")
>
> modparam("db_cluster", "cluster", "cls1=>con1=9s8p;con2=9s8p")
>
> 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?
>
> I'm running kamailio 4.4.2.
>
> Thanks,
>
> Jan Hazenberg
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>



-- 
Carsten Bock
CEO (Geschäftsführer)

ng-voice GmbH
Millerntorplatz 1
20359 Hamburg / Germany

http://www.ng-voice.com
mailto:carsten at ng-voice.com

Office +49 40 5247593-40
Fax +49 40 5247593-99

Sitz der Gesellschaft: Hamburg
Registergericht: Amtsgericht Hamburg, HRB 120189
Geschäftsführer: Carsten Bock
Ust-ID: DE279344284

Hier finden Sie unsere handelsrechtlichen Pflichtangaben:
http://www.ng-voice.com/imprint/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160809/d784f148/attachment.html>