Re: [GENERAL] ERROR: missing chunk number 0 for toast value while using logical decoder.\
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.\
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.\
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