pgsql race condition on databasechangeloglock table creation

Description

When running Liquibase on multiple nodes simultaneously, we hit a race condition on creating the databasechangeloglock table that isn't covered by the fix for CORE-2596. The error returned from the database is:

org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
Detail: Key (typname, typnamespace)=(databasechangeloglock, 16387) already exists.

Environment

PostgreSQL 9.4
RHEL 7

Activity

Show:

Nathan Voxland 
February 19, 2018 at 5:41 AM

I'll look at it more with the next release.

Anne Sullivan 
September 16, 2016 at 7:43 PM

Would it make sense to have native support in CreateTableGenerator for "CREATE TABLE IF NOT EXISTS"?

Details

Reporter

Fix versions

Affects versions

Priority

Created September 16, 2016 at 7:37 PM
Updated August 20, 2019 at 3:22 PM