PG::UndefinedTable: ERROR: relation "ai_topic_embeddings_1_1" does not exist LINE 3: FROM ai_topic_embeddings_1_1; ^ /home/robert/discourse/plugins/discourse-ai/db/migrate/20240611170905_move_embeddings_to_single_table_per_type.rb:51:in `up' /home/robert/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `block in exec_migration' /home/robert/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration' /home/robert/discourse/lib/migration/safe_migrate.rb:28:in `migrate' /home/robert/discourse/lib/migration/safe_migrate.rb:53:in `migrate' /home/robert/discourse/lib/tasks/db.rake:267:in `block (2 levels) in ' /home/robert/discourse/lib/distributed_mutex.rb:53:in `block in synchronize' /home/robert/discourse/lib/distributed_mutex.rb:49:in `synchronize' /home/robert/discourse/lib/distributed_mutex.rb:49:in `synchronize' /home/robert/discourse/lib/distributed_mutex.rb:34:in `synchronize' /home/robert/discourse/lib/tasks/db.rake:242:in `block in ' /home/robert/.rbenv/versions/3.3.2/bin/bundle:25:in `load' /home/robert/.rbenv/versions/3.3.2/bin/bundle:25:in ` ' Caused by: ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "ai_topic_embeddings_1_1" does not exist (ActiveRecord::StatementInvalid) LINE 3: FROM ai_topic_embeddings_1_1; ^ /home/robert/discourse/plugins/discourse-ai/db/migrate/20240611170905_move_embeddings_to_single_table_per_type.rb:51:in `up' /home/robert/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `block in exec_migration' /home/robert/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration' /home/robert/discourse/lib/migration/safe_migrate.rb:28:in `migrate' /home/robert/discourse/lib/migration/safe_migrate.rb:53:in `migrate' /home/robert/discourse/lib/tasks/db.rake:267:in `block (2 levels) in ' /home/robert/discourse/lib/distributed_mutex.rb:53:in `block in synchronize' /home/robert/discourse/lib/distributed_mutex.rb:49:in `synchronize' /home/robert/discourse/lib/distributed_mutex.rb:49:in `synchronize' /home/robert/discourse/lib/distributed_mutex.rb:34:in `synchronize' /home/robert/discourse/lib/tasks/db.rake:242:in `block in ' /home/robert/.rbenv/versions/3.3.2/bin/bundle:25:in `load' /home/robert/.rbenv/versions/3.3.2/bin/bundle:25:in ` ' Caused by: PG::UndefinedTable: ERROR: relation "ai_topic_embeddings_1_1" does not exist (PG::UndefinedTable) LINE 3: FROM ai_topic_embeddings_1_1; Anyone resolved this? (Running PG 16.3) For now I’ve deleted the plugin, and the rest of the migration go through.

Does this commit address the issue @merefield? https://github.com/discourse/discourse/pull/33943

Checkout this [תמונה] Applied migrations we shouldn't have with discourse-ai Support Just saw there’s a migration called 20240611170905_move_embeddings_to_single_table_per_type which indicate that we applied migrations we shouldn’t have by using the wrong plugin version. I have multiple migrations like this, which refer to the one that shouldn’t be done i think : up 20240807150605 ********** NO FILE ********** up 20240809162837 ********** NO FILE ********** up 20240809163303 ********** NO FILE ********** Is there a way to rollback them ? If there’s a way to …

that’s exactly what @Crypto_and_Co just posted, no idea why it was flagged?? (oh they are now a deleted user, very strange, it was a helpful post!)

very messy but yeah, may require a manual effort …

ooh thanks, I’ll check and revert. appreciate you looking at this!

that worked just great, thanks a bunch @pmusaraj @Falco

Awesome, all props should go to Falco.

שגיאת הגירת מפתחים: Discourse AI

מפתח

merefield (Robert) 30 ביולי,‏ 2025,‏ 1:22pm 8

זה עבד מצוין, תודה רבה @pmusaraj @Falco

נושא		תגובות	צפיות
Applied migrations we shouldn't have with discourse-ai Product Support	2	174	17 בספטמבר,‏ 2024
Can't restore database because migration in the database was in the (missing) discourse-ai plugin Development	2	480	25 במרץ,‏ 2024
Bootstrap error: relation "ai_agent_mcp_servers" does not exist -- due to migration id collision Self-hosting	10	416	2 באפריל,‏ 2026
Updating AI plugin fails Bug ai , fixed	3	262	8 ביולי,‏ 2024
Discourse Topic Deletion Fails With Error Product Support	5	252	7 בדצמבר,‏ 2024

שגיאת הגירת מפתחים: Discourse AI

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