Re: queries getting stuck in "Opening table" state

Hi!

This is this bug:

http://bugs.mysql.com/bug.php?id=12071

in the MS Visual C++ runtime library. A workaround appeared on Friday in 
MySQL-5.0.18, and will also be in 4.1.17.

Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables
http://www.innodb.com/order.php


.....................
I'm having problems on several similarly-configured Windows Server
2003 servers using various revisions of MySQL 4.1. Several times a
day, a query will get stuck, and MySQL is basically useless until it
is restarted. I can't shutdown mysqld-nt.exe with "mysqladmin
shutdown" (it doesn't give me any errors, it just doesn't shut it
down) or with "net stop mysql." I have to kill it with Task Manager.
Until I do this, MySQL generally accepts incoming connections, but
queries just get stuck, and the process list grows and grows.

Very often, but not always, the query that gets stuck is "SHOW TABLE
STATUS FROM ..." or "SHOW FULL COLUMNS FROM ..." This could be
coincidental, though, since phpMyAdmin generates quite a few queries
like this.

This is a production web server which serves many customers, so there
are lots of different applications accessing MySQL, including PHP,
ColdFusion, and .NET.

I would consider upgrading to MySQL 5 if these issues have been
resolved, but I'm still concerned about incompatibilities for our
customers.

Thanks in advance. 


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]