From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | davividal(at)gmail(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #12617: DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112: Success. |
Date: | 2015-01-21 15:07:12 |
Message-ID: | 20150121150712.GR1663@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
davividal(at)gmail(dot)com wrote:
> My scenario: I have a daily physical backup from my production server
> (9.1).
> I create a 9.1 cluster from it and upgrade it to 9.4 daily. After that, I
> deploy a bunch of changes using sqitch (sqitch.org) Again: I do it on a
> daily basis, but this is the first time I faced this issue:
>
> $ sqitch deploy -t sandbox views/sistema(dot)sf_guard_user(at)HEAD
> Deploying changes through views/sistema.sf_guard_user to sandbox
> + data_migration/rate_plan.payment_policies ...............
> psql:sql/deploy/data_migration/rate_plan.payment_policies.sql:21: ERROR:
> could not access status of transaction 116940611
> DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112:
> Success.
> CONTEXT: while updating tuple (6302,20) in relation "rate_daily_policies"
> not ok
Can you please paste the output of pg_controldata on both clusters?
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2015-01-21 18:14:11 | Re: pg_upgrade failure on Windows Server |
Previous Message | Tom Lane | 2015-01-21 14:05:15 | Re: BUG #12589: Poor randomness from random() with some seeds; poor resolution |