[Pkg-postgresql-public] Bug#854997: Some info on reproducing the case

[Christian Ehrhardt]

Hi,
I was just about to report to Pkg-postgresql-public at lists.alioth.debian.org
when I found that Jeremy already opened a bug. I just started on this, but
still I wanted to share the bit I had.

I hit it while trying to prepare the recent postgres mircorelease for
Ubuntu.
At least the issue seems 100% reproducible with autopkgtests and locally as
well.

The error comes down to
pg_buildext installcheck
[...]
test tablespace               ... FAILED
[...]
ERROR:  could not create unique index "idx_badindex_n"
DETAIL:  Key (n)=(10) is duplicated.
STATEMENT:  CREATE UNIQUE INDEX CONCURRENTLY idx_badindex_n ON tbl_badindex
(n);

Jeremy already pointed out the issue is not specific to Ubuntu, Debian hits
the same in debci with the recent 9.6.2 update, see [1].

As mentioned before the case can be reproduced easily in any Debian/Ubuntu
environment with pg-repack, example:
# prep current debian system
 $ lxc launch  95fba011e3ad debiansid-postgres-fail-stableupdate
 $ lxc exec debiansid-postgres-fail-stableupdate bash
# get packages and source
 $ apt-get install postgresql-9.6-repack postgresql-server-dev-all dpkg-dev
 $ echo "deb-src http://httpredir.debian.org/debian sid main" >>
/etc/apt/sources.list
 $ apt-get update
 $ apt-get source pg-repack
# prep test env
 $ cd pg-repack-1.3.4/
 $ mkdir /tmp/pg-repack-tablespace
 $ chown postgres:postgres /tmp/pg-repack-tablespace
# these two commands you can iterate on when debugging
 $ service postgresql stop
 $ pg_buildext installcheck

On Ubuntu you'd need the ppa [2] I currently test on to trigger it - also
Yakkety is the only releases which has pr-repack atm.

[1]: https://ci.debian.net/packages/p/pg-repack/unstable/amd64/
[2]: https://launchpad.net/~ci-train-ppa-service/+archive/ubuntu/2470


-- 
Christian Ehrhardt
Software Engineer, Ubuntu Server
Canonical Ltd
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20170215/78cce428/attachment.html>