List:Bugs« Previous MessageNext Message »
From:sasha Date:May 18 2000 10:53pm
Subject:Re: Repeatable mysql 'update' bug - lockup / cpu drain.
View as plain text  
Sander Pilon wrote:
> 
> Summary:
> 
> Repeatable mysql bug where mysql is looping, eating CPU resources.
> 
> More detail:
> 
> I'm inserting / updating a table (layout below) in PHP. The 'update' goes
> wrong.
> 
> The query: " UPDATE comment_headers SET thread_id = thread_id +1 WHERE
> (root_id = 2) AND (thread_id > 12) "
> keeps looping, keeps incrementing 'thread_id' in the same row over and over
> again. The result is a lockup,
> and upon inspection of the table an extremely large value of 'thread_id'.
> 
> (A value of 428503 where I expected a value of 14)
> 
> Anyone got a workaround, or perhaps a quick patch?
> 
> (Yes, I know I run 2 versions behind the latest Mysql, but changelog didnt
> specify a fixed bug in this area.
> And yes, I tried mysqlbug, but it gave me trouble. )
> 
> Regards,

This is a known problem inherent to 3.22 version and it is documented. Trying to
fix it would require major source modifications and could introduce new bugs,
which is the reason we've fixed it only in 3.23.

-- 
Sasha Pachev

+------------------------------------------------------------------+
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sasha@stripped  |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
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