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
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 |