Re: GIN stuck in loop during PITR - Mailing list pgsql-hackers

From Andreas Seltenreich
Subject Re: GIN stuck in loop during PITR
Date
Msg-id 87irnso9j5.fsf@gate450.dyndns.org
Whole thread Raw
In response to Re: GIN stuck in loop during PITR  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: GIN stuck in loop during PITR
List pgsql-hackers
Teodor Sigaev schrob:

> Thanks a lot, applied. Can you describe test suite? It may be useful
> for test more...

Here's a shell script that triggers the bug when I revert the patch.

regards,
andreas

#!/bin/sh

set -x
set -e

PGPORT=5434
CLUSTER="gintest/"
ARCHIVE="gintest-archive/"

[ -d "$ARCHIVE" ] || mkdir "$ARCHIVE"

initdb -D $CLUSTER
cat >> $CLUSTER/postgresql.conf <<EOF
port = $PGPORT
archive_command = 'cp %p $PWD/$ARCHIVE/%f'
EOF

pg_ctl -D $CLUSTER start
sleep 5
createdb
psql <<EOF
create table t(a text);
create index i on t using gin (string_to_array(a, ' '));
checkpoint;
select pg_start_backup('test');
EOF

tar cf gintest.tar $CLUSTER

psql <<EOF
select pg_stop_backup();
insert into t select generate_series(1,1000000);
EOF

pg_ctl -D "$CLUSTER" stop
sleep 5
cp "$CLUSTER/pg_xlog/0"* "$ARCHIVE"
rm -r "$CLUSTER"
tar xf gintest.tar
cat >> "$CLUSTER/recovery.conf" <<EOF
restore_command = 'cp "$PWD/$ARCHIVE"/%f %p'
EOF

pg_ctl -D "$CLUSTER" start

# LOG:  redo starts at 0/3D1740
# LOG:  restored log file "000000010000000000000001" from archive
# LOG:  restored log file "000000010000000000000002" from archive
# [...]
# LOG:  restored log file "00000001000000000000000D" from archive
# LOG:  record with zero length at 0/D085D50
# LOG:  redo done at 0/D085D0C
# LOG:  restored log file "00000001000000000000000D" from archive
# LOG:  archive recovery complete
#
# at this point the startup process is looping in ginbtree.c:findParents()
# 
# (gdb) where
# #0  0x080d9db9 in entryFindChildPtr (btree=0xbfbbba90, page=0xb605a680 "", blkno=1672, storedOff=0) at
ginentrypage.c:246
# #1  0x080dfc31 in findParents (btree=0xbfbbba90, stack=0xbfbbba7c, rootBlkno=0) at ginbtree.c:211
# #2  0x080d8167 in ginContinueSplit (split=0x8469bd8) at ginxlog.c:522
# #3  0x080d81c1 in gin_xlog_cleanup () at ginxlog.c:537
# #4  0x080c9731 in StartupXLOG () at xlog.c:4846
# #5  0x080e9f8e in BootstrapMain (argc=4, argv=0xbfbbbca4) at bootstrap.c:419
# #6  0x0820a484 in StartChildProcess (xlop=2) at postmaster.c:3671
# #7  0x08206add in PostmasterMain (argc=3, argv=0x840cff0) at postmaster.c:968
# #8  0x081b0e32 in main (argc=3, argv=0x840cff0) at main.c:254


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: max(*)
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Compression and on-disk sorting