Re: PHP 4.0 Bug #2524 Updated: OCILogon/OCILogoff leaves oracle zombie processes

On Fri, 12 Nov 1999, Thies C. Arntzen wrote: > what versions are u using: > > - linux Tried kernel 2.2.13, 2.3.26. Debian potato system: glibc 2.1.2 > - oracle Oracle 8.1.5 standard edition > - apache 1.3.9 PHP3 CVS or PHP4 CVS as Apache module > and how is everything configured? > > could you send me a short php-snipped that reproduces this? <? $conn = OCILogon('yann', 'yann'); $stmt = OCIParse($conn, "SELECT SYSDATE FROM dual"); OCIExecute($stmt); OCIFetchInto($stmt, &$arr, OCI_ASSOC); echo $arr["SYSDATE"]; for ($i=0; $i<100000; $i++) {}; ?> If you reload the page while the apache process is running the for (), you immediately have the oracle zombie (ok the for is stupid, but you can achieve the same with a long running Oracle query). A reload of apache removes all zombie. > > i should be able to get 8i up and running on my system here, then i might > be able to help you! If it helps, I can problably give you access to either the database or the server -- Yann Doussot <doussot@gifrance.com> Grey Interactive - France - http://www.gifrance.com/ Cell: +33 6 12 71 70 03 Work: +33 1 46 84 85 00