| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Marco Craveiro <marco(dot)craveiro(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres error when adding new page |
| Date: | 2012-10-01 14:42:02 |
| Message-ID: | 24057.1349102522@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Marco Craveiro <marco(dot)craveiro(at)gmail(dot)com> 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 to add old item to the right sibling while
> splitting block 191 of index "crc323"<br>
> I'm a bit stuck from here on. Is the likely reason for this problem
> filesystem corruption or am I barking at the wrong tree?
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 ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Craveiro | 2012-10-01 14:49:35 | Re: Postgres error when adding new page |
| Previous Message | pfote | 2012-10-01 14:28:26 | strange hot_standby behaviour |