Bug #23826 Lost Connection when running MyISAM and InnoDB simultaneously
Submitted: 1 Nov 2006 0:40 Modified: 1 Dec 2006 12:30
Reporter: Cozta Norhalim Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.16-nt OS:Windows (Windows Server 2000/XP)
Assigned to: CPU Architecture:Any
Tags: innodb, Lost connection, myisam

[1 Nov 2006 0:40] Cozta Norhalim
Description:
Previously I was only using MyISAM database on my Windows Server 2000 & XP for my .NET applications. That worked fine. Now, I've a couple of databases running on InnoDB as well on the same server. But then, I start getting this "Lost connection to MySQL server during query" error. It ONLY occurs to my .NET application with MyISAM database. Not one of my applications with InnoDB gives this error.

How to repeat:
Run .NET applications that use both MyISAM and InnoDB databases on Windows Server 2000 or XP with multiple users/connections. Initially it'll work fine, but after many connections, it'll start to give the "Lost connection to MySQL server during query" error.
[1 Nov 2006 12:30] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.27, and inform about the results. What version of Connecotr/Net do you use? Do you have anything strange in MySQL server's error log?
[15 Nov 2006 18:17] [ name withheld ]
MySQL - 5.0.22-standard-log
under some usage (near 3 queries per second) continually but not always 
get error in mysql_connect (or mysql_pconnect) function

#/*--------20:45 xxx.xxx.xxx.xxx /get.db.php?id=28863------*/
fatal error: connect to DB failed: Lost connection to MySQL server during query 
#/*--------20:45 xxx.xxx.xxx.xxx /get.db.php?id=33419------*/
fatal error: connect to DB failed: Lost connection to MySQL server during query 
#/*--------20:45 xxx.xxx.xxx.xxx /get.db.php?id=35393------*/
fatal error: connect to DB failed: Lost connection to MySQL server during query 
#/*--------20:45 xxx.xxx.xxx.xxx /get.db.php?id=24381------*/
fatal error: connect to DB failed: Lost connection to MySQL server during query

and so on....
enviro?ment:
PHP 5.1.4
Mysql 5.0.22-standard-log
Apache 1.3
--------------------------------
[root@ mysql]# cat mysql.err
061112 17:18:58 mysqld started
061112 17:18:59 InnoDB: Started; log sequence number 0 62264247
061112 17:18:59 [Note] /usr/local/src/mysql/bin/mysqld: ready for connections.
Version: '5.0.22-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Edition - Standard (GPL)

 show variables like '%timeout%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| connect_timeout          | 5     |
| delayed_insert_timeout   | 300   |
| innodb_lock_wait_timeout | 50    |
| interactive_timeout      | 28800 |
| net_read_timeout         | 300   |
| net_write_timeout        | 600   |
| slave_net_timeout        | 3600  |
| table_lock_wait_timeout  | 50    |
| wait_timeout             | 28800 |
+--------------------------+-------+
9 rows in set (0.00 sec)
[2 Dec 2006 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".