Re: [asterisk-users] Duplicate CDR's in Mysql
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 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Duplicate CDR's in Mysql
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 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Duplicate CDR's in mysql
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 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users