Bug #67087 [NEW]: slowlog kills mysql connection

From: Date: Wed, 16 Apr 2014 16:22:54 +0000
Subject: Bug #67087 [NEW]: slowlog kills mysql connection
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-185269@lists.php.net to get a copy of this message
From: k dot dolgopolov at ya dot ru Operating system: linux PHP version: 5.4.27 Package: FPM related Bug Type: Bug Bug description:slowlog kills mysql connection Description: ------------ If mysql query is longer as request_slowlog_timeout, connection breaks. Test script: --------------- <?php // request_slowlog_timeout = 10s (at /etc/php5/fpm/php-fpm.conf) // $mysqli = // ... $query = "SELECT SLEEP (15)"; $res = $mysqli->query($query); if (!$res) { echo $mysqli->error; // Error Code: 2013. Lost connection to MySQL server during query exit; } Expected result: ---------------- connection must be preserved and the request should be executed -- Edit bug report at https://bugs.php.net/bug.php?id=67087&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=67087&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=67087&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=67087&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=67087&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=67087&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=67087&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=67087&r=needscript Try newer version: https://bugs.php.net/fix.php?id=67087&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=67087&r=support Expected behavior: https://bugs.php.net/fix.php?id=67087&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=67087&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=67087&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=67087&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=67087&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=67087&r=dst IIS Stability: https://bugs.php.net/fix.php?id=67087&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=67087&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=67087&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=67087&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=67087&r=mysqlcfg

« previous php.bugs (#185269) next »