Logical Replication - "invalid ordering of speculative insertion changes"

Поиск
Список
Период
Сортировка
От Joe Wildish
Тема Logical Replication - "invalid ordering of speculative insertion changes"
Дата
Msg-id d95816a4-d0df-4c6f-a58a-21a3f8318826@app.fastmail.com
обсуждение исходный текст
Ответы Re: Logical Replication - "invalid ordering of speculative insertion changes"
Список pgsql-general
Hello,

We have a logical replication publisher (13.7) and subscriber (14.6) where we are seeing the following error on the
subscriber.IP address and publication name changed, otherwise verbatim:
 

2023-01-31 15:24:49 UTC:x.x.x.x(56276):super@pubdb:[1040971]: WARNING:  tables were not subscribed, you will have to
runALTER SUBSCRIPTION ... REFRESH PUBLICATION to subscribe the tables
 
2023-01-31 15:24:50 UTC::@:[1040975]: LOG:  logical replication apply worker for subscription "pub" has started
2023-01-31 15:24:50 UTC::@:[1040975]: ERROR:  could not receive data from WAL stream: ERROR:  invalid ordering of
speculativeinsertion changes
 

This error occurs during the initial set up of the subscription.  We hit REFRESH, and then immediately it goes into
thiserror state. It then repeats as it is retrying from here onwards and keeps hitting the same error.
 

My understanding is that the subscriber is performing some kind of reordering of the events contained within the WAL
message.As it cannot then consume the message, it aborts, retries, and gets the same message and errors again.  Looking
inthe source code it seems there is only one place where this error can be emitted --- reorderbuffer.c:2179.  Moreover
Ican't tell if this is an error that I can be expected to recover from as a user.
 

We see this error only sometimes. Other times, we REFRESH the subscription and it makes progress as one would expect.

Can anyone advise on what we are doing wrong here?

-Joe



В списке pgsql-general по дате отправления: