Skip site navigation (1) Skip section navigation (2)

Re: postgresql idle

From: "Jon Pastore" <jpastore(at)idetech(dot)net>
To: "'Michael Chaney'" <mdchaney(at)michaelchaney(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql idle
Date: 2004-04-29 18:04:47
Message-ID: CEREBROjUwOm9x4nzwj00001130@cerebro.federatedfinancial.org (view raw or flat)
Thread:
Lists: pgsql-general
Thank you for your response...and you are correct that is something to be
concerned about but after much frustration we found that pgsql thought there
was a transaction in progress and was waiting for it to complete when in
fact the commit had already taken place.

What we ended up doing was after a commit or rollback we would 

undef $main::conn; 

Forcing it to reestablish a new connection for the next itteration of the
loop.  This seemed to be an adequate solution but strangely we ran our test
and it failed as expected, implemented this change ran the test and it
worked, but then when we commented out the change and ran the test again and
it succeeded...so I have no idea.


Jon Pastore RHCE, President 
IDE Tech, Inc. 
(954) 360-0393 Office 
(954) 428-0442 Fax 
Public Key: http://www.idetech.net/keys/jpastore.asc 

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Michael Chaney
Sent: Thursday, April 22, 2004 10:26 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] postgresql idle

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/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



In response to

Responses

pgsql-general by date

Next:From: Campano, TroyDate: 2004-04-29 18:42:49
Subject: Timestamp problems...wrong weeks.
Previous:From: David A. UlevitchDate: 2004-04-29 17:36:23
Subject: Follow-up to original post, more information:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group