RE: queries getting stuck in "Opening table" state
"Appeltans David" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
Hi, I can confirm that the bug is still there in the version: mysqladmin Ver 8.41 Distrib 5.0.17, for Win32 on ia32. I'm using a Perl script which does a "show columns FROM table"-query and from time to time, the MySQL server hangs. Only a reboot helps. David -----Original Message----- From: Heikki Tuuri [mailto:[email protected]] Sent: 01 January 2006 15:28 To: [email protected] Subject: 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] -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]