Hi!
I've been running postgres for an online sports service for some
months now. Everything has worked quite smoothly, but this morning
something strange happend.
Two postgres processess started by the webserver each reached over
300M in size and slowed the machine down to a crawl. They had been
running for a couple of minutes, after i killed them everything
went back to normal.
When i look into the pglog i see about 400 of these around the time of the
event:
FATAL: pq_endmessage failed: errno=32
pq_flush: send() failed: Broken pipe
I've scanned the weblogs to see if someone was doing something
exceptional, but it seems as if no special queries were performed.
If anyone could answer me what these errormessages indicate i would
be very grateful. Could it be a runaway mistyped query? Or maybe data
corruption?
The stuff i run is:
FreeBSD 3.1
Postgres 6.5.1
Apache 1.3.12
Vinum soft RAID
Hardware:
Dual PII processors
about 700M mem
--
Mattias Norlander
[EMAIL PROTECTED]
