Re: [PHP4BETA] ups, sorry

From: Date: Thu, 10 Feb 2000 06:15:54 +0000
Subject: Re: [PHP4BETA] ups, sorry
References: 1 2  Groups: php.version4 
Request: Send a blank email to php-version4+get-10006@lists.php.net to get a copy of this message
OK, here is more detail. Basically I found that a script that was using ODB C was running, completing (it's output to the screen), but the browser was s till busy doing something (both Netscape and IE exhibited this problem). I had to hit the stop button. Here is a simplified script that was causing th e problem: <? $conn = odbc_connect("TIME","","", SQL_CUR_USE_IF_NEEDED); $rs = odbc_exec($conn, "select * from Clients"); $fields = array(); $r = odbc_fetch_into($rs, 1, &$fields); // odbc_free_result($rs); odbc_close($conn); ?> <H1>ODBC Test</H1> I've commented out the odbc_free_result call. With this line commented out the script will hang. The side effect of letting it run too long is you wil l get a 409 error. See below. If I make the explicit call to odbc_free_result the script runs fine. So, I haven't looked at the odbc source code, but perhaps some garbage collection is running but there is a bug and it hangs???? Hope this info helps. Gerry High ===ERROR 409==== The page cannot be displayed There are too many people accessing the Web site at this time. ---------------------------------------------------------------------------- ---- Please try the following: Click the Refresh button, or try again later. Open the localhost home page, and then look for links to the information you want. HTTP 403.9 - Access Forbidden: Too many users are connected Internet Information Services ---------------------------------------------------------------------------- ---- ----- Original Message ----- From: "Zeev Suraski" <zeev@zend.com> To: "Gerry High" <ghigh@hightg.com>; <php4beta@lists.php.net> Sent: Wednesday, February 09, 2000 4:53 PM Subject: Re: [PHP4BETA] ups, sorry > At 00:41 10/02/2000 , Gerry High wrote: > >OK, thanks. > > > >I am now using your latest compile of the isapi component, but it is prov ing > >to be unusable. On Windows 2000 with IIS5 it basically kills IIS after o pen > >ing a few php pages. I have to stop/restart W3SVC to get it back working ag > >ain. > > Does it run a few queries and then crash? Regardless of the pages in > question, or does it fail on specific pages? Random reports like this > really don't help (since we can't have the slightest idea on what's wrong) . > > Zeev > -- > Zeev Suraski <zeev@zend.com> http://www.zend.com/

« previous php.version4 (#10006) next »