pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (24+ messages)  latest in thread

Message-ID: <1466663905344-5909194.post@n5.nabble.com>
Permalink:  ../1466663905344-5909194.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1466663905344-5909194.post@n5.nabble.com

 · 

reply

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