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.

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"
CODE


Impact :

This exception is harmless and will not affect the UUID migration or any Excellentable functionality.