#43340 [Opn->Fbk]: Segmentation fault after executing the same proc twice

From: iliaa@php.net Date: Tue, 20 Nov 2007 13:44:28 +0000

Subject: #43340 [Opn->Fbk]: Segmentation fault after executing the same proc twice

References: 1 Groups: php.bugs

Request: Send a blank email to php-bugs+get-119882@lists.php.net to get a copy of this message

 ID:               43340
 Updated by:       iliaa@php.net
 Reported By:      marplatense at ubuntu dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         OCI8 related
 Operating System: Centos 4 64 bits
 PHP Version:      5.2.5
 New Comment:

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.




Previous Comments:
------------------------------------------------------------------------

[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

Thread (9 messages)

marplatense at ubuntu dot comTue, 20 Nov 2007 03:16:43 +0000
iliaa@php.netTue, 20 Nov 2007 13:44:28 +0000#43340 [Opn->Fbk]: Segmentation fault after executing the same proc twice
marplatense at ubuntu dot comTue, 20 Nov 2007 19:11:16 +0000#43340 [Fbk->Opn]: Segmentation fault after executing the same proc twice
christian at elmerot dot seMon, 03 Dec 2007 15:05:54 +0000#43340 [Com]: Segmentation fault after executing the same proc twice
marplatense at ubuntu dot comMon, 03 Dec 2007 15:53:21 +0000#43340 [Opn]: Segmentation fault after executing the same proc twice
michael dot virnstein at brodos dot deWed, 05 Dec 2007 13:42:10 +0000#43340 [Com]: Segmentation fault after executing the same proc twice
marplatense at ubuntu dot comWed, 05 Dec 2007 14:11:44 +0000#43340 [Opn]: Segmentation fault after executing the same proc twice
sixd@php.netTue, 11 Dec 2007 20:03:56 +0000#43340 [Opn]: Segmentation fault after executing the same proc twice
sixd@php.netTue, 11 Dec 2007 20:42:52 +0000#43340 [Opn->Bgs]: Segmentation fault after executing the same proc twice

« previous	php.bugs (#119882)	next »

From:	iliaa@php.net	Date:	Tue, 20 Nov 2007 13:44:28 +0000
Subject:	#43340 [Opn->Fbk]: Segmentation fault after executing the same proc twice
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-119882@lists.php.net to get a copy of this message