Manual migration update?
I've been hit by this issue when upgrading to the latest version during migration:
I believe the reason for this is that
https://github.com/windmill-labs/windmill/blob/main/backend/migrations/20231002123723_notify_delete_config.up.sql
Meanwhile, I've manually created the trigger. But how do I set the "Last migration version" such that the app doesn't try to run this migration again upon startup?
while executing migrations: error returned from database: syntax error at or near "TRIGGER"
I believe the reason for this is that
CREATE OR REPLACE TRIGGER syntax doesn't work in AWS Aurora PG 13. Now upgrading to 14 is something we can do but will need much more effort and testing. https://github.com/windmill-labs/windmill/blob/main/backend/migrations/20231002123723_notify_delete_config.up.sql
Meanwhile, I've manually created the trigger. But how do I set the "Last migration version" such that the app doesn't try to run this migration again upon startup?
GitHub
Open-source developer platform to turn scripts into workflows and UIs. Fastest workflow engine (5x vs Airflow). Open-source alternative to Airplane and Retool. - windmill-labs/windmill