Subject: Re: BUG #17268: Possible corruption in toast index after reindex
 index concurrently
To: Maxim Boguk <maxim.boguk@gmail.com>, Andres Freund <andres@anarazel.de>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>,
 Peter Geoghegan <pg@bowt.ie>, Michael Paquier <michael@paquier.xyz>
References: <17268-d2fb426e0895abd4@postgresql.org>
 <CAH2-Wznen2nOrUB32LrsuF4uGfDF1s_VZzDjhOYfLKo5H1g8Yw@mail.gmail.com>
 <CAK-MWwQBMWOwEJx+DCTnXOrqjg00wMbXwc60hkZD=Q9WmUsChg@mail.gmail.com>
 <CAH2-Wz=Sk=5WCt1T+7cReAuDoggJkiNxeCD73ODm6jfrLu4y1w@mail.gmail.com>
 <CAK-MWwTFEPE+9VJVh_T4HQa5ZH28MgOfHiznk05-Zj+ZnZn2RQ@mail.gmail.com>
 <CAK-MWwTEWO2zzV-1ddm2mpurdv_3wAXwB3u_eh5W7xHM+SrsMQ@mail.gmail.com>
 <E6013BD3-5114-4338-AA03-7FBBE23FEC33@anarazel.de>
 <CAK-MWwQGv-wjcSrYeGE8fCW0=KYGE1tSMoH-fJ8maWV3kfe9iQ@mail.gmail.com>
From: Alexey Ermakov <alexey.ermakov@dataegret.com>
Message-ID: <366f7247-709e-c07c-4875-068be1121c3a@dataegret.com>
Date: Mon, 8 Nov 2021 17:04:40 +0600
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.0; rv:68.0)
 Gecko/20100101 Thunderbird/68.12.1
MIME-Version: 1.0
In-Reply-To: 
 <CAK-MWwQGv-wjcSrYeGE8fCW0=KYGE1tSMoH-fJ8maWV3kfe9iQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/366f7247-709e-c07c-4875-068be1121c3a%40dataegret.com>
Precedence: bulk

Hello,

On 2021-11-08 02:29, Maxim Boguk wrote:
> On Sun, Nov 7, 2021 at 2:07 AM Andres Freund <andres@anarazel.de> wrote:
>> Hi,
>>
>> On November 4, 2021 1:01:44 PM PDT, Maxim Boguk <maxim.boguk@gmail.com> wrote:
>>> UPDATE: the problem base table entry which had erroneous toast data
>>> definitely had been created during the REINDEX run of toast idx.
>> Do you have any details about the transaction / application that inserted the data?
> Well... jdbc with server side prepared statements off (pgbouncer).
>

I was told that application inserts rows into given table with queries like:

INSERT INTO zz (id, body) VALUES (?, ?) ON CONFLICT (id) DO NOTHING

inside transaction. It's possible to attempt to insert row with same id 
several times inside one transaction (in that case usually that id is 
new one i.e. was not presented in the table before that transaction).

Hope it could help in some way.


--

Thanks,

Alexey Ermakov