Re: Bug with heap table ??
Fournier Jocelyn [Presence-PC] writes: > 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 < 1015111; > Query OK, 139 rows affected (0.01 sec) > > mysql> SELECT * FROM online1; > Empty set (0.00 sec) > > mysql> DELETE FROM online WHERE date < 1015111; > 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. > Hi! I have a temporary fix for you. Final fix will come in 4.0.2. *** tmp/hp_rnext.c Wed Mar 6 21:55:06 2002 --- heap/hp_rnext.c Wed Mar 6 14:39:16 2002 *** *** 24,29 --- 24,35 HP_SHARE *share=info->s; DBUG_ENTER("heap_rnext"); + if (!(info->s->records)) + { + my_errno=HA_ERR_END_OF_FILE; + DBUG_RETURN(my_errno); + } + if (info->lastinx < 0) DBUG_RETURN(my_errno=HA_ERR_WRONG_INDEX); -- 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
Re: Bug with heap table ??
Fournier Jocelyn [Presence-PC] writes: > Hi, > [skip] > 22 rows in set (0.00 sec) > > mysql> DELETE FROM online WHERE date < 1001511; > 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 > Please, save me some trouble and send me gzipped dump of the table. -- 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
Re: Bug with heap table ??
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 < 1015111; Query OK, 139 rows affected (0.01 sec) mysql> SELECT * FROM online1; Empty set (0.00 sec) mysql> DELETE FROM online WHERE date < 1015111; 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
Re: Bug with heap table ??
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 | 101508 | 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 < 1001511; 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]> > / /|_/ / //
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
Bug with heap table ??
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 - 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