Postgre 7.0.3, on RedHat Linux 6.2 stock 2.2.16 kernel. Nothing special I
can think of, this server has been up and in use for the last 128 days with
no problem. Last night while cron was performing the nightly vacuuming of
all databases on one of our servers, I got this from cron.
Vacuuming cms
FATAL 1: _bt_restscan: my bits moved right off the end of the world!Recreate index history_id_key.
pqReadData() -- backend closed the channel unexpectedly.This probably means the backend terminated abnormallybefore or
whileprocessing the request.
connection to server was lost
So this morning I did the following:
cms=# drop index history_id_key;
DROP
cms=# create unique index history_id_key on history(id);
CREATE
cms=# vacuum;
NOTICE: Index locks_operator_id_ndx: pointer to EmptyPage (blk 44 off 2) -
fixing
NOTICE: Index locks_operator_id_ndx: pointer to EmptyPage (blk 44 off 1) -
fixing
NOTICE: Index locks_operator_id_ndx: pointer to EmptyPage (blk 44 off 4) -
fixing
NOTICE: Index locks_operator_id_ndx: pointer to EmptyPage (blk 44 off 3) -
fixing
NOTICE: Index locks_operator_id_ndx: pointer to EmptyPage (blk 44 off 5) -
fixing
NOTICE: Index locks_id_key: pointer to EmptyPage (blk 44 off 2) - fixing
NOTICE: Index locks_id_key: pointer to EmptyPage (blk 44 off 1) - fixing
NOTICE: Index locks_id_key: pointer to EmptyPage (blk 44 off 4) - fixing
NOTICE: Index locks_id_key: pointer to EmptyPage (blk 44 off 3) - fixing
NOTICE: Index locks_id_key: pointer to EmptyPage (blk 44 off 5) - fixing
NOTICE: Index locks_case_id_ndx: pointer to EmptyPage (blk 44 off 5) -
fixing
NOTICE: Index locks_case_id_ndx: pointer to EmptyPage (blk 44 off 2) -
fixing
NOTICE: Index locks_case_id_ndx: pointer to EmptyPage (blk 44 off 1) -
fixing
NOTICE: Index locks_case_id_ndx: pointer to EmptyPage (blk 44 off 4) -
fixing
NOTICE: Index locks_case_id_ndx: pointer to EmptyPage (blk 44 off 3) -
fixing
NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to
terminate
your database system connection and exit. Please reconnect to the database system and repeat your query.
pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
I have since stopped the database server and all my users are dead in the
water at the moment. I took postgres down to single user mode and I'm doing
a vacuum and was considering doing an iccpclean. Any other suggestions?
dump & restore? Any Idea what happened?
Thank you,
Matthew O'Connor