ID: 43340
Updated by: [EMAIL PROTECTED]
Reported By: marplatense at ubuntu dot com
Status: Open
Bug Type: OCI8 related
Operating System: Centos 4 64 bits
PHP Version: 5.2.5
New Comment:
I reproduced the crash. The quick fix was to change the PL/SQL package
so the cursor is IN OUT instead of just OUT.
Previous Comments:
------------------------------------------------------------------------
[2007-12-05 14:11:44] marplatense at ubuntu dot com
Hi Michael, I read your bug and I can confirm this bug does not exist
in php 5.2.3 (we're using that version while we wait for a fix).
We too agree that the problem is related to a double execution of a
procedure returning a ref cursor (at least that's how we could reproduce
it).
I couldn't find time to test Christian's suggestion to see if it works
for me but I will try to do it asap.
------------------------------------------------------------------------
[2007-12-05 13:42:09] michael dot virnstein at brodos dot de
The fix didn't work for me. I also have filed the bug (Bug #43449),
because haven't found this one.
The problem doesn't occure when you run a page two times. It occures
when you try to call a PL/SQL-Function which returns a ref cursor more
than once in a PHP-script. See bug Bug #43449 for more details.
------------------------------------------------------------------------
[2007-12-03 15:53:20] marplatense at ubuntu dot com
Christian, thanks for your input.
I will give it a try and let you guys know the results.
Regards.
------------------------------------------------------------------------
[2007-12-03 15:05:53] christian at elmerot dot se
Reverting the following patch fixed the segfault for us on executing
the same page twice. Might be worth trying to see if it fixes your issue
too
--- main.c 2007/09/21 14:12:52 1.640.2.23.2.56
+++ main.c 2007/09/24 11:53:40 1.640.2.23.2.57
@@ -18,7 +18,7 @@
+----------------------------------------------------------------------+
*/
-/* $Id: main.c,v 1.640.2.23.2.56 2007/09/21 14:12:52 tony2001 Exp $
*/
+/* $Id: main.c,v 1.640.2.23.2.57 2007/09/24 11:53:40 dmitry Exp $ */
/* {{{ includes
*/
@@ -1298,6 +1298,8 @@
} zend_catch {
retval = FAILURE;
} zend_end_try();
+
+ SG(sapi_started) = 1;
return retval;
}
------------------------------------------------------------------------
[2007-11-20 19:11:15] marplatense at ubuntu dot com
Hi, thanks for your quick answer.
Here's what I got after following the traceback's instructions.
Hope there's enough information for you to work on this. Let me know if
you need anything else.
(gdb) bt
#0 0x0000002a9b609f8b in kpufGetRcvInfo () from
/opt/oracle/orase/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
#1 0x0000002a9b82b508 in ttcacr () from
/opt/oracle/orase/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
#2 0x0000002a9b8303f4 in ttcdrv () from
/opt/oracle/orase/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
#3 0x0000002a9b70b7b8 in nioqwa () from
/opt/oracle/orase/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
#4 0x0000002a9b53ca5f in upirtrc () from
/opt/oracle/orase/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
#5 0x0000002a9b4a5fa3 in kpurcsc () from
/opt/oracle/orase/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
#6 0x0000002a9b4549df in kpuexecv8 () from
/opt/oracle/orase/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
#7 0x0000002a9b4525c3 in kpuexec () from
/opt/oracle/orase/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
#8 0x0000002a9b500937 in OCIStmtExecute () from
/opt/oracle/orase/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
#9 0x0000002a9a1f8d25 in php_oci_statement_execute
(statement=0x2a9cd276f0, mode=0)
at /opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:442
#10 0x0000002a9a202f39 in zif_oci_execute (ht=2,
return_value=0x2a9cd26e38, return_value_ptr=0x0, this_ptr=0x0,
return_value_used=0) at
/opt/downloads/php-5.2.5/ext/oci8/oci8_interface.c:1302
#11 0x0000002a9a439abc in zend_do_fcall_common_helper_SPEC
(execute_data=0x7fbfffcd40)
at /opt/downloads/php-5.2.5/Zend/zend_vm_execute.h:200
#12 0x0000002a9a43f769 in ZEND_DO_FCALL_SPEC_CONST_HANDLER
(execute_data=0x7fbfffcd40)
at /opt/downloads/php-5.2.5/Zend/zend_vm_execute.h:1681
#13 0x0000002a9a439554 in execute (op_array=0x2a9cd26558) at
/opt/downloads/php-5.2.5/Zend/zend_vm_execute.h:92
#14 0x0000002a9a411690 in zend_execute_scripts (type=8, retval=0x0,
file_count=3)
at /opt/downloads/php-5.2.5/Zend/zend.c:1134
#15 0x0000002a9a3b70af in php_execute_script
(primary_file=0x7fbffff280) at
/opt/downloads/php-5.2.5/main/main.c:2004
#16 0x0000002a9a48c2d4 in php_handler (r=0x552ae5a618) at
/opt/downloads/php-5.2.5/sapi/apache2handler/sapi_apache2.c:631
#17 0x000000552aac79f3 in ap_run_handler () from /usr/sbin/httpd
#18 0x000000552aac7eb1 in ap_invoke_handler () from /usr/sbin/httpd
#19 0x000000552aac4cb8 in ap_process_request () from /usr/sbin/httpd
#20 0x000000552aac0089 in _start () from /usr/sbin/httpd
#21 0x000000552aad1693 in ap_run_process_connection () from
/usr/sbin/httpd
#22 0x000000552aac5b20 in ap_graceful_stop_signalled () from
/usr/sbin/httpd
#23 0x000000552aac5dbd in ap_graceful_stop_signalled () from
/usr/sbin/httpd
#24 0x000000552aac5ea4 in ap_graceful_stop_signalled () from
/usr/sbin/httpd
#25 0x000000552aac65db in ap_mpm_run () from /usr/sbin/httpd
#26 0x000000552aacccef in main () from /usr/sbin/httpd
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/43340
--
Edit this bug report at http://bugs.php.net/?id=43340&edit=1
