ID: 41069 Updated by: [EMAIL PROTECTED] Reported By: brian dot kao at gateway dot com Status: Bogus -Bug Type: Oracle related +Bug Type: OCI8 related Operating System: linux PHP Version: 5.2.1 New Comment:
>Oracle has closed the SR stating that since the database link works >with sqlplus that the issue is with PHP which Oracle does not support. Are you sure SQLPlus uses the same client library? >The database does not need a patch since there is no issue with the >database link on the Oracle database side I'm aware of similar issues, see the last comment here: http://bugs.php.net/bug.php?id=36607 Previous Comments: ------------------------------------------------------------------------ [2007-04-19 21:48:13] brian dot kao at gateway dot com Tony, Our Oracle DBA tried reporting this issue to Oracle Support, but they came back to us and say this is not an Oracle issue. Here's the message I've received from our Oracle DBA: "Oracle has closed the SR stating that since the database link works with sqlplus that the issue is with PHP which Oracle does not support. The database does not need a patch since there is no issue with the database link on the Oracle database side." Are you aware of any workaround for this issue? ------------------------------------------------------------------------ [2007-04-13 08:07:19] [EMAIL PROTECTED] >could this be a PHP OCI8 driver issue? I'm saying it knows nothing of dblink. >What is your recommendation for this issue, going to Oracle support? Yes. ------------------------------------------------------------------------ [2007-04-13 08:00:41] brian dot kao at gateway dot com could this be a PHP OCI8 driver issue? If I limit the number of records returned, the query would run without any issue. This only happens when running a large query over dblink. What is your recommendation for this issue, going to Oracle support? ------------------------------------------------------------------------ [2007-04-13 07:53:28] [EMAIL PROTECTED] See bug #36607. PHP doesn't care whether you access the database using dblink or directly, so it's obviously not PHP problem. ------------------------------------------------------------------------ [2007-04-12 22:39:38] brian dot kao at gateway dot com Description: ------------ Running a large query over dbLink would cause Apache to seg fault Apache v1.3.37 Oracle Instant Client v10.2 Reproduce code: --------------- $sql = "select * from [EMAIL PROTECTED]"; $stmt = ociparse($conn, $sql); ociexecute($stmt, OCI_DEFAULT); Expected result: ---------------- ociexecute() would complete without any error Actual result: -------------- Apache seg faults immediately after the ociexecute() call. Here's the backtrace: (gdb) bt #0 0x0143997a in ttcfopr () from /usr/local/instantclient/libclntsh.so.10.1 #1 0x0143d476 in ttcdrv () from /usr/local/instantclient/libclntsh.so.10.1 #2 0x012d2951 in nioqwa () from /usr/local/instantclient/libclntsh.so.10.1 #3 0x010b837e in upirtrc () from /usr/local/instantclient/libclntsh.so.10.1 #4 0x01168129 in kpurcsc () from /usr/local/instantclient/libclntsh.so.10.1 #5 0x011a3f6f in kpuexecv8 () from /usr/local/instantclient/libclntsh.so.10.1 #6 0x011a5b4a in kpuexec () from /usr/local/instantclient/libclntsh.so.10.1 #7 0x010b2246 in OCIStmtExecute () from /usr/local/instantclient/libclntsh.so.10.1 #8 0x0813b898 in php_oci_statement_execute (statement=0xb7b5abb4, mode=32) at /home/eus110532/php-5.2.1/ext/oci8/oci8_statement.c:372 #9 0x08143de5 in zif_oci_execute (ht=2, return_value=0xb7b58b4c, return_value_ptr=0x0, this_ptr=0x0, return_value_used=1) at /home/eus110532/php-5.2.1/ext/oci8/oci8_interface.c:1287 #10 0x0835be35 in zend_do_fcall_common_helper_SPEC (execute_data=0xbff1e380) at zend_vm_execute.h:200 #11 0x08360885 in ZEND_DO_FCALL_SPEC_CONST_HANDLER (execute_data=0xbff1e380) at zend_vm_execute.h:1681 #12 0x0835ba4a in execute (op_array=0xb7b1ff4c) at zend_vm_execute.h:92 #13 0x0835bf6a in zend_do_fcall_common_helper_SPEC (execute_data=0xbff1e6b0) at zend_vm_execute.h:234 #14 0x0835c84b in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0xbff1e6b0) at zend_vm_execute.h:322 #15 0x0835ba4a in execute (op_array=0xb7b56090) at zend_vm_execute.h:92 #16 0x0835bf6a in zend_do_fcall_common_helper_SPEC (execute_data=0xbff1ed20) at zend_vm_execute.h:234 #17 0x0835c84b in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0xbff1ed20) at zend_vm_execute.h:322 #18 0x0835ba4a in execute (op_array=0xb7ade6ec) at zend_vm_execute.h:92 #19 0x0835bf6a in zend_do_fcall_common_helper_SPEC (execute_data=0xbff1f0c0) at zend_vm_execute.h:234 #20 0x0835c84b in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0xbff1f0c0) at zend_vm_execute.h:322 #21 0x0835ba4a in execute (op_array=0xb7adbe70) at zend_vm_execute.h:92 #22 0x0835bf6a in zend_do_fcall_common_helper_SPEC (execute_data=0xbff1f340) at zend_vm_execute.h:234 #23 0x0835c84b in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0xbff1f340) at zend_vm_execute.h:322 #24 0x0835ba4a in execute (op_array=0xb7adfb5c) at zend_vm_execute.h:92 #25 0x0835bf6a in zend_do_fcall_common_helper_SPEC (execute_data=0xbff1f490) at zend_vm_execute.h:234 #26 0x0835c84b in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0xbff1f490) at zend_vm_execute.h:322 #27 0x0835ba4a in execute (op_array=0xb7adf2c8) at zend_vm_execute.h:92 #28 0x0835bf6a in zend_do_fcall_common_helper_SPEC (execute_data=0xbff1f6e0) at zend_vm_execute.h:234 #29 0x0835c84b in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0xbff1f6e0) at zend_vm_execute.h:322 #30 0x0835ba4a in execute (op_array=0xb7ee8808) at zend_vm_execute.h:92 #31 0x0835bf6a in zend_do_fcall_common_helper_SPEC (execute_data=0xbff1f890) at zend_vm_execute.h:234 #32 0x0835c84b in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0xbff1f890) at zend_vm_execute.h:322 #33 0x0835ba4a in execute (op_array=0xb7edd1dc) at zend_vm_execute.h:92 #34 0x0833c6fa in zend_execute_scripts (type=8, retval=0x0, file_count=3) at /home/eus110532/php-5.2.1/Zend/zend.c:1135 #35 0x082f5d75 in php_execute_script (primary_file=0xbff21c50) at /home/eus110532/php-5.2.1/main/main.c:1784 #36 0x083a2104 in main (argc=2, argv=0xbff21d24) at /home/eus110532/php-5.2.1/sapi/cli/php_cli.c:1114 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41069&edit=1
