On Fri, Jul 10, 2009 at 08:40:28PM -0400, Scot Kreienkamp wrote:
> Anyway, I'm trying to attack it from the database side out since I am
> not a programmer and can't help with that part. I can do simple CGIs
> with bash, but I don't know Java or C or even Perl yet for that matter.
> Since you guys
Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Friday, July 10, 2009 7:02 PM
To: Scot Kreienkamp
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Idle in transaction help
On Fri, Jul 10, 2009 at 4:40 PM, Scot Kreienkamp
wrote:
> Thanks scott, but I wrote a
On Jul 10, 2009, at 3:34 PM, Scott Marlowe wrote:
Assuming that tracking down the process that's connected might help,
you can use pg_stat_activity to find the port that the client is
connecting from, then on the client machine, use lsof to hunt down the
process that is connecting via that port
On Fri, Jul 10, 2009 at 4:40 PM, Scot Kreienkamp wrote:
> Thanks scott, but I wrote a cgi to combine all of the process info and allow
> me to kill errant queries. So I know how to track down the pid. Thanks for
> trying to help though. :-)
So, what are you looking for, a stack trace dump from jav
Jul 10 18:34:14 2009
Subject: Re: [GENERAL] Idle in transaction help
On Fri, Jul 10, 2009 at 2:05 PM, Scot Kreienkamp wrote:
> Hi everyone,
>
> I need some help with tracking down idle in transaction problems. We have a
> custom application that is leaving queries in idle in transactio
On Fri, Jul 10, 2009 at 2:05 PM, Scot Kreienkamp wrote:
> Hi everyone,
>
> I need some help with tracking down idle in transaction problems. We have a
> custom application that is leaving queries in idle in transaction status for
> unknown reasons. The developers are working on ways to track it d
Scot Kreienkamp wrote:
It is Java. I asked our programmers to check on the JDBC version as I
had seen that on the list previously. It is using postgresql-8.2-504.
Is that one of the problem versions? I had thought it was new enough
that it would not be subject to that problem.
well, the cu
4:21 PM
To: Scot Kreienkamp
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Idle in transaction help
Scot Kreienkamp wrote:
>
> Hi everyone,
>
> I need some help with tracking down idle in transaction problems. We
> have a custom application that is leaving queries in id
Scot Kreienkamp wrote:
Hi everyone,
I need some help with tracking down idle in transaction problems. We
have a custom application that is leaving queries in idle in
transaction status for unknown reasons. The developers are working on
ways to track it down, but right now the options on thei
Hi everyone,
I need some help with tracking down idle in transaction problems. We
have a custom application that is leaving queries in idle in transaction
status for unknown reasons. The developers are working on ways to track
it down, but right now the options on their end are limited and it
10 matches
Mail list logo
