List:Bugs« Previous MessageNext Message »
From:Michael Widenius Date:April 11 2000 11:12am
Subject:update bug
View as plain text  
Hi!

>>>>> "suopanki" == suopanki  <suopanki@stripped> writes:

>> Description:
suopanki> The following code will hang MySQL
suopanki> (tested on Solaris and Linux)

>> How-To-Repeat:

suopanki> CREATE TABLE ctest (ord int(10) NOT NULL,  KEY ord (ord));
suopanki> INSERT INTO ctest VALUES (8192);
suopanki> INSERT INTO ctest VALUES (24576);
suopanki> INSERT INTO ctest VALUES (28672);
suopanki> INSERT INTO ctest VALUES (32768);
suopanki> INSERT INTO ctest VALUES (53248);
suopanki> INSERT INTO ctest VALUES (65536);
suopanki> INSERT INTO ctest VALUES (69632);
suopanki> INSERT INTO ctest VALUES (69633);
suopanki> INSERT INTO ctest VALUES (69634);
suopanki> INSERT INTO ctest VALUES (69635);
suopanki> INSERT INTO ctest VALUES (69636);
suopanki> INSERT INTO ctest VALUES (73728);
suopanki> INSERT INTO ctest VALUES (94208);
suopanki> INSERT INTO ctest VALUES (98305);
suopanki> INSERT INTO ctest VALUES (102405);
suopanki> INSERT INTO ctest VALUES (106496);
suopanki> INSERT INTO ctest VALUES (110592);
suopanki> INSERT INTO ctest VALUES (131072);
suopanki> INSERT INTO ctest VALUES (135168);
suopanki> INSERT INTO ctest VALUES (147456);
suopanki> UPDATE ctest SET ord=ord+1 where (ord > 136000);
 
>> Fix:
suopanki> no fix

The above problem is described in the BUGS section in the MySQL manual
and is fixed in MySQL 3.23.

The query will continue forever, but the thread can be killed nicely
with 'mysqladmin kill'

Regards,
Monty
Thread
update bugsuopanki11 Apr
  • update bugMichael Widenius11 Apr