Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2 - Mailing list pgsql-bugs

From Jean-Pierre Pelletier
Subject Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2
Date
Msg-id BAYC1-PASMTP01A3A1FFA771B31B32E1FF95800@CEZ.ICE
Whole thread Raw
List pgsql-bugs
Hi,

pg_stat_activity sometimes list no connections or a number of connections
much smaller than the number of postgres.exe processes.

We also have these messages in our PostgreSQL log approximately
20 times a day.

FATAL:  could not read from statistics collector pipe: No error
FATAL:  could not write to statistics collector pipe: No connection could be
made because the target machine actively refused it.

or

FATAL:  could not read from statistics collector pipe: No error
LOG:  statistics collector process (PID 1628) was terminated by signal 1

It looks like the pg_stat_activity problem and the messages become
more frequent as the load/number of connection increases.

We were having the same pg_stat_activity problem and the same messages
with PostgreSQL 8.0.1 but didn't have the messages with PostgreSQL 7.4.1.
we don't know if pg_stat_activity was ok with 7.4.1 because we weren't using
it back then.

We are using Windows 2000 Server, Service Pack 4.

Thanks
Jean-Pierre Pelletier
e-djuster

pgsql-bugs by date:

Previous
From: Kouber Saparev
Date:
Subject: Re: BUG #1927: incorrect timestamp returned
Next
From: Steve Peterson
Date:
Subject: Re: Bug?: Text after right paren in query is ignored