From: Valentin Nastasache <valentin.nastasache@voipfuture.com>
To: Daniel Danzberger <daniel@dd-wrt.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Robert Welin <robert <@vaion.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Sergei Kornilov <sk@zsrv.org>
Cc: pgsql-hackers@postgresql.org, Peter Eisentraut <peter_e@gmx.net>
Cc: Marc Dean <marc.dean.jr@gmail.com>
Cc: Petr Jelinek <petr@2ndquadrant.com>
Cc: michael.paul.powers@gmail.com <michael.paul.powers@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events
Date: Wed, 12 May 2021 13:45:55 +0200
Message-ID: <b806777f-c483-ba92-6dd9-5b173815a041@voipfuture.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: valentin.nastasache@voipfuture.com, daniel@dd-wrt.com, alvherre@2ndquadrant.com, @vaion.com, andres@anarazel.de, tgl@sss.pgh.pa.us, sk@zsrv.org, peter_e@gmx.net, marc.dean.jr@gmail.com, petr@2ndquadrant.com, michael.paul.powers@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events
In-Reply-To: <b806777f-c483-ba92-6dd9-5b173815a041@voipfuture.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox