Hi! ----- Original Message ----- From: "My Deja" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, January 16, 2003 12:39 PM Subject: InnoDB is losing records, there are gaps in autoincrement sequence
> InnoDB appears to be losing records. > > The version I am using is 3.32.53 in Windows 2000. > > Gaps are appearing in the autoincrement sequence when > the application does not permit record deletions. > > Records disappear although they have been retrieved > for printing earlier. I have not seen this kind of bug reported. Are you sure you do not roll back the insertions? Or delete the rows? The auto-inc sequence will not be continuous if you roll back insertions, or delete rows. > Does anyone know how this problem can be fixed? > > I am checking the application code to see if records > can be deleted, either deliberately or accidentally. > > Has anyone come across such a problem? > > (sql,query,database,odbc - spam block bypass) Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php