FATAL: index contains unexpected zero page at block

From: Dmitriy Tyugaev <dtyugaev(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: FATAL: index contains unexpected zero page at block
Date: 2012-11-14 14:49:18
Message-ID: CAAL_pKLx8Wcbo=HxgFk4oQt6CQ3YgBikNM+hdUCNpXA0AMj=oA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clemens Park 2012-11-14 15:37:16 Re: Using window functions to get the unpaginated count for paginated queries
Previous Message Tom Lane 2012-11-14 14:44:15 Re: Running out of memory while making a join