ID: 43340
User updated by: marplatense at ubuntu dot com
Reported By: marplatense at ubuntu dot com
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Centos 4 64 bits
PHP Version: 5.2.5
New Comment:
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
Previous Comments:
------------------------------------------------------------------------
[2007-11-20 13:44:28] [EMAIL PROTECTED]
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32
Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.
------------------------------------------------------------------------
[2007-11-20 03:16:43] marplatense at ubuntu dot com
Description:
------------
Bug related to http://bugs.php.net/bug.php?id=37471 and
http://bugs.php.net/bug.php?id=38173 but with version 5.2.5 (the other
two are closed but we can reproduce the error every time we run
the test case with the latest stable release)
1- My php configuration:
./configure --prefix=/opt/php/php5.2.5 --exec-prefix=/opt/php/php5.2.5
--with-config-file-path=etc/httpd/conf.d --with-libdir=lib64 --with-gd
--with-zlib=/usr --with-xmlrpc
--with-oci8=/opt/oracle/orase/oracle/product/10.2.0/db_1
--with-apxs2=/usr/sbin/apxs --enable-sigchild --with-ttf=/usr/lib64
--enable-gd-native-ttf --enable-gd-imgstrttf --enable-gd-native-ttf
--with-ttf-dir=/usr/local/lib --with-freetype-dir=/opt/freetype
--with-zlib-dir=/usr/local/lib --with-png-dir=/usr/local/lib
--with-jpeg-dir=/usr/local/lib
--with-imap=/opt/imap-2006d.DEV.SNAP-0611201609/ --with-imap-ssl
--with-mysql=/usr/bin --enable-mbstring --with-iconv --with-zlib
--enable-sockets --disable-cgi --enable-debug
2- My apache version:
# ./apachectl -v
Server version: Apache/2.0.52
Server built: Jul 14 2007 11:50:35
3- My php version
# ./php -v
PHP 5.2.5 (cli) (built: Nov 19 2007 19:10:59) (DEBUG)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
Reproduce code:
---------------
1- The pl/sql script used for this example:
create or replace procedure test_lookup(p_out out sys_refcursor)
is
begin
open p_out for
select 1,2,3 from dual;
end;
/
create or replace procedure test_lookup2(p_out out sys_refcursor)
is
begin
open p_out for
select 1,2,3 from dual;
end;
/
2- the php script:
<?php
oci_internal_debug(true);
$conn=OCILogon(user, password, database);
$out=oci_new_cursor($conn);
$s=oci_parse($conn, "begin test_lookup(:b3); end;");
oci_bind_by_name($s, ":b3", $out ,-1, OCI_B_CURSOR);
oci_execute($s, OCI_DEFAULT);
oci_execute($out);
while (OCIFetchInto($out,$data)) {
echo $data[0];
}
OCIFreeCursor($out);
OCIFreeStatement($s);
// do it again
$out=oci_new_cursor($conn);
$s=oci_parse($conn, "begin test_lookup(:b3); end;");
//running with this test_lookup2 line instead of test_lookup
works perfectly
//$s=oci_parse($conn, "begin test_lookup2(:b3); end;");
oci_bind_by_name($s, ":b3", $out ,-1, OCI_B_CURSOR);
oci_execute($s, OCI_DEFAULT);
oci_execute($out);
while (OCIFetchInto($out,$data)) {
echo $data[0];
}
OCIFreeCursor($out);
?>
Expected result:
----------------
We expect the right output from procedure "test_lookup".
Actual result:
--------------
1- We get a segmentation fault in the apache's error log:
[Mon Nov 19 18:50:19 2007] [notice] child pid 29774 exit signal
Segmentation fault (11)
2- this is what we get with oci_internal_debug:
# ./php -c /etc/httpd/conf.d/php.ini test.php
OCI8 DEBUG: OCINlsEnvironmentVariableGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1067)
OCI8 DEBUG: OCIEnvNlsCreate at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1223)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1252)
OCI8 DEBUG: OCIServerAttach at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1261)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1271)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1280)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1289)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1299)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1310)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1320)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1329)
OCI8 DEBUG: OCISessionBegin at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1360)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8.c:1393)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:55)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:61)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:135)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:144)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:61)
OCI8 DEBUG: OCIStmtPrepare2 at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:77)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:135)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:144)
OCI8 DEBUG: OCIBindByName at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:1050)
OCI8 DEBUG: OCIBindDynamic at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:1068)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:418)
OCI8 DEBUG: OCIStmtExecute at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:442)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:418)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:471)
OCI8 DEBUG: OCIParamGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:491)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:500)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:510)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:520)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:530)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:543)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:553)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:563)
OCI8 DEBUG: OCIDescriptorFree at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:571)
OCI8 DEBUG: OCIDefineByPos at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:694)
OCI8 DEBUG: OCIParamGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:491)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:500)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:510)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:520)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:530)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:543)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:553)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:563)
OCI8 DEBUG: OCIDescriptorFree at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:571)
OCI8 DEBUG: OCIDefineByPos at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:694)
OCI8 DEBUG: OCIParamGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:491)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:500)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:510)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:520)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:530)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:543)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:553)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:563)
OCI8 DEBUG: OCIDescriptorFree at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:571)
OCI8 DEBUG: OCIDefineByPos at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:694)
OCI8 DEBUG: OCIStmtFetch at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:168)
1OCI8 DEBUG: OCIStmtFetch at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:168)
OCI8 DEBUG: OCIHandleFree at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:748)
OCI8 DEBUG: OCIHandleFree at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:757)
OCI8 DEBUG: OCIStmtRelease at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:746)
OCI8 DEBUG: OCIHandleFree at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:757)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:55)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:61)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:135)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:144)
OCI8 DEBUG: OCIHandleAlloc at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:61)
OCI8 DEBUG: OCIStmtPrepare2 at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:77)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:135)
OCI8 DEBUG: OCIAttrSet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:144)
OCI8 DEBUG: OCIBindByName at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:1050)
OCI8 DEBUG: OCIBindDynamic at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:1068)
OCI8 DEBUG: OCIAttrGet at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:418)
OCI8 DEBUG: OCIStmtExecute at
(/opt/downloads/php-5.2.5/ext/oci8/oci8_statement.c:442)
Violación de segmento
Where "Violación de segmento" stands for "Segmentation fault" (in
spanish)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=43340&edit=1
