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