Hi!
On Jul 20, kgeorge@stripped wrote:
> ChangeSet@stripped, 2007-07-20 14:17:15+03:00, gkodinov@stripped +4 -0
> Bug #29644: alter table hangs if records locked in share mode
> by long running transaction
>
> On Windows opened files can't be deleted. There was a special
> upgraded lock mode (TL_WRITE instead of TL_WRITE_ALLOW_READ)
> in ALTER TABLE to make sure nobody has the table opened
> when deleting the old table in ALTER TABLE. This special mode
> was causing ALTER TABLE to hang waiting on a lock inside InnoDB.
> This special lock is no longer necessary as the server is
> closing the tables it needs to delete in ALTER TABLE.
> Fixed by removing the special lock.
> Note that this also reverses the fix for bug 17264 that deals with
> another consequence of this special lock mode being used.
ok to push
Regards / Mit vielen Grüssen,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ Principal Software Developer
/_/ /_/\_, /___/\___\_\___/ MySQL GmbH, Radlkoferstr. 2, D-81373 München
<___/ Geschäftsführer: Kaj Arnö - HRB
München 162140
