Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gF2N9-0007RC-Qd for pgsql-admin@arkaria.postgresql.org; Tue, 23 Oct 2018 19:29:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gF2N7-0003Hw-RO for pgsql-admin@arkaria.postgresql.org; Tue, 23 Oct 2018 19:29:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gF2N7-0003Hk-7e for pgsql-admin@lists.postgresql.org; Tue, 23 Oct 2018 19:29:45 +0000 Received: from resqmta-ch2-04v.sys.comcast.net ([2001:558:fe21:29:69:252:207:36]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gF2N3-0000Bj-ML for pgsql-admin@postgresql.org; Tue, 23 Oct 2018 19:29:44 +0000 Received: from resomta-ch2-12v.sys.comcast.net ([69.252.207.108]) by resqmta-ch2-04v.sys.comcast.net with ESMTP id Ew5TgoyG2yO9KF2MxgMhTl; Tue, 23 Oct 2018 19:29:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20161114; t=1540322975; bh=cyQ+4lYAs90X5CxNseehAxwFb+Ch+w2+temC8LO7NIU=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=oNUieAJtcHfvVNfswEUSGkkrcPUV9tcUHf3OErjiyYXR9/+ud/Q+yhG87TQiFBbSy 3tBJB5Q+WqBeU6jI5Kzoyez7C7UwDbIhs/pCfwlPBPOK7V8V9RYPigStzLUCuQyKwT NWQHXI0N0ljiUflasx/XuGxMLFX5pueZbZBushSd3vRb2kUTlflqPmy3XI5Bkqbci8 o652Md0PmC+MHSG/xHdxfCkHptxmFliXlsqJ8CIKvTJdjzTcg4c2Soy8kdR5ZMFvn5 6wtN+lMsJsq5nZrr78x62miqVzXVcwX/dyLiBEIRMe36jJZqGc6MGthuodhpFt4O4g izhnFtpo5wF0A== Received: from jsievers.comcast.net ([12.30.159.20]) by resomta-ch2-12v.sys.comcast.net with ESMTPA id F2Mqg63LrTK5BF2MqgCOGM; Tue, 23 Oct 2018 19:29:32 +0000 Received: from jsievers.enova.com (localhost [127.0.0.1]) by jsievers.comcast.net (Postfix) with ESMTP id 668F6260056 for ; Tue, 23 Oct 2018 14:29:28 -0500 (CDT) From: Jerry Sievers To: pgsql-admin@postgresql.org Subject: No Known Snapshots error w/pg_recvlogical and wal2json plugin... Date: Tue, 23 Oct 2018 14:29:28 -0500 Message-ID: <87mur4pilj.fsf@jsievers.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-CMAE-Envelope: MS4wfJabqyxRwWqTjHUxkGfN/vHjl40+xx/E95kKrAaLuJYmgev66fYhWNY3jTACgm7PVFejwK6AX4lquFtvNHaFOu6mvCrEKYZjGWj50rZ86zJOwisfa7pO mFfeIhOXvRmpKKKJdeh1IWXhS5WSLPSZcjAhP4rpaS6RhZS5h2LgzpLEGM6KmfHL7o1lgo7LFIShhw== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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