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

2016-06-23 Thread 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

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

2016-06-23 Thread 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.

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

2016-06-23 Thread 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