Re: No Known Snapshots error w/pg_recvlogical and wal2json plugin...

From: Julien Riou <julien(dot)riou(at)outlook(dot)com>
To: Jerry Sievers <gsievers19(at)comcast(dot)net>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: No Known Snapshots error w/pg_recvlogical and wal2json plugin...
Date: 2018-10-24 02:48:20
Message-ID: AM6PR02MB5318D808B3B292E8391B1B6AE2F60@AM6PR02MB5318.eurprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On October 23, 2018 9:29:28 PM GMT+02:00, Jerry Sievers <gsievers19(at)comcast(dot)net> wrote:
>Admins, just curious if anyone's seen this running something like the
>combo in $subject, or has any insight whatsoever.
>
>I find the error message in the src file seen later but not had time to
>dig deeper yet.
>
>Thx
>
>pg_recvlogical: unexpected termination of replication stream: ERROR:
>no known snapshots
>CONTEXT: slot "adhoc_jsievers", output plugin "wal2json", in the
>change callback, associated LSN A5D/12A026D8
>
>master:postgres$ git grep 'no known snapshots'
>src/backend/access/heap/tuptoaster.c: elog(ERROR, "no known
>snapshots");

Hello,

This is a wal2json issue I've encountered too: https://github.com/eulerto/wal2json/issues/74

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2018-10-24 03:03:27 Re: No Known Snapshots error w/pg_recvlogical and wal2json plugin...
Previous Message Jerry Sievers 2018-10-23 19:29:28 No Known Snapshots error w/pg_recvlogical and wal2json plugin...