Corrupted index, what do i do?

From: eshishki <itparanoia(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Corrupted index, what do i do?
Date: 2012-01-12 13:08:56
Message-ID: CAO9_yBjn4pGsL9ta4dR49u-aWjza1yy9RTH_vrOrePpNXBTuqg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

today i restarted my postgresql 9.0 instance and it won't start.

The logs are
2012-01-12 14:01:59.976 MSK,,,5644,,4f0eaf97.160c,2,,2012-01-12
14:01:59 MSK,,0,LOG,00000,"database system was not properly shut down;
automatic recovery in progress",,,,,,,,,""
2012-01-12 14:01:59.976 MSK,,,5644,,4f0eaf97.160c,3,,2012-01-12
14:01:59 MSK,,0,LOG,00000,"consistent recovery state reached at
2A/7FA53250",,,,,,,,,""
2012-01-12 14:01:59.976 MSK,,,5644,,4f0eaf97.160c,4,,2012-01-12
14:01:59 MSK,,0,LOG,00000,"redo starts at 2A/7FA53250",,,,,,,,,""
2012-01-12 14:01:59.999 MSK,,,5644,,4f0eaf97.160c,5,,2012-01-12
14:01:59 MSK,,0,LOG,00000,"unexpected pageaddr 2A/8CE6000 in log file
42, segment 127, offset 13524992",,,,,,,,,""
2012-01-12 14:01:59.999 MSK,,,5644,,4f0eaf97.160c,6,,2012-01-12
14:01:59 MSK,,0,LOG,00000,"redo done at 2A/7FCE5E20",,,,,,,,,""
2012-01-12 14:01:59.999 MSK,,,5644,,4f0eaf97.160c,7,,2012-01-12
14:01:59 MSK,,0,LOG,00000,"last completed transaction was at log time
2012-01-12 13:37:40.810534+04",,,,,,,,,""
2012-01-12 14:02:00.040 MSK,,,5644,,4f0eaf97.160c,8,,2012-01-12
14:01:59 MSK,,0,FATAL,XX002,"index ""1339592"" contains unexpected
zero page at block 328134",,"Please REINDEX it.",,,,,,,""
2012-01-12 14:02:00.042 MSK,,,5642,,4f0eaf97.160a,1,,2012-01-12
14:01:59 MSK,,0,LOG,00000,"startup process (PID 5644) exited with exit
code 1",,,,,,,,,""
2012-01-12 14:02:00.042 MSK,,,5642,,4f0eaf97.160a,2,,2012-01-12
14:01:59 MSK,,0,LOG,00000,"aborting startup due to startup process
failure",,,,,,,,,""

My question is corrupted index, not transaction rollbacks.
How can i rebuild index if db aint start?

I was running with fsync off, how postgresql behave about index
consistency with fsync on?

--
Evgeny

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel McGreal 2012-01-12 13:20:58 Operator based on data type
Previous Message Achilleas Mantzios 2012-01-12 11:43:21 Re: Pgsql problem