From: michel02 at hotmail dot com Operating system: Sun Solaris 2.7 PHP version: 4.3.6 PHP Bug Type: Oracle related Bug description: ghost processes <defunct> appearing after correct oracle login - logout
Description: ------------ When connecting/disconnecting to oracle with each (successfull) ora_logon session after decent logoff an additional ghost process called <defunct> will appear. After serving several pages these processes will appear in huge numbers. Only after Apache shutdown these processes are dissapearing. PHP is compiled with: LD_LIBRARY_PATH=/usr/local/lib:/usr/local/ssl/lib ./configure --prefix=/usr/local/php-4_3_6 --with-apxs2=/export/home/local/apache_2_0_48/bin/apxs --with- oracle=/export/home/oracle/product/7.3.4 --with-openssl=/usr/local/ssl --enable-ftp --enable-sigchild OS: Sun Solaris 2.7 ORACLE version = 7.3.4 PHP version = 4.3.6 Apache version 2.0.48 When using PHP3 these ghost processes are not appearing is not the case. Is there a solution? Maybe it is a bug of php4? Reproduce code: --------------- <?php // ORACLE Login function Login() { $oracle_conn = ora_logon('oracle_username', 'oracle_passwd'); if(!$oracle_conn) { Error("Can't connect to database."); } ora_commitoff($oracle_conn); $oracle_curs = ora_open($oracle_conn); } // ORACLE Logout function Logout() { if ($oracle_conn) ora_logoff($oracle_conn); if ($oracle_curs) ora_close($oracle_curs); } Login(); Logout(); ?> Expected result: ---------------- a normal login and logout to oracle, no additional ghost processes appear in the ps -ef|grep defunct list. Actual result: -------------- each time code is run a new <defunct> ghost process is started: ps -ef|grep def root 419 406 0 0:00 <defunct> oracle 27661 27579 0 0:00 <defunct> oracle 27595 27579 0 0:00 <defunct> oracle 27663 27579 0 0:00 <defunct> oracle 27659 27579 0 0:00 <defunct> root 27672 718 0 00:09:04 pts/1 0:00 grep def oracle 27670 27579 0 0:00 <defunct> oracle 27662 27579 0 0:00 <defunct> oracle 27669 27579 0 0:00 <defunct> oracle 27660 27579 0 0:00 <defunct> oracle 27584 27579 0 0:00 <defunct> oracle 27668 27579 0 0:00 <defunct> oracle 27585 27579 0 0:00 <defunct> etc., etc.. -- Edit bug report at http://bugs.php.net/?id=28224&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=28224&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=28224&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=28224&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=28224&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=28224&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=28224&r=needscript Try newer version: http://bugs.php.net/fix.php?id=28224&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=28224&r=support Expected behavior: http://bugs.php.net/fix.php?id=28224&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=28224&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=28224&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=28224&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28224&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=28224&r=dst IIS Stability: http://bugs.php.net/fix.php?id=28224&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=28224&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=28224&r=float