#26490 [Com]: Lost connection to MySQL server during query

ID: 26490 Comment by: ruslan at routec dot net Reported By: chris dot noden at monstermob dot com Status: No Feedback Bug Type: MySQL related Operating System: * PHP Version: 4CVS, 5CVS (2004-03-13) New Comment: I'm too have this problem when connect to LAN Mysql server(not localhost). "Lost connection to MySQL server during query". OS FreeBSD 4.9 MySQL 3.23.58 Previous Comments: ------------------------------------------------------------------------ [2004-10-01 01:00:02] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, 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". ------------------------------------------------------------------------ [2004-09-23 12:05:07] theseer@php.net 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. ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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