ID: 26490
Updated by: php-bugs@lists.php.net
Reported By: chris dot noden at monstermob dot com
-Status: Feedback
+Status: No Feedback
Bug Type: MySQL related
Operating System: *
PHP Version: 4CVS, 5CVS (2004-03-13)
New Comment:
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".
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
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