Bug #55741 [Asn->Fbk]: Warning thrown

Edit report at https://bugs.php.net/bug.php?id=55741&edit=1 ID: 55741 Updated by: andrey@php.net Reported by: patrick_adrichem at hotmail dot com Summary: Warning thrown -Status: Assigned +Status: Feedback Type: Bug Package: MySQL related Operating System: linux PHP Version: 5.3SVN-2011-09-20 (SVN) Assigned To: uw Block user comment: N Private report: N New Comment: Hi, I wasn't able to reproduce with 5.3-svn and two builds: - mysqlnd - libmysql Here is my mysqlnd output: $ ./php -r 'error_reporting(E_ALL);$c=mysql_connect("127.0.0.1","root","root");var_dump($c);var_dump(mysql_query("set @@wait_timeout=5",$c));sleep(7);var_dump(mysql_ping($c));' resource(6) of type (mysql link) bool(true) Warning: mysql_ping(): MySQL server has gone away in Command line code on line 1 bool(false) Here is my libmysql output: $ ./php -r 'error_reporting(E_ALL);$c=mysql_connect("127.0.0.1","root","root");var_dump($c);var_dump(mysql_query("set @@wait_timeout=5",$c));sleep(7);var_dump(mysql_ping($c));' resource(4) of type (mysql link) bool(true) bool(false) I suspect how it could be shut up, but I can't reproduce it to be able to test it. Previous Comments: ------------------------------------------------------------------------ [2011-09-20 14:50:21] laruence@php.net ulf, plz look at this. ------------------------------------------------------------------------ [2011-09-20 14:47:19] patrick_adrichem at hotmail dot com Description: ------------ --- From manual page: http://www.php.net/function.mysql-ping#refsect1-function.mysql-ping-description --- Mysql_ping is in my vision used to check wether your connection is still alive, by pinging the server since PHP 5.0.38 this function no longer autoreconnects, so its a real "Check if connection is alive" function. However if the connection is not alive it still throws a warning: mysql_ping(): 8 is not a valid MySQL-Link resource Which is obvious, because thats why you use this function... Test script: --------------- <?php error_reporting(E_ALL); $rConnection = mysql_connect("host", "user", "pass") or die("Could not connect"); sleep(60); if (false === mysql_ping($rConnection)) { echo "Connection gone"; } else { echo "Connection alive"; } Expected result: ---------------- Connection gone Actual result: -------------- mysql_ping(): 8 is not a valid MySQL-Link resource Connection gone ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=55741&edit=1