Re: bk commit into 5.0 tree (davi:1.2508) BUG#28587

[Konstantin Osipov]

* Davi Arnaut <davi@stripped> [07/08/30 21:58]:
> ChangeSet@stripped, 2007-08-30 14:53:17-03:00, davi@stripped +3 -0
>   Bug#28587 SELECT is blocked by INSERT waiting on read lock, even with
> low_priority_updates
>   

OK to push.
Please push the test case into 5.1 only, and use wait_condition
instead of sleep, as agreed on IRC.

>   The problem is that a SELECT on one thread is blocked by INSERT ... ON
>   DUPLICATE KEY UPDATE on another thread even when low_priority_updates is
>   activated.
>   
>   The solution is to possibly downgrade the lock type to the setting of
>   low_priority_updates if the INSERT cannot be concurrent.
> 

-- 
-- Konstantin Osipov              Software Developer, Moscow, Russia
-- MySQL AB, www.mysql.com   The best DATABASE COMPANY in the GALAXY