Re:Logical replication halted due to "this slot has been invalidated because it exceeded the maximum reserved size."

Sergei Kornilov <sk@zsrv.org>

From: Sergei Kornilov <sk@zsrv.org>

To: Alvaro Herrera <alvherre@alvh.no-ip.org>

Cc: pgsql-bugs@lists.postgresql.org, Viljo Hakala <viljo.hakala@advania.com>

Date: 2022-11-29T13:16:40Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Advance old-segment horizon properly after slot invalidation
- 866237a6fa01 13.4 cited

Hello

> The only explanation of this behavior that doesn't involve a bug is that
this parameter was set to a nonzero value, then set to disabled, but the
checkpointer failed to notice the change.

Or max_slot_wal_keep_size is really set on the publication database, but only the subscription database config was checked.

regards, Sergei