Bug #61411 [Com]: PDO Segfaults with PERSISTENT == TRUE && EMULATE_PREPARES == FALSE

Edit report at https://bugs.php.net/bug.php?id=61411&edit=1 ID: 61411 Comment by: fundom02 at yahoo dot com Reported by: julien at palard dot fr Summary: PDO Segfaults with PERSISTENT == TRUE && EMULATE_PREPARES == FALSE Status: Re-Opened Type: Bug Package: PDO MySQL Operating System: Linux 2.6.32-5-amd64 PHP Version: 5.4.0 Assigned To: uw Block user comment: N Private report: N New Comment: Don, That's interesting. Have you tried my code with settings your MySQL timeout less than than the sleep? function create_connection(){ $options = array(PDO::ATTR_PERSISTENT => TRUE,PDO::ATTR_EMULATE_PREPARES => FALSE); return new PDO('mysql:host=127.0.0.1;dbname=trafficadbar;charset=utf8', 'root', 'wnn99BCc', $options); } $pdo = create_connection(); sleep(5); $pdo1 = create_connection(); $statement = $pdo1->prepare("SELECT count(*) from users"); $statement->execute(); foreach ($statement as $line) var_dump($line); Previous Comments: ------------------------------------------------------------------------ [2015-01-14 22:05:43] don at smugmug dot com We've been running with PERSISTENT = TRUE && EMULATE_PREPARES = FALSE on our testbed since December 23rd, with no segfaults or any other problems with connections, including the ones described by Fundom02. We'll likely push this change to production shortly. ------------------------------------------------------------------------ [2015-01-14 18:24:50] Fundom02 at yahoo dot com I get an error, caused by php returning a cached connection that's expired. If you run my code you will see the problem. ------------------------------------------------------------------------ [2015-01-14 18:17:23] mike@php.net Are you experiencing a crash? ------------------------------------------------------------------------ [2015-01-13 11:31:04] fundom02 at yahoo dot com Any news on this? ------------------------------------------------------------------------ [2014-12-26 18:52:16] Fundom02 at yahoo dot com This is a bug. $pdo creates a new connection. 2 seconds later MySQL closes that connection. 3 seconds later $pdo1 requests a completely new connection which is instantly reported as lost connection. I believe that php-pdo is caching all connections and not checking if cached connections are closed. If this weren't the case then $pdo1 would successfully create a new connection. ------------------------------------------------------------------------ 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 https://bugs.php.net/bug.php?id=61411 -- Edit this bug report at https://bugs.php.net/bug.php?id=61411&edit=1