ID: 26490 Comment by: tru at gtwreck dot com Reported By: chris dot noden at monstermob dot com Status: Closed Bug Type: MySQL related Operating System: * PHP Version: 4CVS, 5CVS (2004-03-13) New Comment:
All you need to do is check out this query on google, and you can see that a lot of sites have this issue while google is indexing them... http://www.google.com/search?hl=en&lr=&ie=UTF-8&q=%22Lost+connection+to+MySQL+server+during+query%22+mysql_connect Previous Comments: ------------------------------------------------------------------------ [2004-09-22 21:03:00] tommy at allstardirectories dot com The suggested work-around does not work for me. I'm still seeing intermittent connection losses (About 5-10 per day). ------------------------------------------------------------------------ [2004-08-12 19:20:53] [EMAIL PROTECTED] This is not a bug at all but rather a problem created by the reuse of connections within php: The mysql_connect() command does NOT open a new connection by default. So even if one calls mysql_connect() in the forked child, no new conenction is opened. Adding the addtional parameter to force a new connection fixes the problem right away. ------------------------------------------------------------------------ [2004-08-10 17:11:12] christian at jul dot net Happened for me on php 4.3.8 / mysql 4.0.20 / debian unstable Seems like putting the db connection after the fork solved the problem. Apparently the connection dies when the connecting process exits, but should be kept alive as long as there is living child processes. ------------------------------------------------------------------------ [2004-08-03 07:27:29] adams at mars-project dot com I also get this error, but its on an internal mysql server. PHP 4.3.7 MySQL 4.0.18 FreeBSD 4.10 And just to note when i do get this error i get a php core dump as well. ------------------------------------------------------------------------ [2004-07-21 17:20:59] florian dot heigl at m4f dot net I got the same error w/o using php - connecting via bin/mysql... It only happens *sometimes* :) ERROR 2013 at line 78: Lost connection to MySQL server during query OS is Tru64 5.1B-4, MySQL 4.0.20 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/26490 -- Edit this bug report at http://bugs.php.net/?id=26490&edit=1
