ID: 29652
Updated by: [EMAIL PROTECTED]
Reported By: yannick at agl dot fr
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Linux Redhat 7.3
PHP Version: 4.3.7
New Comment:
Tested under Linux with Oracle 9.2.0.1, Apache 1.3.31 and latest PHP5 &
PHP4 versions.
Cannot reproduce your situation - there is still only one ocius.msb's
descriptor.
Plz, provide more info about software installed - versions of Oracle,
Apache etc.
Previous Comments:
------------------------------------------------------------------------
[2004-08-17 11:34:14] yannick at agl dot fr
Yes the limit of FD is exceeded...
This issue occurs only with php not with JDBC under OCI.
------------------------------------------------------------------------
[2004-08-17 07:38:36] [EMAIL PROTECTED]
So, what the problem with it? It exceedes your FD limit?
It's most likely to be an OCI trouble, 'cos PHP knows nothing about
ocius.msg.
------------------------------------------------------------------------
[2004-08-16 10:15:35] yannick at agl dot fr
the number of FD is growing constantly for each child.
for example:
>ps -ef | grep httpd
root 469 1 0 Aug05 ? 00:00:00
/usr/local/apache/bin/httpd -f /
web 6853 469 0 07:57 ? 00:01:09
/usr/local/apache/bin/httpd -f /
web 7035 469 0 08:02 ? 00:00:18
/usr/local/apache/bin/httpd -f /
web 7138 469 0 08:07 ? 00:00:25
/usr/local/apache/bin/httpd -f /
web 8408 469 0 08:52 ? 00:00:21
/usr/local/apache/bin/httpd -f /
web 8428 469 0 08:53 ? 00:00:17
/usr/local/apache/bin/httpd -f /
web 8429 469 0 08:53 ? 00:00:17
/usr/local/apache/bin/httpd -f /
web 10107 469 0 09:54 ? 00:00:04
/usr/local/apache/bin/httpd -f /
web 10402 469 0 10:05 ? 00:00:01
/usr/local/apache/bin/httpd -f /
web 10413 469 0 10:06 ? 00:00:01
/usr/local/apache/bin/httpd -f /
web 10626 469 1 10:11 ? 00:00:00
/usr/local/apache/bin/httpd -f /
web 10630 469 0 10:11 ? 00:00:00
/usr/local/apache/bin/httpd -f /
web 10631 469 0 10:11 ? 00:00:00
/usr/local/apache/bin/httpd -f /
web 10661 469 0 10:12 ? 00:00:00
/usr/local/apache/bin/httpd -f /
number of child: 14
> cd /proc/7035/fd
> ls -l |grep ocius |wc
> 235
i think each request make a new FD...
------------------------------------------------------------------------
[2004-08-13 17:36:12] [EMAIL PROTECTED]
Does it grow constantly or it stops after reaching the number of apache
childs?
Can you please try the same with OCINLogon ?
Btw, ocilogoff() does nothing for a long time (connections are closed
by Oracle after a timeout).
------------------------------------------------------------------------
[2004-08-13 15:54:06] yannick at agl dot fr
Description:
------------
i see the number of file descriptor to ocius.msg is growing for each
apache child. so i reproduce problem with this script.
Reproduce code:
---------------
<?
while (1) {
$conn=OCILogon($username,$password,$database);
$stmt=OCIParse($conn,"select 50 as toto from dual");
OCIDefineByName($stmt,"TOTO",&$total);
OCIExecute($stmt);
OCIFetch($stmt);
echo ":::$total:::\n";
OCILogoff($conn);
OCILogoff($conn);
sleep(10);
}
?>
Expected result:
----------------
1 file descriptor to ocius.msg
1 connection to database
Actual result:
--------------
the number of file descriptor to ocius.msg is growing.
1 connection to database
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=29652&edit=1
