From: | Viljo Hakala <Viljo(dot)Hakala(at)advania(dot)com> |
---|---|
To: | Sergei Kornilov <sk(at)zsrv(dot)org>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | VS: Re:Logical replication halted due to "this slot has been invalidated because it exceeded the maximum reserved size." |
Date: | 2022-11-29 13:44:29 |
Message-ID: | AS8PR05MB87412C3569BC7F47711B03CD97129@AS8PR05MB8741.eurprd05.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-bugs |
HI,
Previously we had -1 as default for both of these instances and that caused same kind of issue.
Now we had set it to maximum value. We changed it back to -1
The logical replication was rebuilt over the weekend from scratch and issue occurred only 2-3 days after.
So we believe this is a bug. There seems to have been an issue in 13, that got fixed. But maybe this is a regression bug?
Regards,
Viljo
Lähettäjä: Sergei Kornilov <sk(at)zsrv(dot)org>
Päivämäärä: tiistaina, 29. marraskuuta 2022 klo 15.16
Vastaanottaja: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Kopio: pgsql-bugs(at)lists(dot)postgresql(dot)org <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Viljo Hakala <Viljo(dot)Hakala(at)advania(dot)com>
Aihe: Re:Logical replication halted due to "this slot has been invalidated because it exceeded the maximum reserved size."
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sbob | 2022-11-29 18:22:24 | SQL Firewall |
Previous Message | Sergei Kornilov | 2022-11-29 13:16:40 | Re:Logical replication halted due to "this slot has been invalidated because it exceeded the maximum reserved size." |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-11-29 16:22:33 | Re: BUG #17702: An assert failed in parse_utilcmd.c |
Previous Message | Sergei Kornilov | 2022-11-29 13:16:40 | Re:Logical replication halted due to "this slot has been invalidated because it exceeded the maximum reserved size." |