What operating system are you running, and how big are these files and indicies? Is this a 2 Gig file size limit problem? You are getting near the limit to the size of an unsigned mediumint. Dan Shapella wrote: > > I have a weird one here. > > I have an application that inserts records into one of 2 different tables. > The other day, an insert attempt on one of the tables failed with a > duplicate key error on key 1, an autoincrement field. About a minute later, > an insert attempt on the other table failed similarly. But, when a SELECT > was done on each table for the key value in question, no record was found. > > The autoincrement values in question were 16288908 for the first table, and > 11339940 for the second table. These tables handle thousands of inserts per > day, and all other table activity is read-only via SELECT statements. > > Does anyone have any idea what may have caused this and what can be done to > prevent it? It is as if MySQL built the record with key value 16288908, > placed it in the table cache, built another record with the same key, tried > to place that in the table cache and failed, reported the error, and then > deleted the record from the table cache before it was written into the > actual table. > > I did a "myisamchk -i" on the first table, which generated the following: > > Checking MyISAM file: attempt.MYI > Data records: 16288907 Deleted blocks: 0 > /usr/local/bin/myisamchk: warning: Table is marked as crashed > /usr/local/bin/myisamchk: warning: 1 clients is using or hasn't closed the > table properly > - check file-size > - check key delete-chain > - check record delete-chain > - check index reference > - check data record references index: 1 > /usr/local/bin/myisamchk: error: Found key at page 280732672 that points to > record outside datafile > - check record links > /usr/local/bin/myisamchk: error: Checksum for key: 1 doesn't match checksum > for records > /usr/local/bin/myisamchk: error: Checksum for key: 2 doesn't match checksum > for records > > Record blocks: 16288907 Delete blocks: 0 > Record data: 1829202488 Deleted data: 0 > Lost space: 12006835 Linkdata: 61081997 > MyISAM-table 'attempt.MYI' is corrupted > Fix it using switch "-r" or "-o" > > Any suggestions would be greatly appreciated. Thanks! > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
