Page 1 of 1

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

PostPosted: Tue Dec 26, 2006 11:14 am
by AlexR
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

PostPosted: Tue Dec 26, 2006 11:40 am
by mflorell
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.