#37319 [Com]: "MySQL server has gone away", with PDO::ATTR_PERSISTENT => true

ID: 37319 Comment by: arsukdeo at technocorp dot com Reported By: j8859 at clix dot pt Status: No Feedback Bug Type: PDO related Operating System: Linux Slackware 10.2 PHP Version: 5.1.3 Assigned To: wez New Comment: Sep 03, 2008: This problem might not be specific to a given version of linux, but with respect to the nature of the web server handles processes with PDO. I have a client running: php 5.1.6 on centos (Linux -.-.- 2.6.18-92.1.6.el5 i686)with apache 2.0 and the "MySQL server has gone away" problem still occurs. Interestingly, I developed a core framework with the necessary db "access code" using PDO on XP with IIS and I did not see a problem until I tried to run the code on centos. The access code uses ATTR_PERSISTENT set to true. At the moment, I haven't found the triggering mechanism. The client's server was standalone and there was no load on it. In any case, this is a real problem that requires investigation and it should be fixed ASAP. Previous Comments: ------------------------------------------------------------------------ [2006-12-12 01:00:01] 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". ------------------------------------------------------------------------ [2006-12-04 15:12:36] iliaa@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip ------------------------------------------------------------------------ [2006-05-28 10:59:30] j8859 at clix dot pt After applying your suggestion, the problem didn't occur again. Anyway, I guess this should only be a temporary solution, isn't it? ------------------------------------------------------------------------ [2006-05-26 13:41:26] j8859 at clix dot pt Apparently the problem stopped occurring. I'll see what happens in the next days. Anyway, the solution you suggest -- $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); -- is it a temporary or a definitive one? ------------------------------------------------------------------------ [2006-05-24 22:27:14] wez@php.net Try following the tips here: http://netevil.org/node.php?uuid=444a6017-0548-2459-2943-44a601714d58 ------------------------------------------------------------------------ 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/37319 -- Edit this bug report at http://bugs.php.net/?id=37319&edit=1