Re: Multiple message delivery on logical replication

From: "Jonathan S(dot) Katz" <jonathan(dot)katz(at)excoventures(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: Multiple message delivery on logical replication
Date: 2018-11-03 01:31:45
Message-ID: BE80D43C-845D-44DA-9C69-F9B9B8B92B8D@excoventures.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg


> On Nov 2, 2018, at 9:28 PM, Christophe Pettus <xof(at)thebuild(dot)com> wrote:
>
> I'm working with the logical replication support in psycopg2, and have found something surprising... this may be my error, of course!
>
> My sample program is below. It works wonderfully, but in the case when it starts, it re-receives the last message that it handled, even with flushing it.

I’ve had this happen as well. IIRC it was when I was using it in async
mode with wal2json. From the investigating I did at the time, I thought
it was a bug with wal2json instead of psycopg2, but it was awhile ago
and my memory is fuzzy :(

Jonathan

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Christophe Pettus 2018-11-03 01:36:48 Re: Multiple message delivery on logical replication
Previous Message Christophe Pettus 2018-11-03 01:28:51 Multiple message delivery on logical replication