重新索引 Postgres 数据库无法为 katello_erratum_packages_eid_nvrea_n_f 创建唯一的索引。

Issue

• 重新索引 Postgres 数据库无法为 katello_erratum_packages_eid_nvrea_n_f 创建唯一的索引。

  # runuser -u postgres -- reindexdb -a
  could not change directory to "/root": Permission denied
  reindexdb: reindexing database "candlepin"
  reindexdb: reindexing database "foreman"
  reindexdb: error: reindexing of database "foreman" failed: ERROR:  could not create unique index 
  "katello_erratum_packages_eid_nvrea_n_f"
  DETAIL:  Key (erratum_id, nvrea, name, filename)=(29867, openblas-openmp64-0.3.3-2.el7.x86_64, openblas- 
  openmp64, 
  openblas-openmp64-0.3.3-2.el7.x86_64.rpm) is duplicated.