From: sudalai <sudalait2@gmail.com>
To: pgsql-general@postgresql.org
Subject: ERROR: missing chunk number 0 for toast value while using logical decoder.\
Date: Wed, 22 Jun 2016 23:38:25 -0700 (MST)
Message-ID: <1466663905344-5909194.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
I am using PostgresSQL 9.5.0.
I have customized :
https://github.com/michaelpq/pg_plugins/tree/master/decoder_raw to get
result as json. It works fine. suddenly i getting below exception while
consuming or peeking changes through that logical slot.
Does postgres removed the rows needed for that slot??
Kindly help me to find the problem.
db=# select * from pg_logical_slot_get_changes('lslot',NULL,1);
ERROR: missing chunk number 0 for toast value 857563 in pg_toast_782254
CONTEXT: slot "lslot", output plugin "rep_slot", in the change callback,
associated LSN 2E/3C26D6F0
select * from pg_class where relname like 'pg_toast_782254';
-[ RECORD 1 ]-------+----------------
relname | pg_toast_782254
relnamespace | 99
reltype | 782273
reloftype | 0
relowner | 10
relam | 0
relfilenode | 782272
reltablespace | 0
relpages | 464
reltuples | 2066
relallvisible | 464
reltoastrelid | 0
relhasindex | t
relisshared | f
relpersistence | p
relkind | t
relnatts | 3
relchecks | 0
relhasoids | f
relhaspkey | t
relhasrules | f
relhastriggers | f
relhassubclass | f
relrowsecurity | f
relforcerowsecurity | f
relispopulated | t
relreplident | n
relfrozenxid | 1982173
relminmxid | 1
relacl |
reloptions |
Thanks In Advance.
-----
sudalai
--
View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical-decode...
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: sudalait2@gmail.com
Subject: Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\
In-Reply-To: <1466663905344-5909194.post@n5.nabble.com>
References: <1466663905344-5909194.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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