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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Michael Chaney Sent: Thursday, April 22, 2004 10:26 AM To: pgsql-general@postgresql.org Subject: Re: 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@michaelchaney.com http://www.michaelchaney.com/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
