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