My nightly vacuum crashed with the following error
NOTICE: BlowawayRelationBuffers(zusatz_zuord, 2): block 2 is
referenced (private 0, last 0, global 1)
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible.
I think there is a relation to an abnormal kill of a longlasting select
which i've ended
with
kill -9 <longlasting postgres-process>
This has left some pg_temp* file in the base-Dir.
After removing the pg_temp* files, stopping and starting the postmaster
the vacuum was successful.
How to stop a longlasting select in a clean way ??
--
MfG
-------------------------------------------------------------------------
- Karin Probost
- Bergische Universitaet Gesamthochschule Wuppertal
- RECHENZENTRUM Raum P-.09.05
- Gaussstr. 20
- D-42097 Wuppertal
- Germany
-
- Tel. : +49 -202 /439 2809 ,Fax -2910
--Email: [EMAIL PROTECTED]
--Home : http://www.hrz.uni-wuppertal.de/hrz/personen/k_probost.html
-------------------------------------------------------------------------
