ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
This content is relevant under the following criteria:
- You have installed Excellentable v4.2.3 or higher on Confluence with Postgres Database
Issue:
The following log message is seen on the backend during installation of Excellentable plugin. This does not have any impact on any of your Excellentables.
CODE
2020-10-14 14:10:26,164 ERROR [pool-62-thread-1] [net.java.ao.sql] handleUpdateError Exception executing SQL update <CREATE TABLE "AO_40ABA8_MIGRATION_STATUS"
(
"ID" VARCHAR(255) NOT NULL,
"MIGRATION_COMPLETED" TIMESTAMP,
"MIGRATION_STARTED" TIMESTAMP,
"STATISTICS" VARCHAR(255),
"STATUS" VARCHAR(255),
"TASK" VARCHAR(255),
"USER" VARCHAR(255),
"VERSION" VARCHAR(255),
PRIMARY KEY("ID")
)
Detail: Key (typname, typnamespace)=(AO_40ABA8_MIGRATION_STATUS, 2200) already exists.
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
Impact :
This exception is harmless and will not affect the UUID migration or any Excellentable functionality.