#26490 [Csd->Fbk]: Lost connection to MySQL server during query

ID: 26490 Updated by: theseer@php.net Reported By: chris dot noden at monstermob dot com -Status: Closed +Status: Feedback Bug Type: MySQL related Operating System: * PHP Version: 4CVS, 5CVS (2004-03-13) New Comment: Due to people claiming the "workaround" doesn't fix their problems, the bug is reopened. Please provide detailed feedback on how to reproduce the problem. Previous Comments: ------------------------------------------------------------------------ [2004-09-22 21:06:23] tru at gtwreck dot com 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 ------------------------------------------------------------------------ [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] theseer@php.net 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. ------------------------------------------------------------------------ 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