ID: 49436 Updated by: j...@php.net Reported By: november at netsecuretech dot com -Status: Open +Status: Feedback Bug Type: MySQLi related Operating System: windowsXP PHP Version: 5.3.0 New Comment:
Did you check the mysql server error log if it has any clues what happened? Previous Comments: ------------------------------------------------------------------------ [2009-09-02 10:07:21] november at netsecuretech dot com I installed VC9 x86 Thread Safe (2009-Sep-02 11:00:00) verion. It is not work well. result is below... thank you. -------------------------------------------- C:\php\Script>..\php.exe mysqli_test.php 2009-09-02 19:03:27 => query start... 2006 MySQL server has gone away 2009-09-02 19:04:27 => query end... C:\php\Script> ------------------------------------------------------------------------ [2009-09-02 09:41:45] j...@php.net Please try using this snapshot: http://snaps.php.net/php5.3-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ------------------------------------------------------------------------ [2009-09-02 04:40:26] november at netsecuretech dot com mysql query takes 20~30 minutes; $query = "create table test as select c_ip, count(*) from iis_summary group by c_ip"; thank you ------------------------------------------------------------------------ [2009-09-02 04:37:23] november at netsecuretech dot com 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 this bug report at http://bugs.php.net/?id=49436&edit=1