Hi, In fact it seems to be really hard to reproduce and to provide you a testcase, because I've no idea of what could be the reason of this error. I've an other site with exactly the same table structure, and it runs without a glitch. The only clue I have is that the server which return the error contains far more heap table (about 433 heap tables vs only 14 heap tables). I don't think it could be memory corruption problem, the server works like a charm without any other errors.
Anyway, here is the table structure : mysql> DESCRIBE online; +--------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+---------------------+------+-----+---------+-------+ | pseudo | char(35) | | PRI | | | | date | bigint(20) unsigned | | MUL | 0 | | | cat | tinyint(4) unsigned | | | 0 | | | forum | tinyint(3) unsigned | | MUL | 0 | | | search | tinyint(1) unsigned | | | 0 | | +--------+---------------------+------+-----+---------+-------+ 5 rows in set (0.00 sec) Oddly it seems to occur only when there is not so much activity in the forum (late in the night in fact). Oh, I've just find out how to reproduce the bug (I just think that late in the night the table could be empty ;)) : mysql> SELECT * FROM online; +-----------------+------------+-----+-------+--------+ | pseudo | date | cat | forum | search | +-----------------+------------+-----+-------+--------+ | wiser 2002 | 1015081015 | 0 | 80 | 0 | | Doc13 | 1015081086 | 0 | 32 | 0 | | Homertrix | 1015081112 | 13 | 4 | 0 | | Beleg | 1015081005 | 4 | 48 | 0 | | RdTeCh | 1015081096 | 9 | 4 | 0 | | guidodo | 1015081073 | 2 | 1 | 0 | | Texla | 1015081067 | 10 | 4 | 0 | | smailer | 1015081046 | 4 | 22 | 0 | | Yop | 1015081071 | 5 | 42 | 0 | | Estrope | 1015081043 | 6 | 89 | 0 | | vicber | 1015081102 | 10 | 1 | 0 | | RuShK | 1015081114 | 4 | 1 | 0 | | Kobbe | 1015081067 | 5 | 99 | 0 | | mAzee | 1015081108 | 4 | 1 | 0 | | Yoko54 | 1015081111 | 5 | 74 | 0 | | Prin | 1015081039 | 10 | 4 | 0 | | jojolapatate | 1015081118 | 2 | 1 | 0 | | BestBarn@b | 1015081087 | 4 | 1 | 0 | | FLo14 | 1015081025 | 4 | 1 | 0 | | coco666 | 1015081081 | 3 | 32 | 0 | | yonnar tsewarac | 1015081090 | 0 | 48 | 0 | | Kangol | 1015081117 | 4 | 1 | 0 | +-----------------+------------+-----+-------+--------+ 22 rows in set (0.00 sec) mysql> DELETE FROM online WHERE date < 10015111111; Query OK, 21 rows affected (0.01 sec) mysql> SELECT * FROM online; ERROR 1030: Got error 124 from table handler So the problem is here when the table is empty. (I've just reproduce exactly the same problem on my other server :)) I doesn't succeed in producing a real testcase right now, but I will try ASAP. Regards, Jocelyn Fournier ----- 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
