7.0.3 _bt_restscan: my bits moved right off the end of the world!
От | Matthew |
---|---|
Тема | 7.0.3 _bt_restscan: my bits moved right off the end of the world! |
Дата | |
Msg-id | 183FA749499ED311B6550000F87E206C1FD094@srv.ctlno.com обсуждение исходный текст |
Ответы |
Re: 7.0.3 _bt_restscan: my bits moved right off the end of the world!
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: