php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #67087 slowlog kills mysql connection
Submitted: 2014-04-16 16:22 UTC Modified: -
Votes:1
Avg. Score:3.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:1 (100.0%)
From: k dot dolgopolov at ya dot ru Assigned:
Status: Open Package: FPM related
PHP Version: 5.4.27 OS: linux
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: k dot dolgopolov at ya dot ru
New email:
PHP Version: OS:

 

 [2014-04-16 16:22 UTC] 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


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2015-07-13 12:14 UTC] kbolyshev at gmail dot com
The same bug on PHP Version 5.5.9-1ubuntu4.5 (Ubuntu 14.04.1 LTS on Linode XEN).
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Nov 21 18:01:29 2024 UTC