pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNo Known Snapshots error w/pg_recvlogical and wal2json plugin...
3+ messages / 2 participants
[nested] [flat]
* No Known Snapshots error w/pg_recvlogical and wal2json plugin...
@ 2018-10-23 19:29 Jerry Sievers <gsievers19@comcast.net>
0 siblings, 1 reply; 3+ messages in thread
From: Jerry Sievers @ 2018-10-23 19:29 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: No Known Snapshots error w/pg_recvlogical and wal2json plugin...
@ 2018-10-24 02:48 Julien Riou <julien.riou@outlook.com>
parent: Jerry Sievers <gsievers19@comcast.net>
0 siblings, 1 reply; 3+ messages in thread
From: Julien Riou @ 2018-10-24 02:48 UTC (permalink / raw)
To: Jerry Sievers <gsievers19@comcast.net>; pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: No Known Snapshots error w/pg_recvlogical and wal2json plugin...
@ 2018-10-24 03:03 Jerry Sievers <gsievers19@comcast.net>
parent: Julien Riou <julien.riou@outlook.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jerry Sievers @ 2018-10-24 03:03 UTC (permalink / raw)
To: Julien Riou <julien.riou@outlook.com>; +Cc: Jerry Sievers <gsievers19@comcast.net>; pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-10-24 03:03 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-10-23 19:29 No Known Snapshots error w/pg_recvlogical and wal2json plugin... Jerry Sievers <gsievers19@comcast.net>
2018-10-24 02:48 ` Julien Riou <julien.riou@outlook.com>
2018-10-24 03:03 ` Jerry Sievers <gsievers19@comcast.net>
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