refinery_cli: Error: error applying update, db error: ERROR: relation "refinery_schema_history" does not exist

[ababo]

When I try to migrate my PostgreSQL database I get:

Error: `error applying update`, `db error: ERROR: relation "refinery_schema_history" does not exist`

When I inspect the database I see some changes are applied, the refinery_schema_history table is created with no records.

[jxs]

Hi, you need to give more context, do you have a MRE ?

[ababo]

I can't share the existing migration SQL files, but those are PostgreSQL migrations we used with go-migration tool that I have renamed using V{N}__{DESC}.sql naming scheme. Then I run refinery migrate -e DATABASE_URL -p ./migrations -t 6 command and it fails with the message above. The database is populated with types, tables and other objects. The refinery_schema_history table is there as well.

[jxs]

are you changing the schema history table name? There has recently been patched a bug for it, see #313

[ababo]

No, I don't change it.

[jxs]

Then I am sorry, I would gladly try to help further, but without a proper way to reproduce the situation there's not much I think I can do.