[asterisk-users] Duplicate CDR's in mysql

Mike Diehl mdiehlenator at gmail.com
Thu Jan 4 12:44:33 CST 2018


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

Any ideas would be appreciated.



-- 
Mike Diehl                                
Diehlnet Communications, LLC.     
Sales: (800) 254-6105               
Support: (505) 903-5700                 
Fax: (505) 903-5701                      

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


More information about the asterisk-users mailing list