bclark_hyperic
Enthusiast
Enthusiast

Postgres "FATAL: could not read from statistics collector pipe"

Hello,

In my HQ-bundled Postgres 8.1.2 database, I am seeing these errors (below). I don't know why.

I am also seeing Hyperic-generated java.exe processes that take up 50% of my CPU throughout the day. This started around the same time that I saw these postgres errors.

[2009-02-25 16:35:00.950 ] FATAL: could not write to statistics collector pipe: No connection could be made because the target machine actively refused it.
[2009-02-25 16:35:00.919 ] FATAL: could not read from statistics collector pipe: No error
[2009-02-25 16:20:01.738 ] FATAL: could not write to statistics collector pipe: No connection could be made because the target machine actively refused it.
[2009-02-25 16:20:01.691 ] FATAL: could not read from statistics collector pipe: No error
[2009-02-25 16:10:03.727 ] LOG: statistics collector process (PID 6180) was terminated by signal 1


Anyone have any ideas why this is happening or how I can fix it?

Thanks,
Brian
0 Kudos
2 Replies
excowboy
Virtuoso
Virtuoso

Brian,

are you sure it is Postgres 8.1.2 ? If so, then it is the bug described here:
http://archives.postgresql.org/pgsql-bugs/2006-05/msg00098.php


Cheers,
Mirko
bclark_hyperic
Enthusiast
Enthusiast

Yes, that looks like it is the problem. And it looks like it was resolved in 8.1.4.

Yes, I am sure I am running 8.1.2.
Version String: PostgreSQL 8.1.2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)

This was the version of Postgres that was bundled with HQ version 3.1.1. That is what I started with, and have been upgrading HQ ever since, now up to 4.0.2. Unfortunately, the HQ install/upgrade routine upgrades Hyperic but not Postgres.

I'd love to somehow get up to the version of Postgres that Hyperic is shipping with their Windows bundles now. (I think that is 8.2.x) Any idea how to do this?

Thanks,
Brian
0 Kudos