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, 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
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] / /|_/ / // /\ \/ /_/ / /__ 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
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 ??
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
