I believe the problem occurs only when I execute the DELETE when someone is inserting a records at the same time. Perhaps the hash index is not updated properly whereas the data are deleted properly, which entails a mismatch between data and index ? (I believe this because the following behaviour :
mysql> INSERT INTO online1 SELECT * FROM online; Query OK, 139 rows affected (0.01 sec) Records: 139 Duplicates: 0 Warnings: 0 mysql> DELETE FROM online1 WHERE date < 10151111111; Query OK, 139 rows affected (0.01 sec) mysql> SELECT * FROM online1; Empty set (0.00 sec) mysql> DELETE FROM online WHERE date < 10151111111; Query OK, 141 rows affected (0.00 sec) mysql> SELECT * FROM online; ERROR 1030: Got error 124 from table handler ) online1 table is not used by anyone, I create it for the testcase, but the online table is heavily used and updated. ----- Original Message ----- From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 3:31 PM Subject: Re: Bug with heap table ?? > Fournier Jocelyn [Presence-PC] writes: > > Hi, > > > > I encounter a strange problem on one of my server with a lot of heap table. > > (I'm using latest mysql-4.0.2 version) > > Here is the error : > > > > mysql> use forum; > > Database changed > > mysql> SELECT * FROM online; > > ERROR 1030: Got error 124 from table handler > > mysql> SELECT * FROM online; > > ERROR 1030: Got error 124 from table handler > > mysql> SELECT * FROM online; > > +---------+------------+-----+-------+--------+ > > | pseudo | date | cat | forum | search | > > +---------+------------+-----+-------+--------+ > > | wipe0ut | 1015040309 | 1 | 1 | 0 | > > | thoomis | 1015040303 | 4 | 1 | 0 | > > +---------+------------+-----+-------+--------+ > > 2 rows in set (0.00 sec) > > > > How could this be possible with a heap table ?? > > > > Thank you :) > > > > Regards, > > > > Jocelyn Fournier > > Presence-PC > > > > This looks like our bug. > > I am not going to ask you to upload a table ...;o;) > > However, can you make us a test case. > > -- > Regards, > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus > <___/ www.mysql.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