ID: 37331
User updated by: jarismar_silva at adplabs dot com dot br
Reported By: jarismar_silva at adplabs dot com dot br
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Windows XP Professional SP2
PHP Version: 5.1.4
New Comment:
Here is the backtrace, hope be usefull:
> php_oci8.dll!php_oci_fetch_row(int ht=2, _zval_struct *
return_value=0x054dca68, _zval_struct * * return_value_ptr=0x00000000,
_zval_struct * this_ptr=0x00000000, int return_value_used=1, void * * *
tsrm_ls=0x0147ef80, int mode=88994928, int expected_args=2) Line
1678 C
php_oci8.dll!zif_oci_fetch_array(int ht=2, _zval_struct *
return_value=0x054dca68, _zval_struct * * return_value_ptr=0x00000000,
_zval_struct * this_ptr=0x00000000, int return_value_used=1, void * * *
tsrm_ls=0x0147ef80) Line 1469 + 0x27 bytes C
php5ts.dll!zend_do_fcall_common_helper_SPEC(_zend_execute_data *
execute_data=0x0520fb48, void * * * tsrm_ls=0x0147ef80) Line 200 +
0x35 bytes C
php5ts.dll!ZEND_DO_FCALL_SPEC_CONST_HANDLER(_zend_execute_data *
execute_data=0x00000000, void * * * tsrm_ls=0x0147ef80) Line 1640 +
0xe bytes C
php5ts.dll!execute(_zend_op_array * op_array=0x0520fbf4, void * * *
tsrm_ls=0x0520fc58) Line 92 + 0xc bytes C
kernel32.dll!7c80a1e7()
[Frames below may be incorrect and/or missing, no symbols loaded for
kernel32.dll]
ntdll.dll!7c9106eb()
msvcrt.dll!77c0c3c9()
ntdll.dll!7c91056d()
msvcrt.dll!77c0c2de()
php5ts.dll!virtual_chdir(const char * path=0x0520fc20, void * * *
tsrm_ls=0x0147ef80) Line 622 + 0x21 bytes C
php5ts.dll!virtual_chdir_file(const char * path=0x0520fdb0, int
(const char *, void * * *)* p_chdir=0x0147ef80, void * * *
tsrm_ls=0x0520feb8) Line 653 + 0xc bytes C
php5ts.dll!zend_fetch_property_address_read_helper_SPEC_CV_CONST(int
type=6600912, _zend_execute_data * execute_data=0x00000000, void * * *
tsrm_ls=0x0064b8d0) Line 20633 + 0x10b bytes C
msvcrt.dll!77c262a1()
php_mbstring.dll!OnUpdate_mbstring_internal_encoding(_zend_ini_entry
* entry=0x006c8ffd, char * new_value=0x054d0000, unsigned int
new_value_length=1, void * mh_arg1=0x00000018, void *
mh_arg2=0x00000000, void * mh_arg3=0x00000004, int stage=7107376, void
* * * tsrm_ls=0x00ce0718) Line 647 + 0x1e bytes C
ntdll.dll!7c9106eb()
php5ts.dll!_safe_emalloc(unsigned int nmemb=1, unsigned int size=25,
unsigned int offset=21491584) Line 237 + 0x8 bytes C
php_mbstring.dll!zm_activate_mbstring(int type=1, int
module_number=30, void * * * tsrm_ls=0x0147ef80) Line 979 + 0x10
bytes C
php5ts.dll!module_registry_request_startup(_zend_module_entry *
module=0x006928a0, void * * * tsrm_ls=0x0147ef80) Line 1835 + 0x11
bytes C
php5ts.dll!zend_hash_apply(_hashtable * ht=0x0520ffa4, int (void *,
void * * *)* apply_func=0x00000000, void * * * tsrm_ls=0x56433230)
Line 666 + 0x7 bytes C
php5apache2.dll!php_handler(request_rec * r=0x0077bce0) Line 535 +
0x5f bytes C
php5ts.dll!php_stream_open_for_zend(const char * filename=0x0147cfc8,
_zend_file_handle * handle=0x01479018, void * * * tsrm_ls=0x0147cfc8)
Line 918 C
libhttpd.dll!6ff0155f()
libhttpd.dll!6ff018a9()
libhttpd.dll!6ff0d7fc()
libhttpd.dll!6ff096e6()
libhttpd.dll!6ff0412f()
libhttpd.dll!6ff04382()
libhttpd.dll!6ff1c0da()
msvcrt.dll!77c1a3b0()
kernel32.dll!7c80b50b()
kernel32.dll!7c8399f3()
Previous Comments:
------------------------------------------------------------------------
[2006-05-05 18:47:04] [EMAIL PROTECTED]
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32
Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.
------------------------------------------------------------------------
[2006-05-05 17:55:21] jarismar_silva at adplabs dot com dot br
Following is the sctructure of table used into the command showed on
initial code.
CREATE TABLE INTEGRATIONVALUE (
IMD_ID NUMBER(6) NOT NULL,
ILV_CODE VARCHAR2(40) NOT NULL,
XML_DATA CLOB,
)
------------------------------------------------------------------------
[2006-05-05 17:20:23] jarismar_silva at adplabs dot com dot br
The same problem ocurr into linux server (for the same snipped code
initiali posted).
Apache error_log says:
child pid 3294 exit signal Segmentation fault (11)
The server is Suse Linux 2.6.5-7.244-smp
The php configure command whas:
'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs'
'--disable-debug' '--disable-ipv6' '--enable-force-cgi-redirect'
'--with-zlib' '--enable-track-vars' '--enable-sigchild'
'--with-tsrm-pthreads' '--without-mysql'
'--with-oci8=/opt/oracle/product/10gR1' '--disable-rpath'
'--enable-memory-limit' '--enable-inline-optimization' '--enable-xml'
'--with-gd' '--with-jpeg-dir=/usr' '--enable-gd-native-ttf'
'--with-mcrypt' '--with-mhash' '--with-curl'
------------------------------------------------------------------------
[2006-05-05 16:50:21] jarismar_silva at adplabs dot com dot br
Description:
------------
Trying to load data from table with CLOB column using oci_fetch_array
with combined values for mode, causes apache2 crash.
Reproduce code:
---------------
<?php
$conn = oci_connect(<user>, <password>, <db>);
$sSQL = "SELECT xml_data
FROM integrationvalue
WHERE imd_id = 1
AND ilv_code = 0612400006652";
$stmt = oci_parse($conn, $sSQL);
oci_execute($stmt);
var_dump($stmt); // show valid resource id
$row = oci_fetch_array($stmt, OCI_ASSOC | OCI_RETURN_LOBS); // <---
crash here
echo '<pre>';
print_r($row);
echo '</pre>';
?>
Expected result:
----------------
Must show the $stmt resource id on var_dump and and some string data
into the $row array.
Actual result:
--------------
My Machine is an P4 Dual core cpu (hyper threading) 2.8 Ghz, 2 Gb Ram.
The database is Oracle 10g. I'm using php_oci8.dll.
The apache log says:
Parent: child process exited with status 3221225477 -- Restarting.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37331&edit=1
