#29652 [Opn]: number of FD to ocius.msg is growing
ID: 29652 User updated by: yannick at agl dot fr Reported By: yannick at agl dot fr Status: Open Bug Type: OCI8 related Operating System: Linux Redhat 7.3 PHP Version: 4.3.7 New Comment: oci library: 9.2.0.3 Previous Comments: [2004-08-23 16:08:47] esartoni at omniaglobal dot net Hey Yannick, could you please tell us what version of oci libraries are you using? With php 4.3.8 using oci 8.1.7.0.0 i have no problem at all. [2004-08-20 14:43:46] yannick at agl dot fr i tried with 4.3.8 without HAVE_OCI_9_2 there is no problem. if i defined HAVE_OCI_9_2 the issue occurs. [2004-08-20 10:26:00] yannick at agl dot fr tested with php 4.2.3 and php 5.0.1, there is no problem [2004-08-20 09:13:04] esartoni at omniaglobal dot net tony, i've already tested it with php 4.3.8 (cannot try with php 5) and with Solaris SunOS always gives the same problem. I'll try with the latest snapshot but always in the 4.x tree. [2004-08-19 12:15:52] [EMAIL PROTECTED] It would be better if you could try it with newer versions of PHP, especially latest snapshots from http://snaps.php.net. Older versions are not so important, 'cos I'm unable to fix them. 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=29652edit=1
#29652 [Fbk-Opn]: number of FD to ocius.msg is growing
ID: 29652 User updated by: yannick at agl dot fr Reported By: yannick at agl dot fr -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Linux Redhat 7.3 PHP Version: 4.3.7 New Comment: tested with php 4.2.3 and php 5.0.1, there is no problem Previous Comments: [2004-08-20 09:13:04] esartoni at omniaglobal dot net tony, i've already tested it with php 4.3.8 (cannot try with php 5) and with Solaris SunOS always gives the same problem. I'll try with the latest snapshot but always in the 4.x tree. [2004-08-19 12:15:52] [EMAIL PROTECTED] It would be better if you could try it with newer versions of PHP, especially latest snapshots from http://snaps.php.net. Older versions are not so important, 'cos I'm unable to fix them. [2004-08-19 12:06:27] esartoni at omniaglobal dot net 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. [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. 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=29652edit=1
#29652 [Opn]: number of FD to ocius.msg is growing
ID: 29652 User updated by: yannick at agl dot fr Reported By: yannick at agl dot fr Status: Open Bug Type: OCI8 related Operating System: Linux Redhat 7.3 PHP Version: 4.3.7 New Comment: i tried with 4.3.8 without HAVE_OCI_9_2 there is no problem. if i defined HAVE_OCI_9_2 the issue occurs. Previous Comments: [2004-08-20 10:26:00] yannick at agl dot fr tested with php 4.2.3 and php 5.0.1, there is no problem [2004-08-20 09:13:04] esartoni at omniaglobal dot net tony, i've already tested it with php 4.3.8 (cannot try with php 5) and with Solaris SunOS always gives the same problem. I'll try with the latest snapshot but always in the 4.x tree. [2004-08-19 12:15:52] [EMAIL PROTECTED] It would be better if you could try it with newer versions of PHP, especially latest snapshots from http://snaps.php.net. Older versions are not so important, 'cos I'm unable to fix them. [2004-08-19 12:06:27] esartoni at omniaglobal dot net 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. [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. 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=29652edit=1
#29652 [Fbk-Opn]: number of FD to ocius.msg is growing
ID: 29652
User updated by: yannick at agl dot fr
Reported By: yannick at agl dot fr
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Linux Redhat 7.3
PHP Version: 4.3.7
New Comment:
Yes the limit of FD is exceeded...
This issue occurs only with php not with JDBC under OCI.
Previous Comments:
[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=29652edit=1
#29652 [Fbk-Opn]: number of FD to ocius.msg is growing
ID: 29652
User updated by: yannick at agl dot fr
Reported By: yannick at agl dot fr
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Linux Redhat 7.3
PHP Version: 4.3.7
New Comment:
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...
Previous Comments:
[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=29652edit=1
#29652 [NEW]: number of FD to ocius.msg is growing
From: yannick at agl dot fr
Operating system: Linux Redhat 7.3
PHP version: 4.3.7
PHP Bug Type: OCI8 related
Bug description: number of FD to ocius.msg is growing
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 bug report at http://bugs.php.net/?id=29652edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29652r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=29652r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=29652r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=29652r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=29652r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=29652r=needscript
Try newer version: http://bugs.php.net/fix.php?id=29652r=oldversion
Not developer issue:http://bugs.php.net/fix.php?id=29652r=support
Expected behavior: http://bugs.php.net/fix.php?id=29652r=notwrong
Not enough info:http://bugs.php.net/fix.php?id=29652r=notenoughinfo
Submitted twice:http://bugs.php.net/fix.php?id=29652r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=29652r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29652r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=29652r=dst
IIS Stability: http://bugs.php.net/fix.php?id=29652r=isapi
Install GNU Sed:http://bugs.php.net/fix.php?id=29652r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=29652r=float
