[asterisk-users] Duplicate UNIQUEID on CDR

[Steve Murphy]

On Wed, 2007-06-06 at 12:43 +0100, Steve Davies wrote:
> On 5/31/07, Carlos Chavez <cursor at telecomabmex.com> wrote:
> >         Sometimes I get the following error on the console:
> >
> > [May 31 11:14:01] ERROR[23502]: cdr_addon_mysql.c:230 mysql_log:
> > mysql_cdr: Failed to insert into database: (1062) Duplicate entry
> > '1180628004.3214' for key 1    -- Zap/38-1 answered UniCall/11-1
> >
> >         Why would the UNIQUEID be duplicated?  Isn't is supposed to be UNIQUE?
> > This worries me a bit because the customer is losing calls that will not
> > appear in their CDR records for billing.
> >
> 
> As far as I know, you can have several CDR records for a single call.
> The unique-id is only unique for the call, and is not necessarily
> unique in a database context.

I agree. In the stuff I'll be doing, I purposely try to group records
involving transfers with the same uniqueid. I can do this for all the
call segments involved in a single bridge.

You might look at the table definition for MySQL and see if the uniqueid
is marked as "UNIQUE", if so, remove that spec from that column...

murf

> 
> Steve
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3239 bytes
Desc: not available
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20070607/fdc5f402/smime.bin