ID: 29652
Comment by: esartoni at omniaglobal dot net
Reported By: yannick at agl dot fr
Status: Feedback
Bug Type: OCI8 related
Operating System: Linux Redhat 7.3
PHP Version: 4.3.7
New Comment:
Same problem here with Solaris SunOS SPARC 5.9 - Apache 1.3.29 - PHP
4.3.8 - OCI 9.2.0.1.0
The number of opened ocius.msg grows costantly reaching the fd limit.
No problem with Linux Debian, Apache 1.3.29, PHP 4.3.8 and OCI
8.1.7.0.0 or with Linux RedHat 8, Apache 1.3.26, PHP 4.3.4 and OCI
9.2.0.1.0
I'll try with an older version of php and let you know what happens.
Previous Comments:
------------------------------------------------------------------------
[2004-08-18 18:43:05] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[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).
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/29652
--
Edit this bug report at http://bugs.php.net/?id=29652&edit=1
