ID: 9852 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: IIS related Operating System: Windows 2000 PHP Version: 4.1.1 New Comment:
It seems to be a timing problem (the PHP script outruns the IIS/MSSQL or something). I came up with a simple solution to this by inserting a short delay before every location header in my scripts. I successfully made the workaround by using a function from a user comment on the http://www.php.net/manual/en/function.usleep.php page The function was: ------------------------------ function usleepWindows($usec) { $start = gettimeofday(); do { $stop = gettimeofday(); $timePassed = 1000000 * ($stop['sec'] - $start['sec']) + $stop['usec'] - $start['usec']; } while($timePassed < $usec); } ------------------------------ Every header call should then look like this: ------------------------------ usleepWindows(200000); header("Location: http://www.myserver.dk/mypage.php";); exit; ------------------------------ /watson Previous Comments: ------------------------------------------------------------------------ [2002-04-22 16:36:05] [EMAIL PROTECTED] I tried to use both a MySQL and a MSSQL database server on the same machine. When using the MySQL database there where no problem, and when using the MSSQL database the problem was there. So the problem seems to follow the combination of: IIS and MSSQL. I have seen this error on all the PHP versions that I tried, and that is: PHP 4.0.6, PHP 4.1.1 and PHP 4.1.2. I don't know if it's in any other PHP versions besides that. ------------------------------------------------------------------------ [2002-03-27 13:16:00] [EMAIL PROTECTED] I can reproduce the problem with a simple "bounce" page (used for measuring roundtrip times). With two active browser windows requesting the same page, I see this error repeat (apparently at random) on one out of 10-40 thousand requests. This is with PHP 4.1.2 on Windows 2000 Professional w/ IIS 5 and all the current updates from Windows Update. bounce.php ---------- <html> <head> <title>BOUNCE</title> <?php list($usec, $sec) = explode(" ",microtime()); $now = intval(1000*((float)$usec + (float)$sec)); $i = (isset($i) ? $i : 0); $n = (isset($n) ? $n : 10); $s = (isset($s) ? $s : 0); $r = (isset($r) ? $r : 0); ?> <?php if (0 == $i) { ?> <meta http-equiv="Refresh" content="0; URL=bounce.php?s=<?= $s ?>&r=<?= $r ?>&i=1&t=<?= $now ?>"> <?php } else if ($i < $n) { ?> <meta http-equiv="Refresh" content="0; URL=bounce.php?s=<?= $s ?>&r=<?= $r ?>&i=<?= 1 + $i ?>&t=<?= $t ?>"> <?php } else { ?> <?php $e = $now - $t; $r = $r + $n; $s = $s + $e; ?> <meta http-equiv="Refresh" content="3; URL=bounce.php?s=<?= $s ?>&r=<?= $r ?>"> <?php } ?> </head> <body> <?php if ($i < $n) { ?> <h1>BOUNCING</h1> <?php } else { ?> <h1>BOUNCE</h1> <table border=1> <tr><th>milliseconds</th><th>requests</th></tr> <tr><td><?= intval($e/$n) ?></td><td><?= $n ?></td><td>latest</td></tr> <tr><td><?= intval($s/$r) ?></td><td><?= $r ?></td><td>cumulative</td></tr> </table> <?php } ?> </body> </html> ------------------------------------------------------------------------ [2002-01-16 13:45:10] [EMAIL PROTECTED] I have tried this with W2K server and php 4.1.1 and I am getting the same problem. Its taken a while and in fact it was only when pointed at this bug request that the answer was apparent. My problem was it wasnt constant, it was intimittent, so, I assumed my server was crud. I actually had rulled out a PHP bug coz it works fine on my portable (W2K pro) every time, but under server .. no.. Although my server does also farm hits to the company intranet so is generally under a lot more stress than my portable. I will continue further tests to see if doing includes takes the problem away, as certainly, it seems the javascript of window.location= seems to be fine. I assume PHP is being too fast for itself? ------------------------------------------------------------------------ [2002-01-12 06:58:59] [EMAIL PROTECTED] Can you try this with 4.1.1? There been alot of fixes for IIS in the recent versions. ------------------------------------------------------------------------ [2001-03-19 22:41:31] [EMAIL PROTECTED] Under the category of "You Can Never Have Too Much Information On A Bug", here is my experience with the "CGI App Misbehaved" bug (related bug reports: #8571 and #8744). Bug report summary: A PHP script that sends a 'Location' header directive and makes a database connection causes IIS to intermittently return a 'Gateway Error 502' when the client browser asks for the page specified in the redirect. The address bar will correctly show the page that should have loaded when the error is displayed, and pressing F5 (refresh) will correctly load the page. Note that the error is (seemingly) completely random, sometimes you get it, other times the script works correctly. The error message text is: -- Begin -- CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: -- End -- This error depends on: 1) Using PHP in CGI mode (i.e. using php.exe, the ISAPI dll does not seem to produce this error, although it has it's own problems). 2) A PHP script that connects to a database (tested both mssql_connect and odbc_connect) *and* sends a 'Location:' header. If the script redirects to something other than a .php file (i.e. .html or .pdf) or does not connect to the database, the error will not occur. 3) A successful db connection. If the db connect call fails (due to bad password, etc.), the redirect always works. This error does *not* depend on: 1) A fully qualified 'Location' header. The following also fails: header('Location: http://10.0.0.30/test/done.php'); 2) The relative order of the header() and xxx_connect() calls in 'doit.php'. I wouldn't expect the order to affect the result, but I checked it anyway. Interesting note: While upgrading the server to SP1 to see if it had any affect on this bug, I continued to test while it was in the process of performing the upgrade. It was very difficult (I gave up) trying to get the error. The CPU was at 100% due to the upgrade which (obviously) caused the web server performance to suffer. Combined with the fact that it occurs randomly anyway, this suggests that it may have something to do with the timings between the request for doit.php, execution of doit.php, and the request for done.php. Hardware/Software: Web server: Win2000 Server (with and without SP1) IIS 5.0 PHP 4.0.4pl1 (CGI mode) Database server: WinNT 4.0 SP6 MS-SQL 7.0 Client: Win2000 Professional SP1 IE 5.5 SP1 ======================================== Test scripts ======================================== start.php ---------------------------------------- <html><head><title>Test</title></head> <body> <a href="doit.php">Do test</a> </body></html> ---------------------------------------- doit.php ---------------------------------------- <?php // Either connect line will cause the error $conn = mssql_connect('host', 'uid, 'pwd') or die("couldn't connect"); //$conn = odbc_connect('dsn', 'uid', 'pwd') or die("couldn't connect"); header('Location: done.php'); ?> ---------------------------------------- done.php ---------------------------------------- <html><head><title>Test</title></head> <body> Test complete <p><a href="start.php">Reset test</a> </body></html> ======================================== Here are actual HTTP headers recorded using a packet sniffer: ======================================== Scenario #1 - CGI Error Occurs ======================================== Client request ---------------------------------------- GET /test/doit.php HTTP/1.1 Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/msword, */* Referer: http://10.0.0.30/test/start.php Accept-Language: en-us Accept-Encoding: gzip, deflate User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Host: 10.0.0.30 Connection: Keep-Alive ---------------------------------------- Server response ---------------------------------------- HTTP/1.1 302 Object Moved Location: done.php Server: Microsoft-IIS/5.0 Content-Type: text/html Connection: close Content-Length: 131 ---------------------------------------- Client request (automatic IE request) ---------------------------------------- GET /test/done.php HTTP/1.1 Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/msword, */* Referer: http://10.0.0.30/test/start.php Accept-Language: en-us Accept-Encoding: gzip, deflate User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Host: 10.0.0.30 Connection: Keep-Alive ---------------------------------------- Server response (Incorrect response) ---------------------------------------- HTTP/1.1 502 Gateway Error Server: Microsoft-IIS/5.0 Date: Tue, 20 Mar 2001 00:30:10 GMT Connection: close Content-Length: 215 Content-Type: text/html ---------------------------------------- Client request (F5 - refresh) ---------------------------------------- GET /test/done.php HTTP/1.1 Accept: */* Referer: http://10.0.0.30/test/start.php Accept-Language: en-us Accept-Encoding: gzip, deflate User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Host: 10.0.0.30 Connection: Keep-Alive ---------------------------------------- Server response ---------------------------------------- HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Tue, 20 Mar 2001 00:30:11 GMT Connection: close X-Powered-By: PHP/4.0.4pl1 Content-type: text/html ======================================== ======================================== Scenario #2 - Correct operation ======================================== Client request ---------------------------------------- GET /test/doit.php HTTP/1.1 Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/msword, */* Referer: http://10.0.0.30/test/start.php Accept-Language: en-us Accept-Encoding: gzip, deflate User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Host: 10.0.0.30 Connection: Keep-Alive ---------------------------------------- Server response ---------------------------------------- HTTP/1.1 302 Object Moved Location: done.php Server: Microsoft-IIS/5.0 Content-Type: text/html Connection: close Content-Length: 131 ---------------------------------------- Client request (automatic IE request) ---------------------------------------- GET /test/done.php HTTP/1.1 Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/msword, */* Referer: http://10.0.0.30/test/start.php Accept-Language: en-us Accept-Encoding: gzip, deflate User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Host: 10.0.0.30 Connection: Keep-Alive ---------------------------------------- Server response (Correct response) ---------------------------------------- HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Tue, 20 Mar 2001 00:33:02 GMT Connection: close X-Powered-By: PHP/4.0.4pl1 Content-type: text/html ======================================== ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=9852&edit=1
