Bug #52561 [Com]: function mysqli_ping no attempted reconnection!

Edit report at https://bugs.php.net/bug.php?id=52561&edit=1 ID: 52561 Comment by: jay at grooveshark dot com Reported by: paulgao at yeah dot net Summary: function mysqli_ping no attempted reconnection! Status: Wont fix Type: Bug Package: MySQL related Operating System: irrelevant PHP Version: 5.3.3 Assigned To: mysql Block user comment: N Private report: N New Comment: This caused problems for us trying to upgrade. Why is ping/reconnect considered dangerous? It has been working fine for us problem free for years. Previous Comments: ------------------------------------------------------------------------ [2010-08-18 12:23:29] andrey@php.net You are using mysqlnd and it doesn't reconnect. It has no such capability by design. reconnect is off by default since ages and is considered dangerous. Thus, reconnect wasn't implemented in mysqlnd. Ergo, mysqli.reconnect has no meaning. You can either stay with libmysql, which however is not recommended in the long run. Or change your code so you reconnect explicitly. ------------------------------------------------------------------------ [2010-08-14 19:28:48] paulgao at yeah dot net when i use libmysql, sleep 31s+, mysqli_ping() is work, it can reconnection. ------------------------------------------------------------------------ [2010-08-14 18:41:12] kalle@php.net Does this happen with libmysql aswell? ------------------------------------------------------------------------ [2010-08-07 13:41:12] paulgao at yeah dot net and mysql server version 5.1.49. ------------------------------------------------------------------------ [2010-08-07 13:32:26] paulgao at yeah dot net Description: ------------ I use mysqli_ping reconnection database when php script long time run. when my use mysqlnd module, mysqli_ping() is run fail, errormsg is "MySQL server has gone away". mysqli.reconnect setting is ON. mysql server timeout is 30s. Test script: --------------- <?php mysqli = new mysqli("localhost", "xxx", "xxx"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } sleep(31); /* check if server is alive */ if ($mysqli->ping()) { printf ("Our connection is ok!\n"); } else { printf ("Error: %s\n", $mysqli->error); } /* close connection */ $mysqli->close(); ?> Expected result: ---------------- Our connection is ok! Actual result: -------------- Error: MySQL server has gone away ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=52561&edit=1