Re: [GENERAL] Postgres error when adding new page

2012-10-02 Thread Marco Craveiro
Tom, Peter, I'm wondering if this could be an artifact of the WAL-replay bug fixed in >> 9.1.6. I'd suggest updating and then reindexing the index ... >> >> > We are running 9.1.2 it seems > > We did a file system check and it all appeared green, at least as far as OSX is concerned. We then upgra

Re: [GENERAL] Postgres error when adding new page

2012-10-01 Thread Marco Craveiro
Hello Tom, This definitely looks like index corruption, but blaming it on the > filesystem might be premature. I'm wondering if this could be an > artifact of the WAL-replay bug fixed in 9.1.6. I'd suggest updating > and then reindexing the index ... > > We are running 9.1.2 it seems: select ve

Re: [GENERAL] Postgres error when adding new page

2012-10-01 Thread Marco Craveiro
Peter, Thanks for your prompt reply. A call to PageAddItem(), made within _bt_pgaddtup(), is where this > failure seems to ultimately originate from. What we're missing here is > the reason for PageAddItem() returning InvalidOffsetNumber. That is > usually, though not necessarily, separately avai