FATAL: index contains unexpected zero page at block

Поиск
Список
Период
Сортировка
От Dmitriy Tyugaev
Тема FATAL: index contains unexpected zero page at block
Дата
Msg-id CAAL_pKLx8Wcbo=HxgFk4oQt6CQ3YgBikNM+hdUCNpXA0AMj=oA@mail.gmail.com
обсуждение исходный текст
Ответы Re: FATAL: index contains unexpected zero page at block  (VB N <vbnpgc@gmail.com>)
Re: FATAL: index contains unexpected zero page at block  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi list,

After planned rebooting the server dropped the database server PostgreSQL 8.4

When it start the server writes to the log:

Nov 14 18:24:01 uno postgres84[24207]: [1-1] user=,db= LOG:  could not bind IPv6 socket: Cannot assign requested address
Nov 14 18:24:01 uno postgres84[24207]: [1-2] user=,db= HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
Nov 14 18:24:01 uno postgres84[24208]: [2-1] user=,db= LOG:  database system was interrupted while in recovery at 2012-11-14 18:18:42 MSK
Nov 14 18:24:01 uno postgres84[24208]: [2-2] user=,db= HINT:  This probably means that some data is corrupted and you will have to use the last backup for re
covery.
Nov 14 18:24:01 uno postgres84[24208]: [3-1] user=,db= LOG:  database system was not properly shut down; automatic recovery in progress
Nov 14 18:24:01 uno postgres84[24208]: [4-1] user=,db= LOG:  redo starts at 237B/78806EC8
Nov 14 18:24:04 uno postgres84[24208]: [5-1] user=,db= LOG:  unexpected pageaddr 237B/50A1E000 in log file 9083, segment 144, offset 10608640
Nov 14 18:24:04 uno postgres84[24208]: [6-1] user=,db= LOG:  redo done at 237B/90A1DF98
Nov 14 18:24:04 uno postgres84[24208]: [7-1] user=,db= LOG:  last completed transaction was at log time 2012-11-10 10:26:28.484922+04
Nov 14 18:24:04 uno postgres84[24208]: [8-1] user=,db= FATAL:  index "316879235" contains unexpected zero page at block 264
Nov 14 18:24:04 uno postgres84[24208]: [8-2] user=,db= HINT:  Please REINDEX it.
Nov 14 18:24:04 uno postgres84[24207]: [2-1] user=,db= LOG:  startup process (PID 24208) exited with exit code 1
Nov 14 18:24:04 uno postgres84[24207]: [3-1] user=,db= LOG:  aborting startup due to startup process failure

When I trying to run in a single mode:
postgres --single -D /opt/postgresql/data -P postgres

user=,db= FATAL:  index "316879235" contains unexpected zero page at block 264
user=,db= HINT:  Please REINDEX it.

Please tell me what can I do to recover?

--
Cheers,
Dmitriy

В списке pgsql-general по дате отправления:

Предыдущее
От: Clemens Park
Дата:
Сообщение: Re: Using window functions to get the unpaginated count for paginated queries
Следующее
От: John R Pierce
Дата:
Сообщение: Re: High SYS CPU - need advise