Skip to content

Liquibase migration fails on fresh install: "column 'id' of relation 'thesaurus_dcterms' already exists" #135

@hakimalem

Description

@hakimalem

Environment

  • Opentheso version: v25.11.02
  • Database: PostgreSQL 15
  • Deployment: Docker (docker-compose)
  • Installation type: Fresh installation (empty database)

Error Message

liquibase.exception.MigrationFailedException: Migration failed for changeset 
changelog/v23.07.3/001-update_thesaurus_dcterms.xml::dropPrimaryKeyThesaurusDcterms::Miled:
Reason: liquibase.exception.DatabaseException: ERROR: column "id" of relation "thesaurus_dcterms" already exists 
[Failed SQL: (0) ALTER TABLE public.thesaurus_dcterms ADD id BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY]

Steps to Reproduce

  1. Deploy Opentheso 25.11.02 using Docker with a fresh PostgreSQL database
  2. Start the application with default configuration
  3. Application crashes during Liquibase migrations

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions