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>
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>