Re: procpid in pg_stat_activity but no correspoding backend - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject Re: procpid in pg_stat_activity but no correspoding backend
Date
Msg-id 3FB3D751.5000702@trade-india.com
Whole thread Raw
In response to Re: procpid in pg_stat_activity but no correspoding backend  (Jan Wieck <JanWieck@Yahoo.com>)
List 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
>



pgsql-general by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: dumping sequences
Next
From: Scott Chapman
Date:
Subject: Re: SQL-question: returning the id of an insert querry