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

ID: 36602 User updated by: nerve at gmx dot net Reported By: nerve at gmx dot net Status: Open Bug Type: PDO related Operating System: Gentoo Linux PHP Version: 5.1.2 New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2006-03-04 09:42:24] nerve at gmx dot net That's right, after installing the new mysql i havent testet it. But what to do ? I can't explicitli close the persistent connections until apache is restartet. Same problem happen if mysql timeout is reached. Can we make a solution for the php user how don't want to programm a workaround to normal connections ? (Transparent solution in php source code ? ) Thank's for your help. ------------------------------------------------------------------------ [2006-03-03 15:32:53] georg@php.net Libmysql client library doesn't allow reconnect by default since version 5.0.3 (Also mysql_pconnect shouldn't work after restarting MySQL server). ------------------------------------------------------------------------ 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