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: | |
| 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
[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".
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.