Re: [GENERAL] ERROR: missing chunk number 0 for toast value while using logical decoder.\

[Michael Paquier]

On Thu, Jun 23, 2016 at 3:38 PM, sudalai  wrote:
>
> 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

A couple of failures in logical decoding have been fixed in 9.5.2 and
9.5.3 but this one is new, still you had better update... The error is
visibly coming from the code of your plugin per the context message.
Do you have an SQL sequence that allows to reproduce the problem? I
recall playing with a couple of data types with my own plugin but I
never noticed that.
-- 
Michael


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ERROR: missing chunk number 0 for toast value while using logical decoder.\

[John R Pierce]

On 6/22/2016 11:38 PM, sudalai wrote:

I am using PostgresSQL 9.5.0.


while this likely has no bearing on your problem, you really should 
upgrade to 9.5.latest, 9.5.3 is out now.sub version upgrades like 
9.5.0 to 9.5.3 are painless, just upgrade and restart the server with 
the new code.



--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] ERROR: missing chunk number 0 for toast value while using logical decoder.\

[sudalai]

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-decoder-tp5909194.html
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