#41069 [NEW]: segfault when running a large query over dblink

From: brian dot kao at gateway dot com Operating system: linux PHP version: 5.2.1 PHP Bug Type: Oracle related Bug description: segfault when running a large query over dblink 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 table@db_link"; $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 bug report at http://bugs.php.net/?id=41069&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=41069&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=41069&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=41069&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=41069&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=41069&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=41069&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=41069&r=needscript Try newer version: http://bugs.php.net/fix.php?id=41069&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=41069&r=support Expected behavior: http://bugs.php.net/fix.php?id=41069&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=41069&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=41069&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=41069&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41069&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=41069&r=dst IIS Stability: http://bugs.php.net/fix.php?id=41069&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=41069&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=41069&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=41069&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=41069&r=mysqlcfg