Re: Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.
Date
Msg-id 56DD9FC1.5020501@aklaver.com
Whole thread Raw
In response to Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.  (<fredrik@huitfeldt.com>)
Responses Re: Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.  (<fredrik@huitfeldt.com>)
List pgsql-general
On 03/06/2016 10:18 PM, fredrik@huitfeldt.com wrote:
> HI All,
>
> i would really appreciate any help I can get on this issue.
>
> basically, a pg_basebackup + streaming attach, led to a database that we
> could not read from afterwards.
>

 From original post:

http://www.postgresql.org/message-id/1456919678340.31300.116900@webmail2

"The issue remained until we ran a full vacuum analyze on the cluster."

Which cluster was that, the master or the slave?

"I have logfiles from the incident, but I cannot see anything out of the
ordinary (despite having a fair amount of experience investigating
postgresql logs)."


Can we see the section before and after ERROR?

>
> Beset regards,
> Fredrik
>
> PS please advise if this is better posted on another list.


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Steven Xu
Date:
Subject: Re: Custom column ordering
Next
From: Ashish Chauhan
Date:
Subject: Script to check replication