This may be totally unrelated, but I had a problem that I ultimately
solved by setting up a PerlChildInit handler to open DB connections for
each child explicitly. For some reason it seemed like only one
connection was being opened to connect to the MSSQL DB and that single
connection was somehow
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
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
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
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
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
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
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
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
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
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
11 matches
Mail list logo
