|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2006-05-05 16:50 UTC] 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.
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Apr 19 19:01:26 2025 UTC |
Many thanks for this fast answer. I make a mistake. My linux server is really running PHP 5.1.2 not 5.1.4, as I spected. But, the bug with 5.1.4 really occurs in windows. My linux server with 5.1.2 is crashing in another part of the application (I'm still not sure about the exactly reason, but seems to be on a call to oci_execute, following is the backtrace on php 5.1.2). I will upgrade to 5.1.4 and look if the bug really occurs on Linux. Real sorry for this mistake. In the future I will see the backtrace before contacting you. Program received signal SIGSEGV, Segmentation fault. 0x40b8d42f in kpufGetRcvInfo () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 (gdb) bt #0 0x40b8d42f in kpufGetRcvInfo () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 #1 0x40e6836f in ttcacr () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 #2 0x40e63fff in ttcdrv () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 #3 0x40d04289 in nioqwa () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 #4 0x40adc296 in upirtrc () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 #5 0x40b8c041 in kpurcsc () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 #6 0x40bc7e87 in kpuexecv8 () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 #7 0x40bc9a62 in kpuexec () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 #8 0x40ad615e in OCIStmtExecute () from /opt/oracle/product/10gR1/lib/libclntsh.so.10.1 #9 0x405a47c4 in php_oci_statement_execute (statement=0x9828808, mode=159549480) at /usr/src/php-5.1.2/ext/oci8/oci8_statement.c:321 #10 0x405a848a in zif_oci_execute (ht=2, return_value=0x9c4f724, return_value_ptr=0x0, this_ptr=0x0, return_value_used=1) at /usr/src/php-5.1.2/ext/oci8/oci8_interface.c:1276 #11 0x406f9acf in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff30f0) at zend_vm_execute.h:192 #12 0x40743769 in execute (op_array=0x89aaa7c) at zend_vm_execute.h:92 #13 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff33f0) at zend_vm_execute.h:226 #14 0x40743769 in execute (op_array=0x899b99c) at zend_vm_execute.h:92 #15 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff4060) at zend_vm_execute.h:226 #16 0x40743769 in execute (op_array=0x89b09cc) at zend_vm_execute.h:92 #17 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff4790) at zend_vm_execute.h:226 #18 0x40743769 in execute (op_array=0x898e084) at zend_vm_execute.h:92 #19 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff4c50) at zend_vm_execute.h:226 #20 0x40743769 in execute (op_array=0x89aec54) at zend_vm_execute.h:92 #21 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff4d60) at zend_vm_execute.h:226 #22 0x40743769 in execute (op_array=0x89ef87c) at zend_vm_execute.h:92 #23 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff5010) at zend_vm_execute.h:226 #24 0x40743769 in execute (op_array=0x90245c4) at zend_vm_execute.h:92 #25 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff51d0) at zend_vm_execute.h:226 #26 0x40743769 in execute (op_array=0x901ad54) at zend_vm_execute.h:92 #27 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff5770) at zend_vm_execute.h:226 #28 0x40743769 in execute (op_array=0x9151a04) at zend_vm_execute.h:92 #29 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff5bf0) at zend_vm_execute.h:226 #30 0x40743769 in execute (op_array=0x9156b5c) at zend_vm_execute.h:92 #31 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff6220) at zend_vm_execute.h:226 #32 0x40743769 in execute (op_array=0x8bec9d4) at zend_vm_execute.h:92 #33 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff6550) at zend_vm_execute.h:226 #34 0x40743769 in execute (op_array=0x8b768e4) at zend_vm_execute.h:92 #35 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfffa9b0) at zend_vm_execute.h:226 #36 0x40743769 in execute (op_array=0x82f8dd8) at zend_vm_execute.h:92 #37 0x406d70bd in zend_call_function (fci=0xbfffaad0, fci_cache=0x0) at /usr/src/php-5.1.2/Zend/zend_execute_API.c:907 #38 0x406d7f58 in call_user_function_ex (function_table=0x0, object_pp=0x0, function_name=0x0, retval_ptr_ptr=0x0, param_count=0, params=0x0, no_separation=0, symbol_table=0x0) at /usr/src/php-5.1.2/Zend/zend_execute_API.c:571 #39 0x40652564 in zif_call_user_func_array (ht=2, return_value=0x8990584, return_value_ptr=0x0, this_ptr=0x0, return_value_used=1) at /usr/src/php-5.1.2/ext/standard/basic_functions.c:2148 #40 0x406f9acf in zend_do_fcall_common_helper_SPEC (execute_data=0xbfffbbe0) at zend_vm_execute.h:192 #41 0x40743769 in execute (op_array=0x82f3144) at zend_vm_execute.h:92 #42 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfffc150) at zend_vm_execute.h:226 #43 0x40743769 in execute (op_array=0x82f12dc) at zend_vm_execute.h:92 #44 0x406f9626 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfffcc70) at zend_vm_execute.h:226 #45 0x40743769 in execute (op_array=0x82e7404) at zend_vm_execute.h:92 #46 0x406df8ef in zend_execute_scripts (type=8, retval=0x0, file_count=3) at /usr/src/php-5.1.2/Zend/zend.c:1101 #47 0x406a9e0e in php_execute_script (primary_file=0xbfffefc0) at /usr/src/php-5.1.2/main/main.c:1720 #48 0x4074427f in php_handler (r=0x82c9ce0) at /usr/src/php-5.1.2/sapi/apache2handler/sapi_apache2.c:584 #49 0x080b036b in ap_run_handler () #50 0x082cacf8 in ?? () #51 0x00000000 in ?? () #52 0x082cacc8 in ?? () #53 0x00000003 in ?? () #54 0x08102d10 in ?? () #55 0x00000000 in ?? () #56 0x00000000 in ?? () #57 0x082c9ce0 in ?? () #58 0x0817a368 in ?? () #59 0xbffff128 in ?? () #60 0x080b2ce5 in ap_invoke_handler ()