On Thu, Oct 17, 2002 at 05:47:02PM +0200, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text of it in the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. Just typing the word MySQL once will be sufficient, for example.
>
> You have written the following:
>
> I've come across some weird behavior with active table locks
> and flushing privileges - is this a bug?
>
> If you lock any table using "LOCK TABLES test.locktest READ" and later
> issue a "FLUSH PRIVILEGES" in the same client, then the lock is released.
>
> If you use "FLUSH TABLES WITH READ LOCK" problem does not occur.
>
> I have tested this in 3.23.47 and 3.23.52 on FreeBSD4.6
>
> TEST:
>
> CREATE DATABASE test;
> USE test;
> CREATE TABLE locktest ( foo VARCHAR(50) );
>
> 1. Client a:
> USE test
> LOCK TABLES locktest READ;
>
> 2. Client b:
> USE test
> INSERT locktest VALUES ("lock_damn_it");
> ......Client b waits........
>
> 3. Client a:
> FLUSH PRIVILEGES
>
> client b:
> .....Client b insert in processed
>
> Regards,
> Donal
>
> --
> ************************************************
> Donal Diamond
> Technical Planning & Support
> Eircom Multimedia Infrastructure
> ************************************************
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
