Thread: procpid in pg_stat_activity but no correspoding backend

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


regds
mallah.

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.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

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
>