Page Index Toggle Pages: 1
Topic Tools
Server Timeout on large operations (Read 4,081 times)
Corey Chapman
YaBB Administrator
*****
Offline



Posts: 10,015
Location: Rock Hill, South Carolina

None
Re: Server Timeout on large operations
Reply #5 - Jan 19th, 2011 at 7:11pm
Post Tools
This Topic was moved here from YaBB 1 (Development Ceased) [move by] Corey Chapman.
  

Back to top
IP Logged
 
Homer J. S.
God Member
*****
Offline



Posts: 1,949
Location: Germany

None
Re: Server Timeout on large operations
Reply #4 - Jun 22nd, 2010 at 5:33pm
Post Tools
Well, to be honest I never thought that YaBB 1 could work that perfect although it's that big, but it does. It runs for 6 years in the actual form and before that it has been an other forum, so all in all it runs for 7 or 8 years now and has been moved to an other web hoster 3 times... never had any data loss or something. And it's still fast - faster than this Y2 here  Grin
  

My Homer is not a communist. He may be a liar, a pig, an idiot, a communist, but he is not a porn star.
www.silenthill-forum.de (YaBB 1.3.1 with 150+ mods)
www.retrogamerwelt.de (YaBB 2.5.2)
Back to top
WWWICQ  
IP Logged
 
JonB
YaBB Administrator
YaBB Next Team
Operations Team
Beta Testers
Support Team
*****
Offline



Posts: 3,768
Location: Land of the Blazing Sun!

YaBB 2.6.0
Re: Server Timeout on large operations
Reply #3 - Jun 22nd, 2010 at 5:24pm
Post Tools
I'm glad its fixed. I'm pretty sure I will be running into that kind of issue as my project gets built out. In my case the concern is complicated queries composed by 'users' unfamiliar with either the reporting tools or SQL. That's why I have been keeping notes.  Wink

Good Luck
Smiley

Edited:
it was #3 - mod_cgi on http://httpd.apache.org/docs/2.2/en/mod/core.html#timeout. (now I have put that in my notes)
« Last Edit: Jun 22nd, 2010 at 5:35pm by JonB »  

I find your lack of faith disturbing.
Back to top
IP Logged
 
Homer J. S.
God Member
*****
Offline



Posts: 1,949
Location: Germany

None
Re: Server Timeout on large operations
Reply #2 - Jun 22nd, 2010 at 2:34pm
Post Tools
It's a managed virtual server. The problem is gone now, they increased the Apache "Timeout" value to 150 seconds and with that it works... don't ask me why, as the operations often take less than 60 seconds, and with a value of 90 seconds it did not work.

Thanks for the ideas anyway  Smiley
  

My Homer is not a communist. He may be a liar, a pig, an idiot, a communist, but he is not a porn star.
www.silenthill-forum.de (YaBB 1.3.1 with 150+ mods)
www.retrogamerwelt.de (YaBB 2.5.2)
Back to top
WWWICQ  
IP Logged
 
JonB
YaBB Administrator
YaBB Next Team
Operations Team
Beta Testers
Support Team
*****
Offline



Posts: 3,768
Location: Land of the Blazing Sun!

YaBB 2.6.0
Re: Server Timeout on large operations
Reply #1 - Jun 22nd, 2010 at 3:29am
Post Tools
Hi Homer -

is this a shared webhosting server, a VPS or a dedicated server?

I have heard of this problem with PHP scripts as well. As I recall there are different 'places' where these values can be read from.  A lot of it has to do with how Apache is configured by the hostmaster. I'll have to see if I still have notes about the last time I ran across this (it was definitely PHP related -- but the same type of issue).

And yes, -- I have seen buffering routines to prevent time-outs (again in PHP) you redirect the STDOUT to an array.  I think that might be very very tricky - and I am not expert enough with Perl to suggest the method.

Could also be a sessions issue, where the server autocloses sessions after a certain amount of time (that would be TCP/IP related) basically dropping what it thinks are dead sessions. (that opinion is generalized based on my knowledge of general server systems, not the specifics of Apache).

But lets see what the answers might be...

Smiley


Edited:
it was mod_cgi #3 on http://httpd.apache.org/docs/2.2/en/mod/core.html#timeout (and I have stuck that away in my brain)
« Last Edit: Jun 22nd, 2010 at 5:33pm by JonB »  

I find your lack of faith disturbing.
Back to top
IP Logged
 
Homer J. S.
God Member
*****
Offline



Posts: 1,949
Location: Germany

None
Server Timeout on large operations
Jun 8th, 2010 at 3:49pm
Post Tools
As my board grows bigger and bigger, I get server timeouts on big operations such as the search function when searching all forums or the function "recount boards" or whatever it's called in english.

My web hoster tried to locate the problem but they can't. It seems to have something to do with the Apache "Timeout" value which kills a process if it does not give any feedback. They increased the value first from 15 to 30 seconds - that made the statistics work again (a mod), the other functions did not work. So they increased again to 90 seconds. After that again nothing worked, also not the statistics which worked with a 30 second timeout value.

I still use YaBB 1 (and no, it's no option for me to upgrade Wink ).

Please keep in mind that this problem has nothing to do with script timeouts. Perl scripts are terminated after 5 minutes if they don't finish, which is more than enough. The problem is Apaches "Timeout" value:

http://httpd.apache.org/docs/2.2/en/mod/core.html#timeout

Well, I think it is the problem. But I don't understand why the statistics worked with a value of 30 seconds and does not with a value of 90 seconds. After 40-60 seconds the browser says "page not found" and the server error log says

Quote:
[Tue Jun 08 17:47:14 2010] [warn] [client 79.240.125.158] Timeout waiting for output from CGI script /is/htdocs/wp1101426_AGYXFSQKHG/www/cgi-bin/yabb3/YaBB.pl, referer: http://www.diplompsychopath.de/
[Tue Jun 08 17:47:14 2010] [error] [client 79.240.125.158] Premature end of script headers: YaBB.pl, referer: http://www.diplompsychopath.de/


Any ideas to bypass that? Is there a simply way to let the script send some output to the server while processing to prevent from getting a timeout?

If someone wants to test it by himself, please send me a PN, I'll give you the login data for a test account then.
« Last Edit: Jun 8th, 2010 at 3:52pm by Homer J. S. »  

My Homer is not a communist. He may be a liar, a pig, an idiot, a communist, but he is not a porn star.
www.silenthill-forum.de (YaBB 1.3.1 with 150+ mods)
www.retrogamerwelt.de (YaBB 2.5.2)
Back to top
WWWICQ  
IP Logged
 
Page Index Toggle Pages: 1
Topic Tools
 
  « Board Index ‹ Board  ^Top