#49436 [Fbk->Opn]: during query executed, mysql connection lost
ID: 49436
User updated by: november at netsecuretech dot com
Reported By: november at netsecuretech dot com
-Status: Feedback
+Status: Open
Bug Type: MySQLi related
Operating System: windowsXP
PHP Version: 5.3.0
New Comment:
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.
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";
?>
Previous Comments:
[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
[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:
---
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
#49436 [Fbk->Opn]: during query executed, mysql connection lost
ID: 49436
User updated by: november at netsecuretech dot com
Reported By: november at netsecuretech dot com
-Status: Feedback
+Status: Open
Bug Type: MySQLi related
Operating System: windowsXP
PHP Version: 5.3.0
New Comment:
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>
Previous Comments:
[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:
---
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
#49436 [Com]: during query executed, mysql connection lost
ID: 49436
Comment by: november at netsecuretech dot com
Reported By: november at netsecuretech dot com
Status: Open
Bug Type: MySQLi related
Operating System: windowsXP
PHP Version: 5.3.0
New Comment:
mysql query takes 20~30 minutes;
$query = "create table test as select c_ip, count(*) from iis_summary
group by c_ip";
thank you
Previous Comments:
[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:
---
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
#49436 [NEW]: during query executed, mysql connection lost
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:
---
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
