Migrations not executing in order #1465
Description
Hey eikek,
I just tried migrating from the legacy docker-images to the new ones.
So that means I'm coming from 1.23 straight to 1.34.
When starting I get the following error:
SQL State : 42703
Error Code : 0
Message : ERROR: column "file_id" does not exist
Position: 36
Location : db/fixups/postgresql/V1.33.0__fix_reorganize_files.sql (/opt/file:/opt/docspell-joex-0.34.0/lib/com.github.eikek.docspell-sto
b/fixups/postgresql/V1.33.0__fix_reorganize_files.sql)
Line : 37
Statement : with
missing_ids as (
select file_id from filemeta
except
select file_id as file_id from valid_file_ids)
insert into obsolete_files (file_id)
select file_id from filemeta
where file_id in (select file_id from missing_ids)
The latest entry in flyway_schema_history is this though:
| installed_rank | version | description | type | script | checksum | installed_by | installed_on | execution_time | success |
|---|---|---|---|---|---|---|---|---|---|
| 41 | 1.23.0 | clientsettings | SQL | V1.23.0__clientsettings.sql | 1152128793 | dbuser | 2021-05-30 02:03:55.677365 | 196 | 1 |
I tried manually renaming the id column to file_id, but then I get an error when the 1.26-migration is applied.