Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events

From: Valentin Nastasache <valentin(dot)nastasache(at)voipfuture(dot)com>
To: Daniel Danzberger <daniel(at)dd-wrt(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "Robert Welin <robert"(at)vaion(dot)com
Cc: Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Sergei Kornilov <sk(at)zsrv(dot)org>, pgsql-hackers(at)postgresql(dot)org, Peter Eisentraut <peter_e(at)gmx(dot)net>, Marc Dean <marc(dot)dean(dot)jr(at)gmail(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, "michael(dot)paul(dot)powers(at)gmail(dot)com" <michael(dot)paul(dot)powers(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events
Date: 2021-05-12 11:45:55
Message-ID: b806777f-c483-ba92-6dd9-5b173815a041@voipfuture.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

We also encountered this and is still an issue even for version 13
(https://github.com/valentin-nasta/postgresql-bug-15293-demo
<https://github.com/valentin-nasta/postgresql-bug-15293-demo>).

Current workaround is to have a java thread sending each 500ms a notify
to the channel from the subscriber server to sync the queue.

Is there an update on this?

Kind regards,

Valentin Nastasache

---

Senior Java Developer

Voipfuture GmbH

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-05-12 13:57:29 Re: BUG #16833: postgresql 13.1 process crash every hour
Previous Message Alex F 2021-05-12 10:04:13 Re: BUG #16833: postgresql 13.1 process crash every hour