Skip to content

Schema verify fails for postgres in catalogue v13

The database update test from 12 to 13 is failing for Postgres.

https://gitlab.cern.ch/cta/CTA/-/jobs/30632414

Waiting for dbupdatetest....................................................................\n
  ERROR: TABLE TAPE from schema has a column named PURCHASE_ORDER that is missing in the catalogue database.
The current Catalogue Schema Version is: 13.0
Schema version : 13.0
Checking indexes...
  SUCCESS
Checking tables, columns and constraints...
  FAILED
Status of the checking : FAILED
  ERROR: TABLE TAPE from schema has a column named PURCHASE_ORDER that is missing in the catalogue database.
  WARNING: Column archive_route.storage_class_id is part of a foreign key constraint but has no index
  WARNING: Column archive_route.tape_pool_id is part of a foreign key constraint but has no index
  WARNING: Column disk_instance_space.disk_instance_name is part of a foreign key constraint but has no index
Error verifying catalogue

The problem has to catalogue/cta-catalogue-schema/migrations/liquibase/postgres/12.0to13.0.sql