Re: BUG #15744: Replication slot peak query throwing error for wrongsequence entry for toast chunk
От | Peter Eisentraut |
---|---|
Тема | Re: BUG #15744: Replication slot peak query throwing error for wrongsequence entry for toast chunk |
Дата | |
Msg-id | 3bd6953d-3da6-040c-62bf-9522808d5c2f@2ndquadrant.com обсуждение исходный текст |
Ответ на | BUG #15744: Replication slot peak query throwing error for wrong sequence entry for toast chunk (PG Bug reporting form <noreply@postgresql.org>) |
Ответы |
Re: BUG #15744: Replication slot peak query throwing error for wrongsequence entry for toast chunk
|
Список | 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 по дате отправления: