[asterisk-users] Duplicate CDR's in Mysql

[Mike Diehl]

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/20180114/9b487c93/attachment.html>