Search Postgresql Archives

Re: 8.2.3 PANIC with "corrupted item pointer"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Henk - CityWEB <henka@xxxxxxxxxxxxx> writes:
> On Thu, 21 Jun 2007, Tom Lane wrote:
>> FWIW, the only occurrences of that specific message text are in
>> PageIndexTupleDelete and PageIndexMultiDelete, so you can be pretty sure
>> that this is just a corrupted-index problem.  Once you've identified
>> which table has the problem, a REINDEX should fix it.

> I've identified the offending index, but REINDEX also causes the PANIC.
> I also tried DROPping the index (and REINDEX DATABASE foo), but that too
> causes a panic.

In that case you've not correctly identified the broken index.  It
sounds to me like the problem could possibly be in a system catalog
index.  REINDEX SYSTEM with use of system indexes disabled might help
(see the REINDEX man page).

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux