Faulty migration in referencedata

Description

When running referencedata migrations on an existing OpenLMIS 3.2 database, one of them fails with the following error:

1 2 3 4 referencedata_1 | Message : ERROR: column "type" contains null values referencedata_1 | Location : db/migration/20180205211153916__add_type_to_dispensables.sql (/file:/service.jar!/BOOT-INF/classes!/db/migration/20180205211153916__add_type_to_dispensables.sql) referencedata_1 | Line : 1 referencedata_1 | Statement : ALTER TABLE referencedata.dispensables ADD COLUMN type text NOT NULL

Desired Behavior

  • migrations need to work for users deploying 3.x

Environment

None

Status

Assignee

Sebastian Brudziński

Reporter

Jakub Kondrat

Labels

None

Story Points

1

Time tracking

16h

Components

Sprint

None

Fix versions

Priority

Blocker