Hi, > -----Oprindelig meddelelse----- > Fra: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]] > Sendt: 3. februar 2003 13:03 > Til: Henrik Hornemann; [EMAIL PROTECTED] > Emne: RE: [PHP-WIN] two questions: error_log and timeout > > > Q&A 1: Have you checked the file in a hex editor/viewer? > Wordpad helped :)
> Q&A 2: Three solutions > > 1) speed optimize your queries (check all full table scans etc) > 2) increase the time out limitation > 3) get faster hardware > > In addition you might want to check weather this always happens > for single specific queries. If this is the case you might want > to verify that the result set returned confirms to the spec. > > Since you provides with sparse information on what you actually > are doing it is hard to judge on network related issues, but if > you can't find any particularly reason for network errors, then > you might want to check packets routing on the network, sometimes > your route map might be obscured and packages sent to routers that > knows absolutely nothing about the network, and hence you will be > waiting forever for an answers. > > > //Anders > What im doing is parsing a monster textfile and writing the results to an ms-sql database. Im sure the code could be optimized, but it is rather complicated and not very high on the priority list. The time-out limit is 600 secs standard, which is allways higher than the execution time for the script. When it times out it is newer in the same place, judging from the output. Sorry, I only gave half the errormessage last time, the full message is: HTTP/1.1 502 Gateway Error Server: Microsoft-IIS/5.0 Date: Tue, 28 Jan 2003 11:04:40 GMT Connection: close Content-Length: 186 Content-Type: text/html CGI Timeout The specified CGI application exceeded the allowed time for processing. The server has deleted the process. regards Henrik > > > -----Original Message----- > > From: Henrik Hornemann [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 03, 2003 12:39 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-WIN] two questions: error_log and timeout > > > > > > Hi all, > > > > I hope you can help me. > > I'm running php 4.3 as ISAPI under IIS on Windows 2000, SP3 > MS-SQL Server > > 2000, SP2. > > > > I have these two problems that has been bugging me for some time: > > > > I'm logging php errors and warnings to a log file. But > mostly there are no > > line breaks in the resulting file, which makes scanning the > file very > > dificult. > > Is there a way to force line breaks in the error log? > > > > My second problem is a script that once in a while returns > a time-out error, > > usually after having run for about 5 min. But not always. > > My standard timeout for php is set to 600 sec. And the > script in question > > starts with set_time_limit(0); Any idea on how to pinpoint > the problem? > > The exact error message i get is: > > > > CGI Timeout > > The specified CGI application exceeded the allowed time for > processing. The > > server has deleted the process. > > > > This error, by the way, is not written to the error log. > > > > Tia Henrik Hornemann > > > > > > > > > > -- > > 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
