Re: idle in transaction process

Can anyone please suggest me on this .

Thanks..
Tamanna

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

> Hi
>
> Yes , restarting the slon resolves the issue. But. there are other
> processes also in my application which connect to postgres . Those
> processes can also cause "idle in transaction" postgres connection . 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" process after a
> certain amount of time . Will this help or not ??
>
>
>
> Thanks...
> Tamanna
>
>
> On Tue, Aug 16, 2011 at 11:56 AM, Abbas <abbas(dot)dba(at)gmail(dot)com> wrote:
>
>>
>> Best Regards,
>> Abbas
>>
>>
>> On Mon, Aug 15, 2011 at 11:14 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 . What else could be the reason for
>>> this hung process ? What should I do to come over this kind of issue in
>>> future. I think this hung process would have
>>> taken locks on various tables. I wonder if killing the "idle in
>>> transaction" process would cause the locks on the tables
>>> to be released or not. Can anyone please help me on that.
>>>
>>
>> Of course it is a slon process if it is not due to a network issue, then
>> might be any of your scripts, if not you can try by restarting the slon
>> process on origin.
>>
>> Abbas.
>>
>>>
>>> Thanks in Advance .
>>>
>>> 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
>
>
>

--
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