해당 단계를 따라 중복된 사용자를 성공적으로 이름 변경했습니다. 하지만 다시 인덱싱을 시도할 때 이 문제에 직면했습니다.
@sam은 해당 스레드에서 "네, 중복된 행을 삭제해 주세요(nuke the dupe rows)"라고 제안했지만, 다시 인덱싱할 때 발생하는 경고와 오류 메시지 맥락에서 이것이 무엇을 의미하는지 모르겠습니다. 현재 오류는 다음과 같이 계속 증가하고 있습니다:
REINDEX SCHEMA CONCURRENTLY public;
WARNING: cannot reindex invalid index "public.index_incoming_referers_on_path_and_incoming_domain_id_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.incoming_referers_pkey_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_incoming_referers_on_path_and_incoming_domain_id_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_incoming_referers_on_path_and_incoming_domain_id_cc_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_incoming_referers_on_path_and_incoming_domain_id_c_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.incoming_referers_pkey_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_incoming_referers_on_path_and_incoming_domain_id_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.incoming_referers_pkey_ccnew_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_19250_index_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_19250_index_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_19250_index_ccnew_ccnew" concurrently, skipping
ERROR: could not create unique index "index_incoming_referers_on_path_and_incoming_domain_id_ccnew3"
DETAIL: Key (path, incoming_domain_id)=(/votes/, 1165) is duplicated.