pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: andrewbille@gmail.com
Subject: BUG #16619: Amcheck detects corruption in hstore' btree index (ver 2)
Date: Wed, 16 Sep 2020 10:34:58 +0000
Message-ID: <16619-aaba10f83fdc1c3c@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16619
Logged by:          Andrew Bille
Email address:      andrewbille@gmail.com
PostgreSQL version: 13beta3
Operating system:   Ubuntu-20.04
Description:        

Hello all.
Index corruption detected after upgrade from v 9.6/10:

mkdir v10
cd v10
git clone https://github.com/postgres/postgres.git ./
git checkout REL_10_STABLE
 ./configure >/dev/null && make -j8 >/dev/null && make -j8 contrib
>/dev/null
echo "SELECT 1;" >> contrib/hstore/sql/hstore.sql
make check -C contrib/hstore
cd ..
mkdir v13
cd v13
git clone https://github.com/postgres/postgres.git ./
git checkout REL_13_STABLE
./configure >/dev/null && make -j8 >/dev/null && make -j8 contrib
>/dev/null
echo "EXTRA_INSTALL = contrib/amcheck contrib/pageinspect"
>>contrib/hstore/Makefile
make check -C contrib/hstore
export LD_LIBRARY_PATH=tmp_install/usr/local/pgsql/lib
tmp_install/usr/local/pgsql/bin/initdb -D /tmp/db
tmp_install/usr/local/pgsql/bin/pg_upgrade -d
"../v10/contrib/hstore/tmp_check/data" -D /tmp/db -b
"../v10/tmp_install/usr/local/pgsql/bin" -B
tmp_install/usr/local/pgsql/bin
tmp_install/usr/local/pgsql/bin/pg_ctl -D /tmp/db -l l.log start
tmp_install/usr/local/pgsql/bin/psql -dcontrib_regression -c "create
extension if not exists amcheck;"
tmp_install/usr/local/pgsql/bin/psql -dcontrib_regression -c "SELECT
bt_index_parent_check('hidx', true);"

I get the following error:
ERROR:  mismatch between parent key and child high key in index "hidx"
DETAIL:  Target block=3 child block=1 target page lsn=0/16D5758.

(The same procedure with v11/12 doesn't produce the error.)

Thank you.



view thread (5+ messages)  latest in thread

Message-ID: <16619-aaba10f83fdc1c3c@postgresql.org>
Permalink:  ../16619-aaba10f83fdc1c3c@postgresql.org/
Also on:    postgresql.org/message-id/16619-aaba10f83fdc1c3c@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, andrewbille@gmail.com
  Subject: Re: BUG #16619: Amcheck detects corruption in hstore' btree index (ver 2)
  In-Reply-To: <16619-aaba10f83fdc1c3c@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox