From: november at netsecuretech dot com Operating system: windowsXP PHP version: 5.3.0 PHP Bug Type: MySQLi related Bug description: during query executed, mysql connection lost
Description: ------------ PHP version : 5.3.0 Windows Binary VC9 x86 Thread Safe (2009-Jun-30 08:52:56) Mysql version : 5.1.37-community-edition (CentOS 4.7) I use php CLI SAPI. PHP cli's default max_execution_time is unlimited. When I execute php script, mysql connection is lost. When I use php 5.2.10, mysql query executed well. What Can I do? Thank you. Reproduce code: --------------- <?php $db = mysqli_connect('x.x.x.x', 'id', 'pw', 'db'); if (!$db) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } echo date("Y-m-d H:i:s")." => query start...\r\n"; $query = "create table test as select c_ip, count(*) from iis_summary group by c_ip"; mysqli_query($db, $query); if (mysqli_errno($db) != 0) { echo mysqli_errno($db)." ".mysqli_error($db)."\r\n"; } echo date("Y-m-d H:i:s")." => query end...\r\n"; mysqli_close($db); ?> Expected result: ---------------- During query, mysql connection lost. PHP Warning: mysqli_query(): MySQL server has gone away in C:\php\Script\mysqli _test.php on line 14 Actual result: -------------- C:\php\Script>..\php.exe mysqli_test.php 2009-09-02 13:23:15 => query start... PHP Warning: mysqli_query(): MySQL server has gone away in C:\php\Script\mysqli _test.php on line 14 PHP Warning: mysqli_query(): Error reading result set's header in C:\php\Script \mysqli_test.php on line 14 2006 MySQL server has gone away 2009-09-02 13:24:15 => query end... C:\php\Script> -- Edit bug report at http://bugs.php.net/?id=49436&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=49436&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=49436&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=49436&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=49436&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=49436&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=49436&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=49436&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=49436&r=needscript Try newer version: http://bugs.php.net/fix.php?id=49436&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=49436&r=support Expected behavior: http://bugs.php.net/fix.php?id=49436&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=49436&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=49436&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=49436&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=49436&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=49436&r=dst IIS Stability: http://bugs.php.net/fix.php?id=49436&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=49436&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=49436&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=49436&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=49436&r=mysqlcfg