List:Bugs« Previous MessageNext Message »
From:Michael Widenius Date:May 22 2000 11:49am
Subject:RE: Repeatable mysql 'update' bug - lockup / cpu drain.
View as plain text  
Hi!

>>>>> "Sander" == Sander Pilon <sander@stripped> writes:

>> 
>> I can verify that this causes an error in 3.22.29, but it works
>> just fine with
>> 3.23.16.
>> 
>> So does this warrant a new release of 3.22, or is the solution
>> to upgrade to 3.23 even though it isnt a fully stable system?
>> 
>> I havent had any problems with 3.23.16, and as has been said on this list
>> before, it is equally or more stable than 3.22 for anything that
>> 3.22 did, but
>> maybe not production level on all new features (such as BDB transactions,
>> binary replication etc).
>> 
>> SELECT 3-22.feature,3-22.stability,3-23.stability
>> FROM 3-22
>> LEFT JOIN 3-23
>> ON 3-22.feature = 3-23.feature;
>> 
>> Dana
>> 

Sander> IMO, a 3.22 patch should be released. Why? 3.22 is marketed as 'stable'
Sander> release and
Sander> contains reproducable lockups. These things do not belong in 'stable'
Sander> releases :)

Sander> So... you are saying that 3.32.16 is as stable as 3.22.32, as long as I dont
Sander> use any of the new
Sander> tricks?

Sasha has already answer quite extensively to this problem.

I just wanted to add that this problem + a workaround for 3.22 is
described in the MySQL manual, in the appendix 'Known errors and
design deficiencies in MySQL'.  The reason for not updating MySQL 3.22
with the code that fixes this in 3.23 is that the fix was not trivial
and we don't want to add that much new code into 3.22 as it could make
this release less stable.

Basicly 3.23.x seams to be quite reliable now (except when it comes to
BDB and replication, which will need a few weeks to stabilize) and
it should be usable in production systems.  We will release 3.22.17
later this week (which should fix most of the problems with the BDB
interface) and if this works ok we will release 3.23.18 next week as
beta as an indication that we believe it's reasonable stable :)

Regards,
Monty
Thread
Repeatable mysql 'update' bug - lockup / cpu drain.Sander Pilon18 May
  • Re: Repeatable mysql 'update' bug - lockup / cpu drain.Dana Powers18 May
    • RE: Repeatable mysql 'update' bug - lockup / cpu drain.Sander Pilon18 May
      • Re: Repeatable mysql 'update' bug - lockup / cpu drain.Thimble Smith19 May
      • Re: Repeatable mysql 'update' bug - lockup / cpu drain.sasha19 May
      • RE: Repeatable mysql 'update' bug - lockup / cpu drain.Michael Widenius22 May
  • Re: Repeatable mysql 'update' bug - lockup / cpu drain.sasha19 May
  • Re: Repeatable mysql 'update' bug - lockup / cpu drain.sasha19 May
    • RE: Repeatable mysql 'update' bug - lockup / cpu drain.Sander Pilon19 May
RE: Repeatable mysql 'update' bug - lockup / cpu drain.Sander Pilon18 May