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: Detecting Unused Variables

2007-03-05 Thread Perrin Harkins
On 2/28/07, Tyler Bird <[EMAIL PROTECTED]> wrote: I was wondering if there was some way I could run a script and have it detect all unused variables for me? No. You might be able to write a tool to do static analysis on your code using PPI (from CPAN). It's what Perl::Critic uses. - Perrin

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: mod_perl installation problem

2007-03-05 Thread Jeremy Wall
On Monday 05 March 2007 10:26, Anoop kumar V wrote: > I think I figured out the exact problem (not the solution)... apache starts > fine when forced to start on the commandline, but fails to start as a > service. SO it is not a problem of the apachemonitor per se. > > It is wierd that something sto

Re: mod_perl installation problem

2007-03-05 Thread Anoop kumar V
I think I figured out the exact problem (not the solution)... apache starts fine when forced to start on the commandline, but fails to start as a service. SO it is not a problem of the apachemonitor per se. It is wierd that something stops apache running as a service. Also it does not write any l

Re: run once at apache stop

2007-03-05 Thread Sergey Borodich
Sergey Borodich пишет: >> 2) Another way for mp2: create a cleanup handler APR::Pool::cleanup_register >> for one of the global pools. Apache2::ServerRec::pool or >> Apache2::Process::pool come to mind. > thanks for way, I try exploring it > I hope for mp1 something similar good also thanks aga

Re: run once at apache stop

2007-03-05 Thread Sergey Borodich
Torsten Foertsch пишет: > On Monday 05 March 2007 12:42, Sergey Borodich wrote: >> I need some technique what work as >> PerlRequire (or PerlPostConfigHandler) >> at apache start (it run only once) >> >> but I need similar technique for stop apache >> it must run if "apache stop" only once >> >> it

Re: Converting a String of bits into a binary number in perl?

2007-03-05 Thread Steven Lembark
-- Deepak Mallya <[EMAIL PROTECTED]> Hi, Can anyone tell me how do I convert a String of bits into a binary number in Perl For eg:- $a="100"; I want to convert this into perl's interpretation of binary no ie $a=0b100 You have to mask the value to 32 bits and then use "unpack". Issue i

Re: run once at apache stop

2007-03-05 Thread Torsten Foertsch
On Monday 05 March 2007 12:42, Sergey Borodich wrote: > I need some technique what work as > PerlRequire (or PerlPostConfigHandler) > at apache start (it run only once) > > but I need similar technique for stop apache > it must run if "apache stop" only once > > it need for cleanup shared memory be

run once at apache stop

2007-03-05 Thread Sergey Borodich
Hi, I need some technique what work as PerlRequire (or PerlPostConfigHandler) at apache start (it run only once) but I need similar technique for stop apache it must run if "apache stop" only once it need for cleanup shared memory before stop, etc and also desirably for mp1/mp2 both prompt som