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

[Jan Hazenberg]

Carsten, 

Indeed my bad, typical case of RTFM ;) 

Jan 

Carsten Bock schreef op 2016-08-09 10:24: 

> 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 [4]
> 
> 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 [1]")
>> modparam("db_cluster", "connection",
>> "con2=>mysql://kamailio:password@10.1.1.2/kamailio [2]")
>> 
>> 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 [3]
> 
> -- 
> 
> Carsten Bock
> CEO (Geschäftsführer)
> 
> ng-voice GmbH
> Millerntorplatz 1
> 20359 Hamburg / Germany
> 
> http://www.ng-voice.com [5]
> 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/ [6] 
> 
> _______________________________________________
> 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 [3]

 

Links:
------
[1] http://kamailio:password@10.1.1.1/kamailio
[2] http://kamailio:password@10.1.1.2/kamailio
[3] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
[4]
http://www.kamailio.org/docs/modules/devel/modules/db_cluster#db_cluster.p.connection
[5] http://www.ng-voice.com
[6] http://www.ng-voice.com/imprint/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160809/93adbd58/attachment.html>