Обсуждение: No Known Snapshots error w/pg_recvlogical and wal2json plugin...

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");

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800

On October 23, 2018 9:29:28 PM GMT+02:00, Jerry Sievers <gsievers19@comcast.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

Julien Riou <julien.riou@outlook.com> writes:

> On October 23, 2018 9:29:28 PM GMT+02:00, Jerry Sievers <gsievers19@comcast.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
>>snapshots");
>
> Hello,
>
> This is a wal2json issue I've encountered too: https://github.com/eulerto/wal2json/issues/74

Yup, thanks!  I went and flipped the include-unchanged-toast option to
false soon after posting this and problem went away at least for the
system I was testing with.

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800