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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: sudalai <sudalait2(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\
Date: 2016-06-23 08:03:08
Message-ID: CAB7nPqTAd9npn_iw3VZRZQ5oL8r6L=zuM-FhoE7=R60k3vPXVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 23, 2016 at 4:55 PM, sudalai <sudalait2(at)gmail(dot)com> 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 can get from server, that will help us to debug the problem?
>
> Here is logical_decoder code: rep_slot.c
> <http://postgresql.nabble.com/file/n5909207/rep_slot.c>

if (isnull)
appendStringInfoString(s, "NiLnUlL"); // Printing null as "NiLnUlL"
//else if (typisvarlena && VARATT_IS_EXTERNAL_ONDISK(origval))
// appendStringInfoString(s, "unchanged-toast-datum")
Uncomment that.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sudalai 2016-06-23 12:09:06 Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\
Previous Message sudalai 2016-06-23 07:55:48 Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\