Andres Freund <andres@2ndquadrant.com> writes:
> On Thursday, September 20, 2012 07:15:17 PM Tom Lane wrote:
>> Hmm. There is a fix for a slave-side-index-corruption problem in 9.1.6,
>> which is due to be announced Monday. I am not certain whether this is
>> the same thing though; that bug is low-probability as far as we can
>> tell (it would only happen if the master had been in the middle of an
>> index page split or page deletion at the instant of failover). Anyway
>> the first thing to find out is whether 9.1.6 fixes it.
> I think the likelihood of that bug causing the the index file to be zero bytes
> - at least thats what I read from $subject - is really, really small:
Sure, but what about the heap? The case I was speculating about was
that the heap had been truncated, but because of the corruption problem,
the index still had heap pointers in it. We don't know what file 16585
is supposed to be.
Your point about hash indexes is definitely worth asking though...
that would square with the reported symptoms.
regards, tom lane