From:             Volker dot Weinberger at pharma dot novartis dot com
Operating system: Solaris 5.8
PHP version:      5.0.1
PHP Bug Type:     Reproducible crash
Bug description:  CLI PHP crash after successful script completion when querying 
Oracle 9 DB CLOB

Description:
------------
PHP CLI script consistently crashes with 5.0.1 *after* successful
completion, i.e. the script executes successfully right to the end ("just
before the end" line is printed in sample script below). Then, after a
short delay, a bus error is produced (core dump).

The same scripts (as well as the original script, sample script is
shortened) work fine with CLI PHP 4.3.6 .

The issue is tracked down to the d.seq field in the Oracle query, which is
a CLOB 4000 field. The script does not crash when this field is omitted
from the query.

PEAR DB is used for Oracle connection. PEAR DB version: 
//
// $Id: DB.php,v 1.59 2004/07/08 21:15:11 danielc Exp $
//


Reproduce code:
---------------
#!.../php501
<?php
require_once('DB.php');

$dbh = DB::connect("oci8://...");
if (!$dbh) {
        die("ERROR:Cannot connect to BCH1!");
}

$sql =  " SELECT d.seq " .
        " FROM sqbox.seqmandata d WHERE d.nvs_id = 'NVS00002050'" ;

$sth=$dbh->query($sql);
if(DB::isError($sth)){
   die ($sth->getMessage());
}

print "just before the end\n";
?>

Expected result:
----------------
No core dump.

Actual result:
--------------
Script produces full correct results, but core dumps right at the end.

-- 
Edit bug report at http://bugs.php.net/?id=29864&edit=1
-- 
Try a CVS snapshot (php4):   http://bugs.php.net/fix.php?id=29864&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=29864&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=29864&r=trysnapshot51
Fixed in CVS:                http://bugs.php.net/fix.php?id=29864&r=fixedcvs
Fixed in release:            http://bugs.php.net/fix.php?id=29864&r=alreadyfixed
Need backtrace:              http://bugs.php.net/fix.php?id=29864&r=needtrace
Need Reproduce Script:       http://bugs.php.net/fix.php?id=29864&r=needscript
Try newer version:           http://bugs.php.net/fix.php?id=29864&r=oldversion
Not developer issue:         http://bugs.php.net/fix.php?id=29864&r=support
Expected behavior:           http://bugs.php.net/fix.php?id=29864&r=notwrong
Not enough info:             http://bugs.php.net/fix.php?id=29864&r=notenoughinfo
Submitted twice:             http://bugs.php.net/fix.php?id=29864&r=submittedtwice
register_globals:            http://bugs.php.net/fix.php?id=29864&r=globals
PHP 3 support discontinued:  http://bugs.php.net/fix.php?id=29864&r=php3
Daylight Savings:            http://bugs.php.net/fix.php?id=29864&r=dst
IIS Stability:               http://bugs.php.net/fix.php?id=29864&r=isapi
Install GNU Sed:             http://bugs.php.net/fix.php?id=29864&r=gnused
Floating point limitations:  http://bugs.php.net/fix.php?id=29864&r=float

Reply via email to