I’m trying to create a foreign key relationship with the Topics table. The problem is it is failing in github workflow test environment during tests for the strangest reason, it is trying to access a field from the parent table that no longer exists and was removed in a core migration years ago! T…

The rubocop advice is good, but I don’t think it’s the cause of this error. (the ‘risk’ it mentions refers to locks on high-traffic tables which would affect production traffic. So not something which would cause errors in a test environment) You can probably reproduce the same error locally by doi…

Oh, I’ve been good ole RUBOCOPPED for this :policeman: :police_car: Offenses: db/migrate/20231119010101_create_locations_topic_table.rb:6:7: C: Discourse/NoAddReferenceOrAliasesActiveRecordMigration: AR methods add_reference, add_belongs_to, t.references, and t.belongs_to are high-risk for large t…

Thanks David, I’ll move it to a SQL statement and see if that resolves …

Strange migration error in tests during GH workflow

Development

merefield (Robert) December 1, 2023, 3:08pm 5

That did it, thanks David!

https://github.com/paviliondev/discourse-locations/pull/103/commits/296a890791f6507d35045afbbef7c4e1e98befdf

Topic		Replies	Views
DB migration failure during the last update Bug	1	652	June 4, 2019
Rake db:migrate error Product Support	3	701	May 13, 2019
Bootstrap error: relation "ai_agent_mcp_servers" does not exist -- due to migration id collision Self-hosting	10	360	April 2, 2026
PG Error on rebuild - column "token" of relation "email_tokens" does not exist Self-hosting	12	1860	December 15, 2021
Dev migration error: Discourse AI Development ai	7	276	July 30, 2025

Strange migration error in tests during GH workflow

Related topics