Skip to main content

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.






JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.