summaryrefslogtreecommitdiff
path: root/ext/mysql
diff options
context:
space:
mode:
authorUlf Wendel <uw@php.net>2011-09-01 15:25:15 (GMT)
committerUlf Wendel <uw@php.net>2011-09-01 15:25:15 (GMT)
commit9996f5f13f65a03c610c1522979bd73f610928f0 (patch)
tree2b1b4e9e814fa0ae348c8909df925b71220b981c /ext/mysql
parent781db10c48ae2184d3c3880eed74e38baeb20545 (diff)
downloadphp-9996f5f13f65a03c610c1522979bd73f610928f0.tar.gz
Can't reproduce the server has gone away messages, Andrey. Please, have a look. I tried MySQL 5.1, 5.5 and 5.6.
Diffstat (limited to 'ext/mysql')
-rw-r--r--ext/mysql/tests/bug55473.phpt55
1 files changed, 29 insertions, 26 deletions
diff --git a/ext/mysql/tests/bug55473.phpt b/ext/mysql/tests/bug55473.phpt
index 3a145fd..df584bd 100644
--- a/ext/mysql/tests/bug55473.phpt
+++ b/ext/mysql/tests/bug55473.phpt
@@ -7,6 +7,9 @@ require_once('skipifconnectfailure.inc');
if (defined('PHP_WINDOWS_VERSION_MAJOR')) {
die("skip Test doesn't work on Windows");
}
+
+if (!($output = @exec("lsof -np " . getmypid())))
+ die("skip Test can't find command line tool lsof");
?>
--INI--
mysql.max_persistent=30
@@ -25,52 +28,52 @@ mysql.allow_persistent=1
function connect($host, $user, $passwd) {
$conn = mysql_pconnect($host, $user, $passwd);
+
if (!$conn)
- die(mysql_error()."\n");
- mysql_query("set wait_timeout=1", $conn);
+ die(sprintf("[001] %s\n", mysql_error()));
+
+ if (!mysql_query("set wait_timeout=1", $conn))
+ printf("[002] [%d] %s\n", mysql_errno($conn), mysql_error($conn));
+
return $conn;
}
$conn = connect($host, $user, $passwd);
$opened_files = -1;
- for($i = 0; $i < 4; $i++) {
+
+ for ($i = 0; $i < 4; $i++) {
/* wait while mysql closes connection */
sleep(3);
if (!mysql_ping($conn)) {
- echo "reconnect\n";
- $conn = connect($host, $user, $passwd);
+ printf("[003] reconnect %d\n", $i);
+ $conn = connect($host, $user, $passwd);
}
$r = mysql_query('select 1', $conn);
- $error = $r ? 'OK' : mysql_error();
+ if (!$r)
+ printf("[004] [%d] %s\n", mysql_errno($conn), mysql_error($conn));
+
+
if ($opened_files == -1) {
$opened_files = trim(exec("lsof -np " . getmypid() . " | wc -l"));
- echo "OK\n";
+ printf("[005] Setting openened files...\n");
} else if (($tmp = trim(exec("lsof -np " . getmypid() . " | wc -l"))) != $opened_files) {
- printf("[01] [%d] different number of opened_files : expected %d, got %d", $i, $opened_files, $tmp);
+ printf("[006] [%d] different number of opened_files : expected %d, got %d", $i, $opened_files, $tmp);
} else {
- echo "OK\n";
+ printf("[007] Opened files as expected\n");
}
}
-
print "done!";
?>
--EXPECTF--
-Warning: mysql_ping(): MySQL server has gone away in %s on line %d
-reconnect
-OK
-
-Warning: mysql_ping(): MySQL server has gone away in %s on line %d
-reconnect
-OK
-
-Warning: mysql_ping(): MySQL server has gone away in %s on line %d
-reconnect
-OK
-
-Warning: mysql_ping(): MySQL server has gone away in %s on line %d
-reconnect
-OK
-done!
+[003] reconnect 0
+[005] Setting openened files...
+[003] reconnect 1
+[007] Opened files as expected
+[003] reconnect 2
+[007] Opened files as expected
+[003] reconnect 3
+[007] Opened files as expected
+done! \ No newline at end of file