I was running FreePBX Distro 5.211.65 and used the upgrade script to migrate to 6.12.65-20 and FreePBX 12 (using Asterisk 12). After applying all the module updates, etc., I noticed that the CDR started having multiple (duplicate) entries for every inbound call. At first I thought it was just the CDR frontend (a join or something). But was was logged into the Asterisk console and watching messages when I tested with another call. What I got there appears to be what looks like multiple inserts into CEL and CDR. I can understand multiple inserts into CEL for state changes, but the CDR inserts all appear to be identical:
> [INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,userfield) VALUES ('HANGUP',{ts '2014-12-09 08:03:14'},'MARK J BAILEY','615YYYYYYY','615YYYYYYY','','615XXXXXXX','h','ext-group','SIP/vitel-inbound-0000001c','','',3,'','1418133786.160','1418133786.160','','','')]
> [INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,userfield) VALUES ('CHAN_END',{ts '2014-12-09 08:03:14'},'MARK J BAILEY','615YYYYYYY','615YYYYYYY','','615XXXXXXX','h','ext-group','SIP/vitel-inbound-0000001c','','',3,'','1418133786.160','1418133786.160','','','')]
> [INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,userfield) VALUES ('LINKEDID_END',{ts '2014-12-09 08:03:14'},'MARK J BAILEY','615YYYYYYY','615YYYYYYY','','615XXXXXXX','h','ext-group','SIP/vitel-inbound-0000001c','','',3,'','1418133786.160','1418133786.160','','','')]
> [INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid,recordingfile,did,cnum,cnam) VALUES ({ ts '2014-12-09 08:03:06' },'"MARK J BAILEY" <615YYYYYYY>','615YYYYYYY','778','ext-group','SIP/vitel-inbound-0000001c','SIP/2101-0000001d','Dial','SIP/2101&SIP/2864&SIP/2150&SIP/2120&SIP/2140&SIP/2549&SIP/2548&SIP/8501&SIP/219',8,8,'NO ANSWER',3,'1418133786.160','in-615XXXXXXX-615YYYYYYY-20141209-080306-1418133786.160.wav','615XXXXXXX','615YYYYYYY','MARK J BAILEY')]
> [INSERT INTO cdr (calldate,clid,src,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid,recordingfile,did,cnum,cnam) VALUES ({ ts '2014-12-09 08:03:10' },'"MARK J BAILEY" <615YYYYYYY>','615YYYYYYY','SIP/vitel-inbound-0000001c','SIP/2864-0000001e','Dial','SIP/2101&SIP/2864&SIP/2150&SIP/2120&SIP/2140&SIP/2549&SIP/2548&SIP/8501&SIP/219',3,3,'NO ANSWER',3,'1418133786.160','in-615XXXXXXX-615YYYYYYY-20141209-080306-1418133786.160.wav','615XXXXXXX','615YYYYYYY','MARK J BAILEY')]
> [INSERT INTO cdr (calldate,clid,src,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid,recordingfile,did,cnum,cnam) VALUES ({ ts '2014-12-09 08:03:10' },'"MARK J BAILEY" <615YYYYYYY>','615YYYYYYY','SIP/vitel-inbound-0000001c','SIP/2150-0000001f','Dial','SIP/2101&SIP/2864&SIP/2150&SIP/2120&SIP/2140&SIP/2549&SIP/2548&SIP/8501&SIP/219',3,3,'NO ANSWER',3,'1418133786.160','in-615XXXXXXX-615YYYYYYY-20141209-080306-1418133786.160.wav','615XXXXXXX','615YYYYYYY','MARK J BAILEY')]
> [INSERT INTO cdr (calldate,clid,src,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid,recordingfile,did,cnum,cnam) VALUES ({ ts '2014-12-09 08:03:10' },'"MARK J BAILEY" <615YYYYYYY>','615YYYYYYY','SIP/vitel-inbound-0000001c','SIP/2549-00000020','Dial','SIP/2101&SIP/2864&SIP/2150&SIP/2120&SIP/2140&SIP/2549&SIP/2548&SIP/8501&SIP/219',3,3,'NO ANSWER',3,'1418133786.160','in-615XXXXXXX-615YYYYYYY-20141209-080306-1418133786.160.wav','615XXXXXXX','615YYYYYYY','MARK J BAILEY')]
> [INSERT INTO cdr (calldate,clid,src,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid,recordingfile,did,cnum,cnam) VALUES ({ ts '2014-12-09 08:03:10' },'"MARK J BAILEY" <615YYYYYYY>','615YYYYYYY','SIP/vitel-inbound-0000001c','SIP/2548-00000021','Dial','SIP/2101&SIP/2864&SIP/2150&SIP/2120&SIP/2140&SIP/2549&SIP/2548&SIP/8501&SIP/219',3,3,'NO ANSWER',3,'1418133786.160','in-615XXXXXXX-615YYYYYYY-20141209-080306-1418133786.160.wav','615XXXXXXX','615YYYYYYY','MARK J BAILEY')]
> [INSERT INTO cdr (calldate,clid,src,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid,recordingfile,did,cnum,cnam) VALUES ({ ts '2014-12-09 08:03:10' },'"MARK J BAILEY" <615YYYYYYY>','615YYYYYYY','SIP/vitel-inbound-0000001c','SIP/8501-00000022','Dial','SIP/2101&SIP/2864&SIP/2150&SIP/2120&SIP/2140&SIP/2549&SIP/2548&SIP/8501&SIP/219',3,3,'NO ANSWER',3,'1418133786.160','in-615XXXXXXX-615YYYYYYY-20141209-080306-1418133786.160.wav','615XXXXXXX','615YYYYYYY','MARK J BAILEY')]
> [INSERT INTO cdr (calldate,clid,src,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid,recordingfile,did,cnum,cnam) VALUES ({ ts '2014-12-09 08:03:10' },'"MARK J BAILEY" <615YYYYYYY>','615YYYYYYY','SIP/vitel-inbound-0000001c','SIP/2190-00000023','Dial','SIP/2101&SIP/2864&SIP/2150&SIP/2120&SIP/2140&SIP/2549&SIP/2548&SIP/8501&SIP/219',3,3,'NO ANSWER',3,'1418133786.160','in-615XXXXXXX-615YYYYYYY-20141209-080306-1418133786.160.wav','615XXXXXXX','615YYYYYYY','MARK J BAILEY')]
I do use a ring group as indicated above.
This all started with the upgrade. I haven’t opened a ticket yet as I wanted to see if anyone else had experienced this. I have not tried to see what happens with a fresh install of 6.12.65 yet.
Thanks!
Mark