From: | Kevin Kempter <kevink(at)consistentstate(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | cannot read block errors ! |
Date: | 2009-09-09 16:25:57 |
Message-ID: | 200909091025.57943.kevink@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All;
we're getting these errors on our system today:
Sep 9 00:53:45 ux-rqs04-atl2 ri_load[5846]: Caught Exception!
Shutting down: ERROR: could not read block 703769 of relation
37698/17627/38565: Input/output error CONTEXT: SQL statement "SELECT
1 FROM ONLY "our_schema"."big_table" x WHERE "id" OPERATOR(pg_catalog.=) $1
FOR SHARE OF x"
Sep 9 15:34:36 ux-rqs04-atl2 ri_load[23717]: Caught Exception! Shutting
down: PANIC: right sibling's left-link doesn't match: block 1377627
links to 3120580 instead of expected 1736900 in index "no_dups" CONTEXT: COPY
big_table, line 1563: "157945230 x/1739441607/false/p_1378267744=0"
\copy: unexpected response (7)
Anyone have any ideas what's gone wrong and how to fix it?
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-09-09 18:22:29 | Re: cannot read block errors ! |
Previous Message | Anj Adu | 2009-09-09 01:53:49 | plpgsql compilation |