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

Got it. Thank you very much. :) -Sudalai - sudalai -- View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical-decoder-tp5909194p5912426.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent

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

On Mon, Jul 18, 2016 at 7:08 PM, sudalai wrote: > thank u. > why (select * from pg_logical_slot_peek_changes('slot',NULL,1) ) take share > lock ? > any idea ? My guess is that this lock comes from your plugin code. Please double-check it. -- Michael -- Sent via

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

thank u. why (select * from pg_logical_slot_peek_changes('slot',NULL,1) ) take share lock ? any idea ? -Sudalai - sudalai -- View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical-decoder-tp5909194p5912411.html

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

On Mon, Jul 18, 2016 at 4:31 PM, sudalai wrote: > Please help me, I am using PostgreSQL 9.5.0. > I don't know much in postgres internals. why does peek_changes trying > to take share lock on 248486 (primary key of one table). > Its postgres logical decoder

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

@micheal, Thanks for your help. It working now. But, now I'm getting deadlock, when i peek_changes or get_changes, in live system. db=#select count(*) from pg_logical_slot_peek_changes('slot',NULL,100); /* pid : 25833 */ ERROR: deadlock detected DETAIL: Process 25833 waits for

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

Thank u. The problem is because of the commented line. I forgot about that. Now, I uncommented it. It working fine. Thank u very much. -Sudalai - sudalai -- View this message in context:

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

On Thu, Jun 23, 2016 at 4:55 PM, sudalai wrote: > Thanks for : https://github.com/michaelpq/pg_plugins/tree/master/decoder_raw > I will upgrade my servers to PostgreSQL 9.5.3, but i want to find the > problem. > Please help me. > I don't have SQL sequence. > Does anything i

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

Thanks for : https://github.com/michaelpq/pg_plugins/tree/master/decoder_raw I will upgrade my servers to PostgreSQL 9.5.3, but i want to find the problem. Please help me. I don't have SQL sequence. Does anything i can get from server, that will help us to debug the problem? Here is

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

Hi john, PostgreSQL 9.5.0 has bug !!!, Does 9.5.0 remove unconsumed toast rows need for slot?? It is fixed in latest!!!. -Sudalai - sudalai -- View this message in context: