DBD::mysql::db do failed: Duplicate entry

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

DBD::mysql::db do failed: Duplicate entry

Postby AlexR » Tue Dec 26, 2006 11:14 am

Hello All! Merry Christmas best wishes for everyone in the forum!

Matt... remember that some days ago i had problems with remote agents? I think I am narrowing down the problem.

in FASTAGI_log screen i am getting the following message

Code: Select all
DBD::mysql::db do failed: Duplicate entry '1167149258.1093409' for key 1 at /usr/share/astguiclient/FastAGI_log.pl line 409, <STDIN> line 21.


how is this key generated? (i beleive it is asterisk generated...)

I had some clock issues with this machine so i know that some timestamps in my DB could have been wrong. If this key field is somehow generated using the day i can understand why this is failing.

I am looking for a way to "reseed", but I worry that I might need to reinstall everything again (on a production serevr) if this is not a MySQL generated key.


Any comments anyone!?


Thank you all! and happy holidays!

alejandro
AlexR
 
Posts: 127
Joined: Mon Aug 21, 2006 5:02 pm

Postby mflorell » Tue Dec 26, 2006 11:40 am

This is a MySQL error, but the uniqueid value is generated by Asterisk.

Generally, this failure is not a critical fault, and I have seen it on production systems that run just fine.
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: MSN [Bot] and 245 guests