> -----Original Message----- > From: Henrik Hornemann [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 03, 2003 2:04 PM > To: '[EMAIL PROTECTED]' > Subject: SV: [PHP-WIN] two questions: error_log and timeout > > > 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 :)
I prefere the look at the pure matrix using LIST with 4NT. > > 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 Interesting; I am dealing with the same problems myself. Regularly I need to parse some 3/4 of gigabytes sized text files in order to load them into a database. It's not funny I agree. Anyhow, are you doing this upload remotely? Are you able to upload locally at the server it self? > ms-sql database. Im sure the code could be optimized, but it is rather > complicated and not very high on the priority list. Is this pure inserts operations? If so, do you use bulk loads? My recommendation: parse into tab delimited formats and bulk copy the data into the corresponding tables. Anything else goes to slow. > The time-out limit is 600 secs standard, which is allways higher than the > execution time for the script. For an upload operation you should not get such an error since the upload should active all the time, unless your upload stalls by some strange reason (then you need to check the network connectivity). > When it times out it is newer in the same place, judging from the output. What output? > Sorry, I only gave half the errormessage last time, the full message is: For the time being regard that as irrelevant, since it hard to predict how fast the job will have progressed, since this is dependent on available system resources like cashed memory, pages swapped out on hard drive and other system activities, etc, etc. In short you can't predict these things, and they WILL affect your total execution time until completion. > 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. Hmmm.... So you should definitely try to increase the timeout limitation. > 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 > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
