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

Reply via email to