Message-ID: <4c0d2dff-9fa2-1db0-0d0f-c84aefddfaab@koumakan.jp>
Date: Thu, 28 Oct 2021 11:04:05 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
 Thunderbird/91.2.1
Subject: Re: BUG #17245: Index corruption involving deduplicated entries
To: Peter Geoghegan <pg@bowt.ie>, David Rowley <dgrowley@gmail.com>
Cc: Thomas Munro <thomas.munro@gmail.com>,
 Andrew Gierth <andrew@tao11.riddles.org.uk>,
 PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>,
 Herman verschooten <Herman@verschooten.net>
References: <17245-ddf06aaf85735f36@postgresql.org>
 <CAH2-Wzn4mNEPbQ2Jrs=0tfF=iDHNpi7dSgPy2k1iHMdswR11MA@mail.gmail.com>
 <b8cff91e-eb62-f8e1-3016-77b7deda7634@koumakan.jp>
 <CA+hUKGLv2yaZp+y5hr7Occg-86y+5-+ZSDmWPzKV1NuBFSXzCw@mail.gmail.com>
 <84f64b71-1320-591d-5101-560ae5487779@koumakan.jp>
 <CAH2-WzmLapjJXL4ZNhJJYsbmUUGFJq5Jt2owkUDJhRWXehrgyQ@mail.gmail.com>
 <CAH2-WzmD_mZDm1Sb1C=nqUWj3cLTDoamx9EL_Tpwws_Ur9eFww@mail.gmail.com>
 <9076c0bd-e238-5f8d-1117-7f5549e35c33@koumakan.jp>
 <CAH2-Wzm0GZnNgNeHx-W-4ogR1RB1gGk_efMiWuinXFyMWzjb=w@mail.gmail.com>
 <CAH2-WznotEY2YXLBA44oqWLtQUTYHAKWnujCWmmWgthKhZ-97w@mail.gmail.com>
From: Kamigishi Rei <iijima.yun@koumakan.jp>
In-Reply-To: 
 <CAH2-WznotEY2YXLBA44oqWLtQUTYHAKWnujCWmmWgthKhZ-97w@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/4c0d2dff-9fa2-1db0-0d0f-c84aefddfaab%40koumakan.jp>
Precedence: bulk

On 28.10.2021 7:21, Peter Geoghegan wrote:
> Also, page 0 of the table "page" itself would be useful. The same
> pageinspect recipe will work with a table.

I forgot to mention: I have the data directory from the PostgreSQL 13.3 
instance that ran inside the same jail on the same FreeBSD system since 
May, so if that might be useful for the investigation, I can pull it 
into another VM.

-- 
K. R.