ID: 46740 Comment by: dstuff at brainsware dot org Reported By: php at matthewboehm dot com Status: Open Bug Type: PDO related Operating System: RHEL5.2 PHP Version: 5.2.6 New Comment:
Got the same problem using PHP version 5.2.9 on Debian (Lenny) Previous Comments: ------------------------------------------------------------------------ [2008-12-03 15:45:59] php at matthewboehm dot com Description: ------------ When using PHP/MySQL with persistent connections, upon the death of an apache child, you get an 'aborted connection' message inside the MySQL server's error log. In my supremely most humbled opinion, I can only presume that PHP is not cleanly closing opened MySQL connections when an apache child dies and the PHP module is unloaded from apache's memory. Reproduce code: --------------- To reproduce: 1. Start httpd (I used 2.2.10) with PHP 5.2.6. httpd should use the prefork MPM with the following settings on the MPM: StartServers 5 MinSpareServers 5 MaxSpareServers 10 MaxRequestsPerChild 1000 2. Browser the following PHP file several times to initiate several persistent connections to your MySQL database. This can be either of the MySQL methods that support persistence. (mysql_pconnect, and PDO) <?php try { $dbh = new PDO('mysql:host=DBHOST;dbname=DBNAME', 'DBUSER', 'DBPASS', array(PDO::ATTR_PERSISTENT => true, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)); if($res = $dbh->query("SELECT * FROM myTable")) { print "Query success"; } else { print "Query failed"; } } catch(PDOException $e) { echo 'Error: ' . $e->getMessage(); } 3. Stop apache via any means. You will see in your MySQL log 1 aborted connection line for each terminated apache process. In my testing, I used 'ab' to throw 10,000 requests of the above code at apache. Every 1000 requests, I would see the error in MySQL. This is because of the MaxRequestsPerChild setting to be 1000. Every 1000, an apache thread will suicide and then spawn a new thread. Once the load test was complete, if more than MaxSpareServers threads where running, apache would kill them off as well and you would see that same number of errors in MySQL. Expected result: ---------------- I would not expect to see any errors from MySQL. I would expect all connections to be properly closed upon the death of an apache process. Actual result: -------------- The actual result is an incorrectly closed MySQL connection. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=46740&edit=1