Script Timeout Problem on Windows 2000

[Catka]

If you ever find a solution please share as I also have the same annoying timeouts on a Win2k server with IIS. Service pack and all the latest versions of MySQL, PHP and such.

I originally was also running a graphical chat world on the same server (with MSsql) and thought perhaps the combination might in some way be lagging things enough that php or mysql timed however even moving the chat to a dedicated server I still have the timeouts occasionally.

[Mr Chunder]

Actually, you can also eliminate the error message by setting the CGI timeout value in IIS5,

goto: properties -> home dir -> configuration -> process options

Ok, so you can remove the error message but the default is 300 seconds so why on earth is a php cgi process taking at least 300 seconds to execute ?

Surely something else is wrong? I have 3 slow queries per day marked in the mysql logs and about corresponding 15 timeouts reported by IIS.

No script should take this long.....

I found a similar report on a php board a while ago and the solution was to move to a new server !

This is one of those problems that I'll never solve.........

[Rostor]

I continue to had this problem

I'm trying this way:

set_time_limit(25); 

put this code in the first lines of global.php

<?php
error_reporting(7);
set_time_limit(25);

I'v got a W2k Server SP2 + last security Fix, PHP 4.1.1, IIS5, MySQL 3.23.48.
Don't say it's IIS that doesn't work pls

[Mr Chunder]

But is it IDE or SCSI ? WE get up to get members on our board and the server is shared with a SQL server based website and other smaller websites / applications but its on a dual 1.2 and CPU never goes above 10%. Fragmentation is close to zero so there is no reason for MYsql to run slowly other than disk contention. I do have dual disks with MYsql on the C drive and SQLSErver on the D drive but I'm wondering if my IDE system cannot cope ?

Otherwise it is a mystery.

[Scott MacVicar]

I've not had any problems with my Win2k Version, i'm using service pack 2 + the hefty 17mb security patch.

PHP 4.1.1 ISAPI and MySQL 4.01 along with Apache 1.3.22

Runnin a Athlon 1.8 XP+
512mb DDR RAM
2 x 20GB IBM 7200rpm

Its only my development board, and we can have around 10 people on at the same time workin on modifications etc and I ain't had any problems at the moment.

[Mr Chunder]

Originally posted by MiF
I made a post a day or two ago about timeouts I have been experiencing during replying. (newreply.php)

My host is running unix. So I doubt it's Win2K related. I think it's database related because when I get the timeouts I can still browse the forums in a difeerent window. More specifically some code in newreply.php

They are intermittent too. I can reply to messages then then suddenly it will start timing out. Eventually I can post a reply after several retries. Usually about 5 mins later.

However, since my post a day or two ago I have not experienced this problem.

Sounds like a cross platform problem. I am wondering whether it is to do with IDE disks and a possible disk clash since I have it on the C drive of an IDE based server that is sharing with SQLServer and other apps.

Is you linux box IDE based or SCSI ?

[MiF]

I made a post a day or two ago about timeouts I have been experiencing during replying. (newreply.php)

My host is running unix. So I doubt it's Win2K related. I think it's database related because when I get the timeouts I can still browse the forums in a difeerent window. More specifically some code in newreply.php

They are intermittent too. I can reply to messages then then suddenly it will start timing out. Eventually I can post a reply after several retries. Usually about 5 mins later.

However, since my post a day or two ago I have not experienced this problem.

[Mr Chunder]

Still got the problem. I have moved the forums website into its own IIS process space and this seems to reduced the change of forums going wrong and taking out the other websites on the server. This is what you are supposed to do anyway but I missed this !

But what causes the actual timeout has done me. There are slow queries reported in mysql which could be responsible.

[Rostor]

The same problem here I'm working to undestand how to stop this timeout.

[Mr Chunder]

Hi willyjb, long time no talk...

Have you had any other ideas?

I've still got this problem with the timeouts but it is getting worse. Every now and then, I get about 10 of these timeouts occuring over a 1 second interval. Sometimes, during this period, it locks up the entire webserver taking out other functions. Not too good eh ?

Has anyone else had this problem ?

[Mr Chunder]

Great huh?

Well we still have the same problem regarding the timeout. I said that I would concentrate on mysql but this problem is lower in the priorities.

Like I said in the PM, I reckon Mysql is jamming up at certain times causing the server to terminate scripts. The question is whats wrong with mysql ?

Let you know how I get on once I get round to it

At least you've made some progress !

[willyjb]

mem leak fixed

Sigh - it is always the unexpected. When I moved the vBB to my new W2K server I installed Roxio (Adaptec) GoBack. I use it on my test server and it works great at allowing you to try something then 'Undo' it. however, in a production environment, you get a major memoryleak!

So disabled GoBack - memory leak gone. The timeout problem is still there.

[willyjb]

Hi - well, I am still working on it, it is a priority. The PHP 4.0.4 did not solve either the timeout problem or the bigger problem for me, the memory leak. However I did realize that probably before, on NT 4.0, I was not logging the timeout events to the event log, whereas with the new installation I was. So it may not be something new, just wasn't noticed before.

BTW, I noticed a setting in php.ini timeout = 30 (seconds)

Early this morning I switched back to PHP 4.0.6 and switched to MySQL 3.23.37. It is too early to tell yet whether that will have an effect on the memory leak.

I am surprised that you are not finding a memory leak any more, weird. I do think you have to look at the overal "Mem Usage", not just dllhost. Lost memory does not showup in any particular programs usage.

[Mr Chunder]

Howsit going willyjb ?

I've noticed just recently that I'm only getting two of these timeouts a day now and memory has virtually stopped leaking in dllhost.

I've done absolutely nothing so can't work it out.

How are you doing ?

[willyjb]

Well, the ISAPI experiment didn't go well at all, almost immediately hung IIS. I am now trying php 4.04., we'll see, I am not too optimistic, but I need to find a solution.