Re: ERROR: missing chunk number 0 for toast value - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ERROR: missing chunk number 0 for toast value
Date
Msg-id 14592.1388692858@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: missing chunk number 0 for toast value  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: ERROR: missing chunk number 0 for toast value
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-01-02 21:21:15 +0200, Heikki Linnakangas wrote:
>> I don't see any other realistic way to fix this, however, so maybe we
>> should just bite the bullet and do it anyway.

> We could remember the subtransaction a variable was created in and error
> out if it the creating subtransaction aborted and it's not a
> pass-by-value datum or similar.

That would still result in throwing an error, though, so it isn't likely
to make the OP happy.  I was wondering if we could somehow arrange to not
release the subtransaction's AccessShareLock on the table, as long as it
was protecting toasted references someplace.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Christophe Pettus
Date:
Subject: Streaming replication bug in 9.3.2, "WAL contains references to invalid pages"
Next
From: Robert Haas
Date:
Subject: Re: preserving forensic information when we freeze