#36602 [Opn->Csd]: "MySQL server has gone away" with PDO::ATTR_PERSISTENT => true

From: Date: Sun, 09 Apr 2006 08:12:37 +0000
Subject: #36602 [Opn->Csd]: "MySQL server has gone away" with PDO::ATTR_PERSISTENT => true
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-95485@lists.php.net to get a copy of this message 
 ID:               36602
 Updated by:       wez@php.net
 Reported By:      nerve at gmx dot net
-Status:           Open
+Status:           Closed
 Bug Type:         PDO related
 Operating System: Gentoo Linux
 PHP Version:      5.1.2
 New Comment:

Fixed in CVS.


Previous Comments:
------------------------------------------------------------------------

[2006-03-13 15:47:31] damien dot harper at gmail dot com

I'm running a debian box dual Xeon 2 gigs of RAM and powering Apache
2.2.0, PHP 5.1.2, MySQL 5.0.18, PDO_mysql 5.0.18 and getting the same
issues.

It would be really nice to be able to set the persistent connections
lifetime.

Otherwise, PDO should be smart enough to autodetect dead connections
and avoid to return them.

------------------------------------------------------------------------

[2006-03-08 15:54:03] nerve at gmx dot net

Or an other idea, how about the posibility to specify a time after
which the persistent connection is closed ? (Aka timeout).

I want beleve that mysql is the only pdo backend 
with useles persistent connections.

I (and every other ho is using persistent connections for a big or
important aplication) thank you for a good solution.

Daniel Heule

------------------------------------------------------------------------

[2006-03-08 15:48:27] nerve at gmx dot net

And what is abaut a new method 
to destroy the death persistent object ?
So every user can destroy it and recreate the persistent connection
without restarting the webserver ?

Not all php users have the choise to restart the webserver if a
persistent connection is going to hell ?

Thank you
Daniel

------------------------------------------------------------------------

[2006-03-04 23:56:31] nerve at gmx dot net

Thank you for your good help ;-(,
clearly it's in the docu,
but in this case persistent connections are useles ;-(

------------------------------------------------------------------------

[2006-03-04 22:04:38] georg@php.net

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to
report
a bug at http://bugs.php.net/how-to-report.php

As this is documented clearly in mysql documentation -> bogus.

------------------------------------------------------------------------

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/36602

-- 
Edit this bug report at http://bugs.php.net/?id=36602&edit=1

Thread (11 messages)

« previous php.bugs (#95485) next »