Re: [asterisk-users] Duplicate UNIQUEID on CDR
On Wed, 2007-06-06 at 12:43 +0100, Steve Davies wrote: On 5/31/07, Carlos Chavez [EMAIL PROTECTED] 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 smime.p7s Description: S/MIME cryptographic signature ___ --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
Re: [asterisk-users] Duplicate UNIQUEID on CDR
On 5/31/07, Carlos Chavez [EMAIL PROTECTED] 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. 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
[asterisk-users] Duplicate UNIQUEID on CDR
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. -- Telecomunicaciones Abiertas de México S.A. de C.V. Carlos Chávez Prats Director de Tecnología +52-55-91169161 ext 2001 signature.asc Description: This is a digitally signed message part ___ --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