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

Re: "idle in transaction" postgres connection

From: tamanna madaan <tamanna(dot)madaan(at)globallogic(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: "idle in transaction" postgres connection
Date: 2011-08-22 04:51:20
Message-ID: CAD4qJ_J0m4oQbXtdb86WKenuoAYEnNGJEOBdR6cAWgz+xwo0vQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Can anyone please suggest me on this .


Thanks..
Tamanna

On Thu, Aug 18, 2011 at 3:04 PM, tamanna madaan <
tamanna(dot)madaan(at)globallogic(dot)com> wrote:

>
> Hi All
>
> I am using postgres-8.4.0 on a cluster setup with slony-2.0.4 being used
> for replication.
> Recently , I saw a "idle in transaction" postgres process as below.
>
> postgres 13052 14742 0 May13 ? 00:00:00 postgres: slon abc
> 172.16.1.1(49017) idle in transaction
>
> I wonder what could have lead to that hung postgres process . I googled
> about it a lot and they say that it could be
> because of abrupt netwotk issue between slony and postgres . But in my case
> slon was connected
> to its local postgres database. So, network wont be an issue in this case .
> Restarting the slon/postgres resolves
> the issue. But, there are other processes also in my application  which
> connect to postgres using psqlODBC . Those
> processes can also cause "idle in transaction" postgres connection . I
> can't afford restarting any of the processes
> to resolve this issue. So, I was wondering if I can make use of
> tcp_keepalives_idle , tcp_keepalives_interval and
> tcp_keepalives_count configurations in postgresql.conf to get rid of this
> "idle in transaction" processes
> after a certain amount of time . Will this help or not ??
>
>
> Thanks...
> Tamanna
>
>
>



-- 
Tamanna Madaan | Associate Consultant | GlobalLogic Inc.
Leaders in Software R&D Services
ARGENTINA | CHILE | CHINA | GERMANY | INDIA | ISRAEL | UKRAINE | UK | USA

Office: +0-120-406-2000 x 2971

www.globallogic.com

In response to

pgsql-odbc by date

Next:From: Devrim GÜNDÜZDate: 2011-09-09 12:26:52
Subject: 9.1 driver status
Previous:From: Gustavo PinsardDate: 2011-08-19 18:05:36
Subject: Re: Listen/notify and ODBC

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