Hi, we are running a MySQL 4.1.7 database on a Windows Server 2003 configured as "server machine" with "transactional databases only" and "decision support".
With this server we are experiencing troubles with old clients (MySQL Control Center 0.94 and ByteFX .NET Provider 0.76) when running a select statement with 2 sub-selects, converts and some joins. With this special statement, the connection thread nearly always hangs and is showing "Sending data" in the state field of the MySQL Administrator. Killing the thread with the Administrator is not working. Canceling the thread is only possible by killing mysql in the taskmanager and restart the service. The same statement executed over MyODBC 3.51.10 and Query Browser 1.1.1 is always working. I'm not sure if this is also related to crashes of mysql we are experiencing: The mysqld-nt version always crashed when some threads were hanging. Later I switched to mysqld-debug, which seems to be more stable with the hanging threads and only crashed once until now. I've tried to add the debug log, but I'm not able because of a mailinglist size-limit. Is this a known bug or should I submit this at bugs.mysql.com? Regards, Klaus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]