ID: 49436 Updated by: j...@php.net Reported By: november at netsecuretech dot com -Status: Open +Status: Bogus Bug Type: MySQLi related Operating System: windowsXP PHP Version: 5.3.0 New Comment:
See also bug #49511 (it also has good analysis of the issue, closing this in favor of that) Previous Comments: ------------------------------------------------------------------------ [2009-09-04 01:17:27] november at netsecuretech dot com I think this problem isn't related to mysql error. I modifyed php.ini. Before : default_socket_timeout = 0 After : default_socket_timeout = -1 I execute php script. Php script was processed successed. Default_socket_timeout influence mysqli connection? I tested below script. If default_socket_timeout is -1, script isn't ended. I think mysqli connection timeout and socket timeout managed separated. thank you. <?php echo 'PHP ' . phpversion() . "\n\n"; echo date('H:i:s ')."Start script\n"; ini_set('default_socket_timeout', 60); echo 'max_execution_time: ' . ini_get('max_execution_time') . "\n"; echo 'default_socket_timeout: ' . ini_get('default_socket_timeout') . "\n"; $mysqli = new mysqli('localhost', 'does', 'not', 'matter', 1); if ($mysqli->connect_error) { echo "GOOD CATCH\n"; } echo date('H:i:s ')."End script\n\n"; echo date('H:i:s ')."Start script\n"; ini_set('default_socket_timeout', -1); echo 'max_execution_time: ' . ini_get('max_execution_time') . "\n"; echo 'default_socket_timeout: ' . ini_get('default_socket_timeout') . "\n"; $mysqli = new mysqli('localhost', 'does', 'not', 'matter', 1); if ($mysqli->connect_error) { echo "GOOD CATCH\n"; } echo date('H:i:s ')."End script\n\n"; ?> ------------------------------------------------------------------------ [2009-09-03 12:38:30] j...@php.net Did you check the mysql server error log if it has any clues what happened? ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/49436 -- Edit this bug report at http://bugs.php.net/?id=49436&edit=1