From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | TOAST table (or index?) corruption on PITR replica |
Date: | 2009-03-06 13:32:46 |
Message-ID: | 20090306133246.GC3901@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
We have a customer running a very high-velocity database. We have set
up a PITR replica that's restoring correctly using JD's PITRtools and
pg_standby.
However, upon stopping the recovery and starting it for production (for
"switchover") it promptly gets into these problems:
14895 2009-02-28 22:19:08 EST kangaroo app 49a9fe2e.3a2f ERROR: missing chunk number 0 for toast value 93557123
14895 2009-02-28 22:19:08 EST kangaroo app 49a9fe2e.3a2f STATEMENT: update sometable set stop_status=1, stop_time=current_timestamp, stop_method=1 where unit_id='227245' and email='foobar(at)example(dot)com'
14903 2009-02-28 22:22:02 EST kangaroo app 49a9fe2e.3a37 ERROR: index "pg_toast_42299_index" contains unexpected zero page at block 23768
14903 2009-02-28 22:22:02 EST kangaroo app 49a9fe2e.3a37 HINT: Please REINDEX it.
There were actually several different instances of the first error
involving different toast values.
The servers are running 8.3.5.
Does this ring a bell for anyone?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2009-03-06 13:46:05 | Re: TOAST table (or index?) corruption on PITR replica |
Previous Message | Zdenek Kotala | 2009-03-06 13:29:55 | Re: Additional DTrace Probes |