MySQL Forums
Forum List  »  InnoDB

Re: Duplicate Entry for an Auto-increment column
Posted by: Luis
Date: September 14, 2006 10:45AM

Sorry for my poor english ...

I have a similar problem. My aplication is saving images 24 hours for a day, 7 days for a week. I am saving long variable size registers at 4 or 5 frames per second. After of 2 or 3 days MySQL says "Duplicate entry '<some number>' for key 1". In this moment the Data Base is inusable.

I have tried with good result close and open de Data Base in this moment. Is blocking MySQL in high performance aplications?

I want prevent this reset for best efficiency. If you discover how, tell me please.

This is my post (in spanish :),115697,115697#msg-115697

Options: ReplyQuote

Written By
Re: Duplicate Entry for an Auto-increment column
September 14, 2006 10:45AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.