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

hmm i "only" have 8.0.5.x - and that does not leave zombies... i might be able to install 8.1.5 later tc On Fri, 12 Nov 1999, Yann Doussot wrote: > 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 > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany