[Pkg-postgresql-public] Bug#854997: Some info on reproducing the case
christian.ehrhardt at canonical.com
Wed Feb 15 09:15:34 UTC 2017
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
At least the issue seems 100% reproducible with autopkgtests and locally as
The error comes down to
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
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 .
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" >>
$ 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  I currently test on to trigger it - also
Yakkety is the only releases which has pr-repack atm.
Software Engineer, Ubuntu Server
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pkg-postgresql-public