>>>>> "web" == web <web@stripped> writes:
>> Description:
web> The following (simplified from the real case) sequence causes FLUSH TABLES to take
> forever:
web> In thread 1:
web> LOCK TABLE a (READ|WRITE it doesn't matter)
web> FLUSH TABLES
web> isamchk a
web> FLUSH TABLES
web> UNLOCK TABLES
web> Simultaneously in thread 2:
web> SELECT * from a
web> mysqladmin proc output
web> | 250952 | web | localhost | | Query | 100 | Flushing tables |
> FLUSH TABLES
web> | 256010 | web | localhost | echelon | Query | 100 | Waiting for table |
> SELECT * FROM a
web> This is using the latest libc_r for FreeBSD.
Hi!
I think this is fixed in MySQL 3.22.27. Could you try it?
Regards,
Monty