pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrey Klychkov <aaklychkov@mail.ru>
To: pgsql-bugs@lists.postgresql.org
Date: Tue, 26 May 2020 12:49:32 +0300
Message-ID: <1590486572.205117372@f500.i.mail.ru> (raw)


Centos 8.1, kernel 4.18.0-147.8.1.el8_1.x86_64
PostgreSQL 12.3

I was trying to test execution time of reindexdb command.
I ran the following command several times from the script:
 
# time reindexdb -d ep2_test --concurrently
 
The command broke indexes.

Each time the number of invalid indexes increases.

Output:
1.
WARNING:  cannot reindex system catalogs concurrently, skipping all
reindexdb: error: reindexing of database "ep2_test" failed: ERROR:  could not create unique index "act_uniq_procdef_ccnew"
DETAIL:  Key (key_, version_, tenant_id_)=(com.edisoft.doc.fns.upd.service.act, 3, ) is duplicated.
real    6m18.564s
user    0m0.002s
sys     0m0.003s
2.
WARNING:  cannot reindex system catalogs concurrently, skipping all
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew" concurrently, skipping
reindexdb: error: reindexing of database "ep2_test" failed: ERROR:  could not create unique index "act_uniq_procdef_ccnew1"
DETAIL:  Key (key_, version_, tenant_id_)=(com.edisoft.doc.fns.upd.service.act, 3, ) is duplicated.
real    6m11.914s
user    0m0.003s
sys     0m0.003s
3.
WARNING:  cannot reindex system catalogs concurrently, skipping all
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew1" concurrently, skipping
reindexdb: error: reindexing of database "ep2_test" failed: ERROR:  could not create unique index "act_uniq_procdef_ccnew2"
DETAIL:  Key (key_, version_, tenant_id_)=(com.edisoft.doc.fns.upd.service.act, 3, ) is duplicated.
real    6m28.386s
user    0m0.003s
sys     0m0.002s
4.
WARNING:  cannot reindex system catalogs concurrently, skipping all
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew2" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew2" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew2" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew2" concurrently, skipping
reindexdb: error: reindexing of database "ep2_test" failed: ERROR:  could not create unique index "act_uniq_procdef_ccnew3"
DETAIL:  Key (key_, version_, tenant_id_)=(com.edisoft.doc.fns.upd.service.act, 3, ) is duplicated.
real    6m17.088s
user    0m0.004s
sys     0m0.003s
5.
WARNING:  cannot reindex system catalogs concurrently, skipping all
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew2" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew2" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew2" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_pkey_ccnew3" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_uniq_procdef_ccnew3" concurrently, skipping
WARNING:  cannot reindex invalid index "public.act_re_procdef_deployment_id_idx_ccnew3" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew1" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew2" concurrently, skipping
WARNING:  cannot reindex invalid index "pg_toast.pg_toast_1939707_index_ccnew3" concurrently, skipping
reindexdb: error: reindexing of database "ep2_test" failed: ERROR:  could not create unique index "act_uniq_procdef_ccnew4"
DETAIL:  Key (key_, version_, tenant_id_)=(com.edisoft.doc.fns.upd.service.act, 3, ) is duplicated.
real    6m19.540s
user    0m0.004s
sys     0m0.002s
 
end so on.
 
There were 0 invalid indexes before, after 6 iterations 34 invalid indexes.
 
--
Regards,
Andrew K.

view thread (13+ messages)  latest in thread

Message-ID: <1590486572.205117372@f500.i.mail.ru>
Permalink:  ../1590486572.205117372@f500.i.mail.ru/
Also on:    postgresql.org/message-id/1590486572.205117372@f500.i.mail.ru

 · 

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: aaklychkov@mail.ru, pgsql-bugs@lists.postgresql.org
  Subject: Re: 
  In-Reply-To: <1590486572.205117372@f500.i.mail.ru>

* 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