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 Tom Lane
Marco Craveiro writes: > We're experiencing a lot of errors when using CDash on PostgreSQL 9.1, > hosted on Mac OSX 10.6.8. The actual error message is as follows: > SQL error in Cannot insert test: > utility/asserter/assert_file_returns_true_for_empty_files into the > database():ERROR: failed t

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

Re: [GENERAL] Postgres error when adding new page

2012-10-01 Thread Peter Geoghegan
On 1 October 2012 14:47, Marco Craveiro wrote: > Hello Postgres general > > We're experiencing a lot of errors when using CDash on PostgreSQL 9.1, > hosted on Mac OSX 10.6.8. The actual error message is as follows: > > SQL error in Cannot insert test: > utility/asserter/assert_file_returns_true_fo