Re: procpid in pg_stat_activity but no correspoding backend

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: procpid in pg_stat_activity but no correspoding backend
Date: 2003-11-13 19:11:13
Message-ID: 3FB3D751.5000702@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jan Wieck wrote:

> Rajesh Kumar Mallah wrote:
>
>>
>> Hi ,
>>
>> I noticed that an entry in pg_stat_activity was existing for a
>> long duration > 2 mins while its backend ( process corresponding
>> to that procpid) was not running.
>>
>> how can it be possible ?
>>
>> version: 7.3.4
>
>
> There was a bug that caused a crashing backend to hang around in the
> stats until the slot is reused, because the message telling that the
> backend terminates is never sent to the collector daemon. I'm not sure
> if that got fixed for 7.4.

Thanks for explaining.

Regds
Mallah.

>
>
>
> Jan
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rick Gigger 2003-11-13 19:25:39 Re: RHEL
Previous Message Rick Gigger 2003-11-13 19:06:05 Re: simple question