Yes, I am accessing the script through a browser. I am not using, flush(), but ob_flush() to send data straight back to the browser as it is collected. However, in this case, php exits before the query has completed so there is no data to send (the query last for 24m, but php exits after 6m). The web servers CGI timeout, if this is the same as Website->Properties->[don't-remember-tab-name]->timeout, is set to don't-remember-the-value-but-something-sufficient-high. I am also pretty sure about that the web server is set to sends keep alive message to the client, since I did review the server settings today and saw something saying so. But never say never. I will review them again, just to be 100% sure, when I am back at work tomorrow. I have to say I really hope it the IIS setting that is screwed up, otherwise I am in deep shit, since I have no clue on to what's going on right now. -- P.S. To PHP readers: if you CC to syp@yahoogroups.com, you will get a bounce, since that is a closed, private, member-only, e-mail list which only registered member are able to post to. I am sorry for the inconvenience. D.S. -----Original Message----- From: Frank M. Kromann To: Svensson, B.A.T. (HKG) Cc: 'syp@yahoogroups.com'; 'php-windows@lists.php.net' Sent: 2004-01-06 23:30 Subject: Re: Why does php exit after 6 minutes? Hi, Iøm asuing you are accessing the script through a browser ? There is sevral time out values that you should be aware of. PHP's timeout, The database timeout, The web servers CGI timeout and the connection time out between the browser and the web server. The first two seams to be set correct, the web servers time out is configured under IIS and would normally be 900 seconds. The only way to get arround the browser time out would be to keep sending content from the server to the browser. Make sure you use flush() after each print so data is transfered right away. - Frank > * CONFIG: > > PHP version 4.3.4 > IIS version 6.0 > MS SQL server 2000 > Windows 2003 server - dual Pentium > > phpinfo(): safe_mode: off > phpinfo(): max_execution_time: 1800s > phpinfo(): mssql.timeout: 1800s > > IIS: website script execution time: f.a.p.p. unlimited > IIS: website sessions: keep alive. > > RDBMS: query execution time: unlimited > > > * WHAT HAPPENED: > > while running a long running query php.exe is visible > in the task manager for 6 minutes, then it dies with > out telling anything - what so ever! > > * DISCUSSION: > > This query works just fine if the query process data quickly, > let say in about 30 to 60 seconds, but when the query needs > to be processing data for ~25 minutes, php will exits after > six minutes and then the database seams then to be doing a > rollback for the next 20 minutes or so on the transactions > made by the php connection. > > Before php exits the RDBMS responds normal - but has a CPU > load of 100%. After php exits the RDBMS does not respond any > more or respond very sluggish. I can see no kind of I/O > activities with the RDBMS, only 100% CPU load. The RDBMS > keeps in this state for about 20-30 minutes, then the RDBMS > goes back to normal operation again. > > Any suggestion on what might be going on here is welcome. > > > -- > > To readers of SYP@yahoogroups.com: > > Ursakta engelskan. > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
