[asterisk-users] Duplicate CDR's in Mysql

Carlos Chavez cursor at telecomab.mx
Mon Jan 15 11:06:17 CST 2018


On 1/14/18 4:22 PM, Mike Diehl wrote:

> Hi all,
>
> I have a problem I've not seen before. My Asterisk server stores CDR's 
> via mysql, and I'm getting duplicate records.
>
> For example:
>
> mysql> select uniqueid,count(*) from cdr group by uniqueid having 
> count(*)>1;
>
> +--------------------------+----------+
>
> | uniqueid | count(*) |
>
> +--------------------------+----------+
>
> | server12-1515090905.2182 | 5 |
>
> | server12-1515091190.2215 | 3 |
>
> +--------------------------+----------+
>
> 2 rows in set (0.68 sec)
>
> If I query for each uniqueid, I see that the records are identical. I 
> have a Perl script that goes through and removes the duplicates. 
> Otherwise, EVERY CDR would be duplicated.
>
> Now, my Asterisk server was configured with multiple CDR backends, but 
> I unloaded those modules. Here is what I have configured during run-time:
>
> *CLI> cdr show status
>
> Call Detail Record (CDR) settings
>
> ----------------------------------
>
> Logging: Enabled
>
> Mode: Simple
>
> Log unanswered calls: No
>
> Log congestion: No
>
> * Registered Backends
>
> -------------------
>
> cdr-custom
>
> Adaptive ODBC
>
>
     I have exactly the same problem.  All CDRs get duplicated. Using 
ODBC and Mariadb on Asterisk 13.8

-- 
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)8116-9161

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20180115/c0b80a12/attachment.html>


More information about the asterisk-users mailing list