Re: postgresql idle

From: Michael Chaney <mdchaney(at)michaelchaney(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql idle
Date: 2004-04-22 14:25:56
Message-ID: 20040422142556.GE3433@michaelchaney.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 21, 2004 at 09:12:27PM -0400, Jon Pastore wrote:
> This perl script is designed to handle payment posting for an application we
> developed. It runs fine on our development server which is running apache
> 1.3.27 on ES 2.1
>
> on the production server the script hangs and we see the above msg in "ps
> aux"
>
> we wrote a wrapper for the program that will exec it from the command line
> and everything runs a-o-k
>
> has anyone else encounted something like this? should I downgrade the
> installation of apache?

It's a Perl script, so why aren't you concerned about the Perl version?
If you can run it through the Perl debugger, you should be able to see
where it's hanging. That's probably your best course of action.
Barring that, start putting some printf's in there to see where it's
hanging.

Michael
--
Michael Darrin Chaney
mdchaney(at)michaelchaney(dot)com
http://www.michaelchaney.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2004-04-22 14:26:06 Re: What is wrong here?
Previous Message Michael Chaney 2004-04-22 14:18:20 Re: Replication