We’ve ran into a few fights with the delayed column dropping mechanism lately. These are rare issues but they cause a lot of pain, relatively speaking. The question is : is there any way to manually force the columndropper to run? Details of the issues in case anyone is interested: run migrations, then within an hour export the database and try to import it elsewhere. The import will fail because the required triggers in the discourse_functions schema will not exist on the new host. import or attach a new database into a multisite. The migrations will run but the columns will not drop, causing PG::UndefinedColumn errors and causing Discourse to step in and clear the activerecord cache. This keeps on happening for one hour until the delayed drops are executed. Being able to force the delayed drops to run would solve work around all those issues.

You could trick the system into believing that the first migration ran more than one hour ago. spec/components/migration/column_dropper_spec.rb dd810b8b0 UPDATE schema_migration_details SET created_at = :created_at WHERE id = (SELECT MIN(id) FROM schema_migration_details) BTW: This is going to change soon: FEATURE: Post deployment migrations. by tgxworld · Pull Request #6406 · discourse/discourse · GitHub

Maybe @tgxworld or @sam could comment, as they have time.

Our plan is to introduce a new system that is not subject to these issues in the next few weeks, we will announce it on meta when ready

[תמונה] Introducing Post Deployment Migration Development As of FEATURE: Post deployment migrations. (#6406) · discourse/discourse@40fa967 · GitHub, we’re moving away from our delayed drop pattern to remove a column from a table in the database. Inspired by Gitlab’s pattern of post deployment migration, we’ve added the ability to generate and run migrations that can be run after a deployment. SKIP_POST_DEPLOYMENT_MIGRATIONS=1 rake db:migrate -> deploy app servers SKIP_POST_DEPLOYMENT_MIGRATIONS=0 rake db:migrate To generate a post deployment migratio…

Delayed columndropper issues

תמיכה

david (David Taylor) 14 ביוני,‏ 2021,‏ 8:48am 6

נושא		תגובות	צפיות
Introducing Post Deployment Migration Development	0	1701	8 באוקטובר,‏ 2018
Failure to pay attention to SKIP POST DEPLOYMENT MIGRATIONS causes problems Product Support	7	1082	1 באפריל,‏ 2022
Discourse Upgrade from 3.2.0 to 3.3.0 Postgress issue Self-hosting	2	230	24 באוקטובר,‏ 2024
New installation fails on migration Bug	4	1254	14 באפריל,‏ 2020
Recovering from failed/partially applied upgrade Self-hosting	49	3607	12 באוגוסט,‏ 2022

Delayed columndropper issues

נושאים קשורים