| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 9.4 checksum errors in recovery with gin index |
| Date: | 2014-05-07 07:48:56 |
| Message-ID: | 20140507074856.GD22053@awork2.anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On 2014-05-07 00:35:35 -0700, Jeff Janes wrote:
> When recovering from a crash (with injection of a partial page write at
> time of crash) against 7c7b1f4ae5ea3b1b113682d4d I get a checksum
> verification failure.
>
> 16396 is a gin index.
Over which type? What was the load? make check?
> If I have it ignore checksum failures, there is no apparent misbehavior.
> I'm trying to bisect it, but it could take a while and I thought someone
> might have some theories based on the log:
If you have the WAL a pg_xlogdump grepping for everything referring to
that block would be helpful.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2014-05-07 07:57:54 | Re: postgresql.auto.conf read from wrong directory |
| Previous Message | Jeff Janes | 2014-05-07 07:35:35 | 9.4 checksum errors in recovery with gin index |