#47243 [Asn]: oci_fetch_assoc() causes Apache 2.2.11 crashed and restarted (SQL CURSOR)
ID: 47243
Updated by: s...@php.net
Reported By: pcdinh at gmail dot com
Status: Assigned
Bug Type: OCI8 related
Operating System: Windows XP SP3
PHP Version: 5.3.0beta1
Assigned To: sixd
New Comment:
Fix is being reviewed prior to testing.
Previous Comments:
[2009-02-03 02:16:21] s...@php.net
Reproduces on Windows. Also crashes with --enable-maintainer-zts mode
on Linux
[2009-01-30 04:47:03] kureikain at gmail dot com
I don't think that is a bug!I have ever had same problem(MySQL)!Because
i used wrong version of libmysql.dll!I copied frm XAMPP to System32!
when i install PHP from zip package,i forget to overwrite libmysql.dll
in system32!Apache keep crashing whenever PHP execs query
[2009-01-29 19:19:15] pcdinh at gmail dot com
Description:
I wrote code to retrieve data that was returned from a query with
Oracle cursor. However oci_fetch_assoc() causes Apache 2.2.11 being
crashed and restarted. I am not sure if it is a Oracle client native
library or OCI8 issue.
Reproduce code:
---
?php
$conn = oci_connect(hr, hr, 'xe');
$sql = SELECT department_id, department_name, CURSOR(SELECT
COUNT(employee_id) num_empl
FROM employees e
WHERE
e.department_id = d.department_id) AS empl_count
FROM departments d;
$stmt = oci_parse($conn, $sql);
oci_execute($stmt);
while ($data = oci_fetch_assoc($stmt))
{
}
oci_free_statement($stmt);
oci_close($conn);
?
Expected result:
Those code is a slightly modified version taken from PHP Manual
http://vn2.php.net/oci_new_cursor
It should be executed without any crash and data can be retrieved
normally (as guided by PHP Manual)
Actual result:
--
Apache crashes and restarts
Type of Analysis Performed Crash Analysis
Machine Name HOME-4F44218659
Operating System Windows XP Service Pack 3
Number Of Processors 2
Process ID 2200
Process Image C:\server\Apache2.2\bin\httpd.exe
System Up-Time 10:12:12
Process Up-Time 00:01:07
Thread 169 - System ID 2128
Entry point msvcrt!endthreadex+3a
Create time 1/30/2009 1:57:53 AM
Time spent in user mode 0 Days 0:0:0.15
Time spent in kernel mode 0 Days 0:0:0.93
Function Arg 1 Arg 2 Arg 3 Source
OraClient10!kpufhndl0+33 4e5f544e 0002
OraClient10!kpufhndl+10 4e5f544e 0002 049ff9e8
OraClient10!OCIHandleFree+1a 4e5f544e 0002 0084eef0
oci!OCIHandleFree+1d 4e5f544e 0002 01b8a9d8
php_oci8!php_oci_statement_free+121 05ecf448 01b8a9d8
0083aa23
php_oci8!php_oci_statement_list_dtor+11 05ed09b8 01b8a9d8
01be5278
php5ts!list_entry_destructor+43 05ed09b8 01b8a9d8 05ed0988
php5ts!zend_hash_apply_deleter+97 01be5278 05ed0988
01b8a9d8
php5ts!zend_hash_apply_with_argument+5a 01be5278 01976a90
0022
php_oci8!zm_deactivate_oci+8a 0001 0029 01b8a9d8
php5ts!module_registry_cleanup+1c 00fd4ec8 01b8a9d8
01b8a9d8
php5ts!zend_hash_apply+40 00cd7340 007882c0 01b8a9d8
php5ts!zend_deactivate_modules+62 049fffa4
56433230
php5ts!zend_deactivate_modules+48 01b82a01
05ecc7c0
php5ts!php_end_ob_buffers+26 01b8a9d8 0073a040 01b8a9d8
php5ts!php_request_shutdown+247 00622fb6 01b82a18
php5apache2_2!php_apache_request_dtor+8 01b82a18 01b8a9d8
0005
php5apache2_2!php_handler+646 01b82a18 0073a040 01b82a18
libhttpd!ap_run_handler+21 01b82a18 01b82a18 01b82a18
libhttpd!ap_invoke_handler+ae 01b7d9c0 049fff38
libhttpd!ap_die+29e 01b82a18 007447a8
libhttpd!ap_get_request_note+1c9c 01b7d9c0 01b7d9c0
01b7d9c0
libhttpd!ap_run_process_connection+21 01b7d9c0 007121e8
049fff80
libhttpd!ap_process_connection+33 01b7d9c0 01b76990
00e4
libhttpd!ap_regkey_value_remove+c7c 01b7d9b8 00e4
00e8
msvcrt!endthreadex+a9 01b73958 00e4 00e8
kernel32!GetModuleFileNameA+1b4 77c3a341 01b73958
ORACLIENT10!KPUFHNDL0+33WARNING - DebugDiag was not able to locate
debug symbols for OraClient10.Dll, so the information below may be
incomplete.
In
httpd__PID__2200__Date__01_30_2009__Time_01_59_00AM__328__Second_Chance_Exception_C005.dmp
the assembly instruction at OraClient10!kpufhndl0+33 in
C:\oraclexe\app\oracle\product\10.2.0\server\BIN\OraClient10.Dll from
#47243 [Asn]: oci_fetch_assoc() causes Apache 2.2.11 crashed and restarted (SQL CURSOR)
ID: 47243
Updated by: s...@php.net
Reported By: pcdinh at gmail dot com
Status: Assigned
Bug Type: OCI8 related
Operating System: Windows XP SP3
PHP Version: 5.3.0beta1
Assigned To: sixd
New Comment:
Reproduces on Windows. Also crashes with --enable-maintainer-zts mode
on Linux
Previous Comments:
[2009-01-30 04:47:03] kureikain at gmail dot com
I don't think that is a bug!I have ever had same problem(MySQL)!Because
i used wrong version of libmysql.dll!I copied frm XAMPP to System32!
when i install PHP from zip package,i forget to overwrite libmysql.dll
in system32!Apache keep crashing whenever PHP execs query
[2009-01-29 19:19:15] pcdinh at gmail dot com
Description:
I wrote code to retrieve data that was returned from a query with
Oracle cursor. However oci_fetch_assoc() causes Apache 2.2.11 being
crashed and restarted. I am not sure if it is a Oracle client native
library or OCI8 issue.
Reproduce code:
---
?php
$conn = oci_connect(hr, hr, 'xe');
$sql = SELECT department_id, department_name, CURSOR(SELECT
COUNT(employee_id) num_empl
FROM employees e
WHERE
e.department_id = d.department_id) AS empl_count
FROM departments d;
$stmt = oci_parse($conn, $sql);
oci_execute($stmt);
while ($data = oci_fetch_assoc($stmt))
{
}
oci_free_statement($stmt);
oci_close($conn);
?
Expected result:
Those code is a slightly modified version taken from PHP Manual
http://vn2.php.net/oci_new_cursor
It should be executed without any crash and data can be retrieved
normally (as guided by PHP Manual)
Actual result:
--
Apache crashes and restarts
Type of Analysis Performed Crash Analysis
Machine Name HOME-4F44218659
Operating System Windows XP Service Pack 3
Number Of Processors 2
Process ID 2200
Process Image C:\server\Apache2.2\bin\httpd.exe
System Up-Time 10:12:12
Process Up-Time 00:01:07
Thread 169 - System ID 2128
Entry point msvcrt!endthreadex+3a
Create time 1/30/2009 1:57:53 AM
Time spent in user mode 0 Days 0:0:0.15
Time spent in kernel mode 0 Days 0:0:0.93
Function Arg 1 Arg 2 Arg 3 Source
OraClient10!kpufhndl0+33 4e5f544e 0002
OraClient10!kpufhndl+10 4e5f544e 0002 049ff9e8
OraClient10!OCIHandleFree+1a 4e5f544e 0002 0084eef0
oci!OCIHandleFree+1d 4e5f544e 0002 01b8a9d8
php_oci8!php_oci_statement_free+121 05ecf448 01b8a9d8
0083aa23
php_oci8!php_oci_statement_list_dtor+11 05ed09b8 01b8a9d8
01be5278
php5ts!list_entry_destructor+43 05ed09b8 01b8a9d8 05ed0988
php5ts!zend_hash_apply_deleter+97 01be5278 05ed0988
01b8a9d8
php5ts!zend_hash_apply_with_argument+5a 01be5278 01976a90
0022
php_oci8!zm_deactivate_oci+8a 0001 0029 01b8a9d8
php5ts!module_registry_cleanup+1c 00fd4ec8 01b8a9d8
01b8a9d8
php5ts!zend_hash_apply+40 00cd7340 007882c0 01b8a9d8
php5ts!zend_deactivate_modules+62 049fffa4
56433230
php5ts!zend_deactivate_modules+48 01b82a01
05ecc7c0
php5ts!php_end_ob_buffers+26 01b8a9d8 0073a040 01b8a9d8
php5ts!php_request_shutdown+247 00622fb6 01b82a18
php5apache2_2!php_apache_request_dtor+8 01b82a18 01b8a9d8
0005
php5apache2_2!php_handler+646 01b82a18 0073a040 01b82a18
libhttpd!ap_run_handler+21 01b82a18 01b82a18 01b82a18
libhttpd!ap_invoke_handler+ae 01b7d9c0 049fff38
libhttpd!ap_die+29e 01b82a18 007447a8
libhttpd!ap_get_request_note+1c9c 01b7d9c0 01b7d9c0
01b7d9c0
libhttpd!ap_run_process_connection+21 01b7d9c0 007121e8
049fff80
libhttpd!ap_process_connection+33 01b7d9c0 01b76990
00e4
libhttpd!ap_regkey_value_remove+c7c 01b7d9b8 00e4
00e8
msvcrt!endthreadex+a9 01b73958 00e4 00e8
kernel32!GetModuleFileNameA+1b4 77c3a341 01b73958
ORACLIENT10!KPUFHNDL0+33WARNING - DebugDiag was not able to locate
debug symbols for OraClient10.Dll, so the information below may be
incomplete.
In
httpd__PID__2200__Date__01_30_2009__Time_01_59_00AM__328__Second_Chance_Exception_C005.dmp
the assembly instruction at OraClient10!kpufhndl0+33 in
C:\oraclexe\app\oracle\product\10.2.0\server\BIN\OraClient10.Dll from
Oracle Corporation has caused an access violation exception (0xC005)
when trying to read from memory location 0x4e5f544e on thread 169
Module
