| 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: | Whole Thread | Raw Message | 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
| 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 |