I ran into this while trying to trigger the previously-reported segfault.
CREATE TABLE t(i) AS SELECT * FROM generate_series(1,9);
CREATE INDEX ON t(i);
[pryzbyj(at)database ~]$ for i in `seq 1 9`; do PGOPTIONS='-cstatement_timeout=9' psql postgres --host /tmp --port 5678 -c "REINDEX INDEX CONCURRENTLY t_i_idx" ; done
ERROR: canceling statement due to statement timeout
ERROR: lock ShareUpdateExclusiveLock on object 14185/47287/0 is already held
[...]
Variations on this seem to leave the locks table (?) or something else in a
Real Bad state, such that I cannot truncate the table or drop it; or at least
commands are unreasonably delayed for minutes, on this otherwise-empty test
cluster.
Justin