Bug #67087 [Com]: slowlog kills mysql connection
| From: | kbolyshev at gmail dot com | Date: | Mon, 13 Jul 2015 12:14:38 +0000 |
| Subject: | Bug #67087 [Com]: slowlog kills mysql connection | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-194398@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=67087&edit=1
ID: 67087
Comment by: kbolyshev at gmail dot com
Reported by: k dot dolgopolov at ya dot ru
Summary: slowlog kills mysql connection
Status: Open
Type: Bug
Package: FPM related
Operating System: linux
PHP Version: 5.4.27
Block user comment: N
Private report: N
New Comment:
The same bug on PHP Version 5.5.9-1ubuntu4.5 (Ubuntu 14.04.1 LTS on Linode XEN).
Previous Comments:
------------------------------------------------------------------------
[2014-04-16 16:22:54] k dot dolgopolov at ya dot ru
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 this bug report at https://bugs.php.net/bug.php?id=67087&edit=1