ID: 36607
User updated by: jreed at myers dot com
Reported By: jreed at myers dot com
Status: Open
Bug Type: OCI8 related
Operating System: Linux - 386
PHP Version: 5.1.2
New Comment:
The same query works just fine when I run it within SQL*Plus. And the
query works fine without the oci8.default_prefetch turned on. So this
clearly leads to a problem with the PHP OCI8 driver.
Previous Comments:
------------------------------------------------------------------------
[2006-03-10 05:57:24] cjbj at hotmail dot com
I'd contact Oracle Support about this. Give them the stack trace.
There seems to be a couple of recent 10.2 reports to Oracle with a
similar trace.
------------------------------------------------------------------------
[2006-03-08 19:05:25] jreed at myers dot com
As stated previously, Oracle Instant Client v10.2. Server version is
10.2 with dbLink v10.2 which links to a database v8i.
To create the dblink:
create database link linkname connect to username identified by
password using databasename;
------------------------------------------------------------------------
[2006-03-08 07:37:43] cjbj at hotmail dot com
That stack trace is pretty deep in Oracle. In case this problem needs
to be reported to them, what is the version
of the Oracle client libraries that PHP is linked with? What is the
Oracle server version? How are you creating the DB link?
------------------------------------------------------------------------
[2006-03-07 20:42:19] jreed at myers dot com
Here's the backtrace with all Zend extensions removed/turned off:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread -150626176 (LWP 20044)] 0x020683da in ttcfopr ()
from /usr/local/instantclient/lib/libclntsh.so.10.1
(gdb) bt
#0 0x020683da in ttcfopr () from
/usr/local/instantclient/lib/libclntsh.so.10.1
#1 0x0205f698 in ttcdrv () from
/usr/local/instantclient/lib/libclntsh.so.10.1
#2 0x01f45ec5 in nioqwa () from
/usr/local/instantclient/lib/libclntsh.so.10.1
#3 0x01db3d97 in upirtrc () from
/usr/local/instantclient/lib/libclntsh.so.10.1
#4 0x01d29a36 in kpurcsc () from
/usr/local/instantclient/lib/libclntsh.so.10.1
#5 0x01cdf07b in kpuexecv8 () from
/usr/local/instantclient/lib/libclntsh.so.10.1
#6 0x01ce140a in kpuexec () from
/usr/local/instantclient/lib/libclntsh.so.10.1
#7 0x01db8902 in OCIStmtExecute () from
/usr/local/instantclient/lib/libclntsh.so.10.1
#8 0x00476205 in php_oci_statement_execute (statement=0x862fa5c,
mode=140695500)
at /root/php5.1-200603062130/ext/oci8/oci8_statement.c:321
#9 0x0047b712 in zif_oci_execute (ht=2, return_value=0x871c724,
return_value_ptr=0x0, this_ptr=0x0, return_value_used=0)
at /root/php5.1-200603062130/ext/oci8/oci8_interface.c:1276
#10 0x011f472d in zend_do_fcall_common_helper_SPEC
(execute_data=0xfef46920) at zend_vm_execute.h:192
#11 0x011f40a1 in execute (op_array=0x8606cd8) at zend_vm_execute.h:92
#12 0x011f452f in zend_do_fcall_common_helper_SPEC
(execute_data=0xfef4df30) at zend_vm_execute.h:226
#13 0x011f40a1 in execute (op_array=0x85be084) at zend_vm_execute.h:92
#14 0x011df7be in zend_execute_scripts (type=8, retval=0x0,
file_count=3) at /root/php-5.1.2/Zend/zend.c:1101
#15 0x011aef24 in php_execute_script (primary_file=0xfef50270) at
/root/php-5.1.2/main/main.c:1720
#16 0x01236f08 in php_handler (r=0x85ab410) at
/root/php-5.1.2/sapi/apache2handler/sapi_apache2.c:584
#17 0x080765b2 in ap_run_handler (r=0x85ab410) at config.c:157
#18 0x08076ac6 in ap_invoke_handler (r=0x85ab410) at config.c:371
#19 0x08092eff in ap_process_request (r=0x85ab410) at
http_request.c:258 #20 0x08090fd1 in ap_process_http_connection
(c=0x85a5238) at http_core.c:171
#21 0x0807bb02 in ap_run_process_connection (c=0x85a5238) at
connection.c:43
#22 0x080a09f7 in child_main (child_num_arg=0) at prefork.c:640
#23 0x080a0af0 in make_child (s=0x83d1fd0, slot=0) at prefork.c:680
#24 0x080a1531 in ap_mpm_run (_pconf=0x83cd0a8, plog=0x8409198,
s=0x83d1fd0) at prefork.c:956
#25 0x08066f5c in main (argc=2, argv=0xfef50634) at main.c:712
------------------------------------------------------------------------
[2006-03-07 18:52:41] jreed at myers dot com
Same result with no Zend extensions. I am the only one with Zend
extensions installed. Others who never installed Zend have the same
problem.
------------------------------------------------------------------------
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/36607
--
Edit this bug report at http://bugs.php.net/?id=36607&edit=1
