RE: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-06 Thread Adam Prime x443
x27;d mention it. Adam -Original Message- From: Jeremy Wall [mailto:[EMAIL PROTECTED] Sent: Friday, March 02, 2007 4:05 PM To: modperl@perl.apache.org Subject: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests Hello, This is my first posting to the mod

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-05 Thread Jonathan Vanasco
On Mar 5, 2007, at 4:16 PM, Perrin Harkins wrote: I'm no Postgres expert, but I don't think a SELECT should block an UPDATE in an MVCC database system unless the first statement is a SELECT FOR UPDATE or similar. Maybe if you use an isolation level of REPEATABLE READ. Yeah. I think the sys

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-05 Thread Jeremy Wall
On Monday 05 March 2007 15:08, Jonathan Vanasco wrote: > On Mar 5, 2007, at 3:40 PM, Perrin Harkins wrote: > > Look for things that use locking. Anything that updates a file or a > > database row. In particular, look for things that do this and would > > happen on every type of request that you'v

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-05 Thread Perrin Harkins
On 3/5/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: I recently had this code in my system handle 1- select * from account where id = 1; handle 2- update visit set visit_count= visit_count+1 where account_id = 1; # account_id fkeys on account it took me forever to

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-05 Thread Jonathan Vanasco
On Mar 5, 2007, at 3:40 PM, Perrin Harkins wrote: Look for things that use locking. Anything that updates a file or a database row. In particular, look for things that do this and would happen on every type of request that you've seen hanging so far. As a note, you could run into blocks/loc

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-05 Thread Perrin Harkins
On 3/5/07, Jeremy Wall <[EMAIL PROTECTED]> wrote: The requests are still handled by a response handler. The requests in question however were basically just sending an html page or a template with no template tags in them so no logic was involved except for validating their login information. T

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-05 Thread Jeremy Wall
On Monday 05 March 2007 13:35, Perrin Harkins wrote: > On 3/5/07, Jeremy Wall <[EMAIL PROTECTED]> wrote: > > I get 16 timeouts out of a total of 3402 requests in the forensic log for > > a half day of traffic. Some of the requests are strait pass a file on > > with no logic. > > On those, do you ha

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-05 Thread Perrin Harkins
On 3/5/07, Jeremy Wall <[EMAIL PROTECTED]> wrote: I get 16 timeouts out of a total of 3402 requests in the forensic log for a half day of traffic. Some of the requests are strait pass a file on with no logic. On those, do you have any auth handlers, session activity, etc? If there's no mod_per

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-05 Thread Jeremy Wall
On Friday 02 March 2007 23:40, Perrin Harkins wrote: > On 3/2/07, Jeremy Wall <[EMAIL PROTECTED]> wrote: > > I'm using a mod_perl response handler for the pages in question. > > Periodically and with no pattern I can detect a page request will simply > > timeout. > > If you want to know whi

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-03 Thread Jeremy Wall
On Friday 02 March 2007 23:40, Perrin Harkins wrote: > On 3/2/07, Jeremy Wall <[EMAIL PROTECTED]> wrote: > > I'm using a mod_perl response handler for the pages in question. > > Periodically and with no pattern I can detect a page request will simply > > timeout. > > If you want to know whi

Re: Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-02 Thread Perrin Harkins
On 3/2/07, Jeremy Wall <[EMAIL PROTECTED]> wrote: I'm using a mod_perl response handler for the pages in question. Periodically and with no pattern I can detect a page request will simply timeout. If you want to know which requests do this, you can use mod_log_forensic. It sounds to m

Apache2.2 - openssl 0.9.8d - modperl 2.03 unpredictable timeouts during requests

2007-03-02 Thread Jeremy Wall
Hello, This is my first posting to the mod_perl mail list. I'm looking forward to conversing with the folks here. I'm having a problem that has me stumped. I'm running Apache 2.2 with mod_perl 2.0.3 on Windows 2000 server. Specifially the latest XAMPP distribution because it wa