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:
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. Previous Comments: ------------------------------------------------------------------------ [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