php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #2524 OCILogon/OCILogoff leaves oracle zombie processes
Submitted: 1999-10-14 12:08 UTC Modified: 2006-07-17 08:06 UTC
From: doussot at gifrance dot com Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0 Latest CVS (14/10/1999) OS: Linux 2.2
Private report: No CVE-ID: None
 [1999-10-14 12:08 UTC] doussot at gifrance dot com
Configuration: Apache 1.3.9, PHP4 (CVS), Linux 2.2, Oracle 8i. All running on the same computer.

The script:

<?
Header("content-type: image/jpeg");

$conn = OCILogon('yann', 'yann');
$stmt = OCIParse($conn, "SELECT getBlob FROM dual");
OCIExecute($stmt);
OCIFetchInto($stmt, &$arr, OCI_ASSOC);
echo $arr["GETBLOB"]->load();
OCIFreeStatement($stmt);
OCILogoff($conn);
?>

works very well (display a blob), but *sometime* it leaves an oracle zombie
process in the system:

oracle   10123  2.0  0.0     0    0 ?        Z    18:06   0:00 [oracle <defunct>
oracle   10124  2.0  0.0     0    0 ?        Z    18:06   0:00 [oracle <defunct>
oracle   10125  2.0  0.0     0    0 ?        Z    18:06   0:00 [oracle <defunct>
oracle   10126  3.3  0.0     0    0 ?        Z    18:06   0:00 [oracle <defunct>
oracle   10127  3.3  0.0     0    0 ?        Z    18:06   0:00 [oracle <defunct>

May be it's an Oracle bug, I can't try another for the moment.

Thanks.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-11-11 17:14 UTC] doussot at gifrance dot com
I've tried with PHP3 cvs and OCI7 API and have the same problem. 
Could somebody give a try on another platform ?
 [2000-07-11 05:51 UTC] thies at cvs dot php dot net
please use the --enable-sigchild configure switch
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 13:01:31 2024 UTC