Bug #16272 Updated: SegFault in MySQL
ID: 16272
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating System: Linux 2.4.x
PHP Version: 4.1.2
New Comment:
I would like to thank fcaprioli for the additional input;
unfortunately, it does not resolve our problem. If you look at the code
snippet that I submitted earlier, you can see that we already include
the link ID in our query: i.e.,
"$res=mysql_db_query($this->dbase,$query,$dbLink)", where $dbLink is
the link ID. So basically, we're where we were before: stuck with
intermittent failures.
Previous Comments:
[2002-04-11 07:20:28] [EMAIL PROTECTED]
I was affected by the same bug, but I've found a workaround.
On linux 2.4.18, glibc 2.2.3 and MySQL 3.23.49, apache 1.3.24 with php
4.1.2 statically compiled (mysql external driver,
--with-mysql=mysql_install_dir)
by explicitly indicating the link id, mysql seems to work fine. So
$conn = mysql_pconnect("host","username","pass");
mysql_select_db("db1");
$query = mysql_query("SELECT * FROM xxx")
while ($row = mysql_fetch_array($query)) do_stuff();
would randomly segfault apache, while
$conn = mysql_pconnect("host","username","pass");
mysql_select_db("db1",$conn);
$query = mysql_query("SELECT * FROM xxx",$conn)
while ($row = mysql_fetch_array($query)) do_stuff();
works without problem.
[2002-04-03 14:24:47] [EMAIL PROTECTED]
I just set up a separate box to test if this bug has anything to do
with what version of glibc is used.
The bug is still there in the following setup:
glibc-2.2.4-19.3 (RedHat Linux 7.2)
MySQL-3.23.42-1
PHP v4.1.2 compiled as a static module for Apache 1.3.22
[2002-03-26 13:42:23] [EMAIL PROTECTED]
The bug still shows up in 4.2.0RC1
[2002-03-26 13:41:16] [EMAIL PROTECTED]
The segfault occurs in the following code snippet (a db wrapper that we
wrote for MySQL). What is odd is that this only happens on occasion:
this method is called exceptionally often in our code and only breaks
(in 4.1.x, not 4.0.x) once in a while and not on exceptional
queries--we have, for instance, seen it break on a query that returns
only one row. Anyway, here's the code:
/**
* send a query to the DBMS using the dbLinkID
* @param $dbLink - the link connection ID [INT]
* @param $query [STRING]
* @return the query in ORACLE format $result[FIELDNAME][ROWNUM]=value
[2D HASH]
* @access public
*/
function db_query($dbLink, $query){
$res=mysql_db_query($this->dbase,$query,$dbLink);
while($row=@mysql_fetch_array($res,MYSQL_ASSOC)){
while(list($key,$val)=@each($row)){
$result[$key][]=$val;
}
$x++;
}
if(!is_array($result)) $result=array();
return $result;
}
Thanks for looking into this.
--jonathan
[2002-03-26 07:59:40] [EMAIL PROTECTED]
When does this segfault occur? Can you provide a sample script?
Also, can you try 4.2.0RC1 (see www.php.net/~derick) and see if it has
been fixed?
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/16272
--
Edit this bug report at http://bugs.php.net/?id=16272&edit=1
Bug #16272 Updated: SegFault in MySQL
ID: 16272
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating System: Linux 2.4.x
PHP Version: 4.1.2
New Comment:
I was affected by the same bug, but I've found a workaround.
On linux 2.4.18, glibc 2.2.3 and MySQL 3.23.49, apache 1.3.24 with php
4.1.2 statically compiled (mysql external driver,
--with-mysql=mysql_install_dir)
by explicitly indicating the link id, mysql seems to work fine. So
$conn = mysql_pconnect("host","username","pass");
mysql_select_db("db1");
$query = mysql_query("SELECT * FROM xxx")
while ($row = mysql_fetch_array($query)) do_stuff();
would randomly segfault apache, while
$conn = mysql_pconnect("host","username","pass");
mysql_select_db("db1",$conn);
$query = mysql_query("SELECT * FROM xxx",$conn)
while ($row = mysql_fetch_array($query)) do_stuff();
works without problem.
Previous Comments:
[2002-04-03 14:24:47] [EMAIL PROTECTED]
I just set up a separate box to test if this bug has anything to do
with what version of glibc is used.
The bug is still there in the following setup:
glibc-2.2.4-19.3 (RedHat Linux 7.2)
MySQL-3.23.42-1
PHP v4.1.2 compiled as a static module for Apache 1.3.22
[2002-03-26 13:42:23] [EMAIL PROTECTED]
The bug still shows up in 4.2.0RC1
[2002-03-26 13:41:16] [EMAIL PROTECTED]
The segfault occurs in the following code snippet (a db wrapper that we
wrote for MySQL). What is odd is that this only happens on occasion:
this method is called exceptionally often in our code and only breaks
(in 4.1.x, not 4.0.x) once in a while and not on exceptional
queries--we have, for instance, seen it break on a query that returns
only one row. Anyway, here's the code:
/**
* send a query to the DBMS using the dbLinkID
* @param $dbLink - the link connection ID [INT]
* @param $query [STRING]
* @return the query in ORACLE format $result[FIELDNAME][ROWNUM]=value
[2D HASH]
* @access public
*/
function db_query($dbLink, $query){
$res=mysql_db_query($this->dbase,$query,$dbLink);
while($row=@mysql_fetch_array($res,MYSQL_ASSOC)){
while(list($key,$val)=@each($row)){
$result[$key][]=$val;
}
$x++;
}
if(!is_array($result)) $result=array();
return $result;
}
Thanks for looking into this.
--jonathan
[2002-03-26 07:59:40] [EMAIL PROTECTED]
When does this segfault occur? Can you provide a sample script?
Also, can you try 4.2.0RC1 (see www.php.net/~derick) and see if it has
been fixed?
[2002-03-25 19:48:58] [EMAIL PROTECTED]
maybe related to BUG #14860; here's the backtrace:
Program received signal SIGSEGV, Segmentation fault.
0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50, default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
123 } else if ((*passed_id)->type != IS_RESOURCE)
{
(gdb) bt
#0 0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50,
default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
#1 0x809363c in php_mysql_do_query_general (query=0x829ca4c,
mysql_link=0x829ca50,
link_id=-1, db=0x829ca48, use_store=1, return_value=0x8633cf4) at
php_mysql.c:981
#2 0x8093bc2 in zif_mysql_db_query (ht=3, return_value=0x8633cf4,
this_ptr=0x0,
return_value_used=1) at php_mysql.c:1113
#3 0x8156da1 in execute (op_array=0x8622a44) at ./zend_execute.c:1590
#4 0x8156f79 in execute (op_array=0x844e7bc) at ./zend_execute.c:1630
#5 0x8156f79 in execute (op_array=0x859930c) at ./zend_execute.c:1630
#6 0x8156f79 in execute (op_array=0x86092a8) at ./zend_execute.c:1630
#7 0x8156f79 in execute (op_array=0x8530668) at ./zend_execute.c:1630
#8 0x8156f79 in execute (op_array=0x8617eec) at ./zend_execute.c:1630
#9 0x8158c96 in execute (op_array=0x82c8a8c) at ./zend_execute.c:2133
#10 0x813395c in zend_execute_scripts (type=8, retval=0x0,
file_count=3) at zend.c:814
#11 0x8080dee in php_execute_script (primary_file=0xb938) at
main.c:1307
#12 0x813e8f9 in apache_php_module_main (r=0x82344ac,
display_source_mode=0)
at sapi_apache.c:90
#13 0x807d876 in send_php ()
#14 0x807d8cf in send_parsed_php ()
#15 0x8160d93 in ap_invoke_handler ()
#16 0x8174d19 in process_request_internal ()
#17 0x8174d7c i
Bug #16272 Updated: SegFault in MySQL
ID: 16272
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating System: Linux 2.4.x
PHP Version: 4.1.2
New Comment:
I just set up a separate box to test if this bug has anything to do
with what version of glibc is used.
The bug is still there in the following setup:
glibc-2.2.4-19.3 (RedHat Linux 7.2)
MySQL-3.23.42-1
PHP v4.1.2 compiled as a static module for Apache 1.3.22
Previous Comments:
[2002-03-26 13:42:23] [EMAIL PROTECTED]
The bug still shows up in 4.2.0RC1
[2002-03-26 13:41:16] [EMAIL PROTECTED]
The segfault occurs in the following code snippet (a db wrapper that we
wrote for MySQL). What is odd is that this only happens on occasion:
this method is called exceptionally often in our code and only breaks
(in 4.1.x, not 4.0.x) once in a while and not on exceptional
queries--we have, for instance, seen it break on a query that returns
only one row. Anyway, here's the code:
/**
* send a query to the DBMS using the dbLinkID
* @param $dbLink - the link connection ID [INT]
* @param $query [STRING]
* @return the query in ORACLE format $result[FIELDNAME][ROWNUM]=value
[2D HASH]
* @access public
*/
function db_query($dbLink, $query){
$res=mysql_db_query($this->dbase,$query,$dbLink);
while($row=@mysql_fetch_array($res,MYSQL_ASSOC)){
while(list($key,$val)=@each($row)){
$result[$key][]=$val;
}
$x++;
}
if(!is_array($result)) $result=array();
return $result;
}
Thanks for looking into this.
--jonathan
[2002-03-26 07:59:40] [EMAIL PROTECTED]
When does this segfault occur? Can you provide a sample script?
Also, can you try 4.2.0RC1 (see www.php.net/~derick) and see if it has
been fixed?
[2002-03-25 19:48:58] [EMAIL PROTECTED]
maybe related to BUG #14860; here's the backtrace:
Program received signal SIGSEGV, Segmentation fault.
0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50, default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
123 } else if ((*passed_id)->type != IS_RESOURCE)
{
(gdb) bt
#0 0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50,
default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
#1 0x809363c in php_mysql_do_query_general (query=0x829ca4c,
mysql_link=0x829ca50,
link_id=-1, db=0x829ca48, use_store=1, return_value=0x8633cf4) at
php_mysql.c:981
#2 0x8093bc2 in zif_mysql_db_query (ht=3, return_value=0x8633cf4,
this_ptr=0x0,
return_value_used=1) at php_mysql.c:1113
#3 0x8156da1 in execute (op_array=0x8622a44) at ./zend_execute.c:1590
#4 0x8156f79 in execute (op_array=0x844e7bc) at ./zend_execute.c:1630
#5 0x8156f79 in execute (op_array=0x859930c) at ./zend_execute.c:1630
#6 0x8156f79 in execute (op_array=0x86092a8) at ./zend_execute.c:1630
#7 0x8156f79 in execute (op_array=0x8530668) at ./zend_execute.c:1630
#8 0x8156f79 in execute (op_array=0x8617eec) at ./zend_execute.c:1630
#9 0x8158c96 in execute (op_array=0x82c8a8c) at ./zend_execute.c:2133
#10 0x813395c in zend_execute_scripts (type=8, retval=0x0,
file_count=3) at zend.c:814
#11 0x8080dee in php_execute_script (primary_file=0xb938) at
main.c:1307
#12 0x813e8f9 in apache_php_module_main (r=0x82344ac,
display_source_mode=0)
at sapi_apache.c:90
#13 0x807d876 in send_php ()
#14 0x807d8cf in send_parsed_php ()
#15 0x8160d93 in ap_invoke_handler ()
#16 0x8174d19 in process_request_internal ()
#17 0x8174d7c in ap_process_request ()
#18 0x816c30e in child_main ()
#19 0x816c4a0 in make_child ()
#20 0x816c5f9 in startup_children ()
#21 0x816cc56 in standalone_main ()
#22 0x816d413 in main ()
#23 0x40140e29 in __libc_start_main () from /lib/libc.so.6
--
Edit this bug report at http://bugs.php.net/?id=16272&edit=1
Bug #16272 Updated: SegFault in MySQL
ID: 16272
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating System: Linux 2.4.x
PHP Version: 4.1.2
New Comment:
The bug still shows up in 4.2.0RC1
Previous Comments:
[2002-03-26 13:41:16] [EMAIL PROTECTED]
The segfault occurs in the following code snippet (a db wrapper that we
wrote for MySQL). What is odd is that this only happens on occasion:
this method is called exceptionally often in our code and only breaks
(in 4.1.x, not 4.0.x) once in a while and not on exceptional
queries--we have, for instance, seen it break on a query that returns
only one row. Anyway, here's the code:
/**
* send a query to the DBMS using the dbLinkID
* @param $dbLink - the link connection ID [INT]
* @param $query [STRING]
* @return the query in ORACLE format $result[FIELDNAME][ROWNUM]=value
[2D HASH]
* @access public
*/
function db_query($dbLink, $query){
$res=mysql_db_query($this->dbase,$query,$dbLink);
while($row=@mysql_fetch_array($res,MYSQL_ASSOC)){
while(list($key,$val)=@each($row)){
$result[$key][]=$val;
}
$x++;
}
if(!is_array($result)) $result=array();
return $result;
}
Thanks for looking into this.
--jonathan
[2002-03-26 07:59:40] [EMAIL PROTECTED]
When does this segfault occur? Can you provide a sample script?
Also, can you try 4.2.0RC1 (see www.php.net/~derick) and see if it has
been fixed?
[2002-03-25 19:48:58] [EMAIL PROTECTED]
maybe related to BUG #14860; here's the backtrace:
Program received signal SIGSEGV, Segmentation fault.
0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50, default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
123 } else if ((*passed_id)->type != IS_RESOURCE)
{
(gdb) bt
#0 0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50,
default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
#1 0x809363c in php_mysql_do_query_general (query=0x829ca4c,
mysql_link=0x829ca50,
link_id=-1, db=0x829ca48, use_store=1, return_value=0x8633cf4) at
php_mysql.c:981
#2 0x8093bc2 in zif_mysql_db_query (ht=3, return_value=0x8633cf4,
this_ptr=0x0,
return_value_used=1) at php_mysql.c:1113
#3 0x8156da1 in execute (op_array=0x8622a44) at ./zend_execute.c:1590
#4 0x8156f79 in execute (op_array=0x844e7bc) at ./zend_execute.c:1630
#5 0x8156f79 in execute (op_array=0x859930c) at ./zend_execute.c:1630
#6 0x8156f79 in execute (op_array=0x86092a8) at ./zend_execute.c:1630
#7 0x8156f79 in execute (op_array=0x8530668) at ./zend_execute.c:1630
#8 0x8156f79 in execute (op_array=0x8617eec) at ./zend_execute.c:1630
#9 0x8158c96 in execute (op_array=0x82c8a8c) at ./zend_execute.c:2133
#10 0x813395c in zend_execute_scripts (type=8, retval=0x0,
file_count=3) at zend.c:814
#11 0x8080dee in php_execute_script (primary_file=0xb938) at
main.c:1307
#12 0x813e8f9 in apache_php_module_main (r=0x82344ac,
display_source_mode=0)
at sapi_apache.c:90
#13 0x807d876 in send_php ()
#14 0x807d8cf in send_parsed_php ()
#15 0x8160d93 in ap_invoke_handler ()
#16 0x8174d19 in process_request_internal ()
#17 0x8174d7c in ap_process_request ()
#18 0x816c30e in child_main ()
#19 0x816c4a0 in make_child ()
#20 0x816c5f9 in startup_children ()
#21 0x816cc56 in standalone_main ()
#22 0x816d413 in main ()
#23 0x40140e29 in __libc_start_main () from /lib/libc.so.6
--
Edit this bug report at http://bugs.php.net/?id=16272&edit=1
Bug #16272 Updated: SegFault in MySQL
ID: 16272
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Feedback
+Status: Open
Bug Type: MySQL related
Operating System: Linux 2.4.x
PHP Version: 4.1.2
New Comment:
The segfault occurs in the following code snippet (a db wrapper that we
wrote for MySQL). What is odd is that this only happens on occasion:
this method is called exceptionally often in our code and only breaks
(in 4.1.x, not 4.0.x) once in a while and not on exceptional
queries--we have, for instance, seen it break on a query that returns
only one row. Anyway, here's the code:
/**
* send a query to the DBMS using the dbLinkID
* @param $dbLink - the link connection ID [INT]
* @param $query [STRING]
* @return the query in ORACLE format $result[FIELDNAME][ROWNUM]=value
[2D HASH]
* @access public
*/
function db_query($dbLink, $query){
$res=mysql_db_query($this->dbase,$query,$dbLink);
while($row=@mysql_fetch_array($res,MYSQL_ASSOC)){
while(list($key,$val)=@each($row)){
$result[$key][]=$val;
}
$x++;
}
if(!is_array($result)) $result=array();
return $result;
}
Thanks for looking into this.
--jonathan
Previous Comments:
[2002-03-26 07:59:40] [EMAIL PROTECTED]
When does this segfault occur? Can you provide a sample script?
Also, can you try 4.2.0RC1 (see www.php.net/~derick) and see if it has
been fixed?
[2002-03-25 19:48:58] [EMAIL PROTECTED]
maybe related to BUG #14860; here's the backtrace:
Program received signal SIGSEGV, Segmentation fault.
0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50, default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
123 } else if ((*passed_id)->type != IS_RESOURCE)
{
(gdb) bt
#0 0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50,
default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
#1 0x809363c in php_mysql_do_query_general (query=0x829ca4c,
mysql_link=0x829ca50,
link_id=-1, db=0x829ca48, use_store=1, return_value=0x8633cf4) at
php_mysql.c:981
#2 0x8093bc2 in zif_mysql_db_query (ht=3, return_value=0x8633cf4,
this_ptr=0x0,
return_value_used=1) at php_mysql.c:1113
#3 0x8156da1 in execute (op_array=0x8622a44) at ./zend_execute.c:1590
#4 0x8156f79 in execute (op_array=0x844e7bc) at ./zend_execute.c:1630
#5 0x8156f79 in execute (op_array=0x859930c) at ./zend_execute.c:1630
#6 0x8156f79 in execute (op_array=0x86092a8) at ./zend_execute.c:1630
#7 0x8156f79 in execute (op_array=0x8530668) at ./zend_execute.c:1630
#8 0x8156f79 in execute (op_array=0x8617eec) at ./zend_execute.c:1630
#9 0x8158c96 in execute (op_array=0x82c8a8c) at ./zend_execute.c:2133
#10 0x813395c in zend_execute_scripts (type=8, retval=0x0,
file_count=3) at zend.c:814
#11 0x8080dee in php_execute_script (primary_file=0xb938) at
main.c:1307
#12 0x813e8f9 in apache_php_module_main (r=0x82344ac,
display_source_mode=0)
at sapi_apache.c:90
#13 0x807d876 in send_php ()
#14 0x807d8cf in send_parsed_php ()
#15 0x8160d93 in ap_invoke_handler ()
#16 0x8174d19 in process_request_internal ()
#17 0x8174d7c in ap_process_request ()
#18 0x816c30e in child_main ()
#19 0x816c4a0 in make_child ()
#20 0x816c5f9 in startup_children ()
#21 0x816cc56 in standalone_main ()
#22 0x816d413 in main ()
#23 0x40140e29 in __libc_start_main () from /lib/libc.so.6
--
Edit this bug report at http://bugs.php.net/?id=16272&edit=1
Bug #16272 Updated: SegFault in MySQL
ID: 16272
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Feedback
Bug Type: MySQL related
Operating System: Linux 2.4.x
PHP Version: 4.1.2
New Comment:
When does this segfault occur? Can you provide a sample script?
Also, can you try 4.2.0RC1 (see www.php.net/~derick) and see if it has
been fixed?
Previous Comments:
[2002-03-25 19:48:58] [EMAIL PROTECTED]
maybe related to BUG #14860; here's the backtrace:
Program received signal SIGSEGV, Segmentation fault.
0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50, default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
123 } else if ((*passed_id)->type != IS_RESOURCE)
{
(gdb) bt
#0 0x813a1e5 in zend_fetch_resource (passed_id=0x829ca50,
default_id=-1,
resource_type_name=0x819174e "MySQL-Link", found_resource_type=0x0,
num_resource_types=2)
at zend_list.c:123
#1 0x809363c in php_mysql_do_query_general (query=0x829ca4c,
mysql_link=0x829ca50,
link_id=-1, db=0x829ca48, use_store=1, return_value=0x8633cf4) at
php_mysql.c:981
#2 0x8093bc2 in zif_mysql_db_query (ht=3, return_value=0x8633cf4,
this_ptr=0x0,
return_value_used=1) at php_mysql.c:1113
#3 0x8156da1 in execute (op_array=0x8622a44) at ./zend_execute.c:1590
#4 0x8156f79 in execute (op_array=0x844e7bc) at ./zend_execute.c:1630
#5 0x8156f79 in execute (op_array=0x859930c) at ./zend_execute.c:1630
#6 0x8156f79 in execute (op_array=0x86092a8) at ./zend_execute.c:1630
#7 0x8156f79 in execute (op_array=0x8530668) at ./zend_execute.c:1630
#8 0x8156f79 in execute (op_array=0x8617eec) at ./zend_execute.c:1630
#9 0x8158c96 in execute (op_array=0x82c8a8c) at ./zend_execute.c:2133
#10 0x813395c in zend_execute_scripts (type=8, retval=0x0,
file_count=3) at zend.c:814
#11 0x8080dee in php_execute_script (primary_file=0xb938) at
main.c:1307
#12 0x813e8f9 in apache_php_module_main (r=0x82344ac,
display_source_mode=0)
at sapi_apache.c:90
#13 0x807d876 in send_php ()
#14 0x807d8cf in send_parsed_php ()
#15 0x8160d93 in ap_invoke_handler ()
#16 0x8174d19 in process_request_internal ()
#17 0x8174d7c in ap_process_request ()
#18 0x816c30e in child_main ()
#19 0x816c4a0 in make_child ()
#20 0x816c5f9 in startup_children ()
#21 0x816cc56 in standalone_main ()
#22 0x816d413 in main ()
#23 0x40140e29 in __libc_start_main () from /lib/libc.so.6
--
Edit this bug report at http://bugs.php.net/?id=16272&edit=1
