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 |
+------------------------------------------------------------------+
