Re: BUG #15744: Replication slot peak query throwing error for wrongsequence entry for toast chunk - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #15744: Replication slot peak query throwing error for wrongsequence entry for toast chunk
Date
Msg-id 3bd6953d-3da6-040c-62bf-9522808d5c2f@2ndquadrant.com
Whole thread Raw
In response to BUG #15744: Replication slot peak query throwing error for wrong sequence entry for toast chunk  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15744: Replication slot peak query throwing error for wrongsequence entry for toast chunk  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
On 2019-04-09 22:09, PG Bug reporting form wrote:
> PostgreSQL version: 9.6.3

This is very old.  9.6.12 is current.

> Behavior reported (Bug)
>   We have a replication slot running for successfully but recently we
> encountered following error: 
> 
> error: got sequence entry 2 for toast chunk 30954054 instead of seq 0

> Temporary resolution
>     After running the query 2-3 times, the error went away. But this causes
> the whole process to shut down. 
> 
> Is there any permanent resolution for the issue or is it resolved in the
> higher version of postgres? 

I've not seen this particular error, but there are a number of fixes
related to possible TOAST corruption, so this might be related to that.
Upgrading would certainly be the first step before investigating further.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #15734: Walsender process crashing when executing SHOW ALL;
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15734: Walsender process crashing when executing SHOW ALL;