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

[merefield (Robert)]

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 <main>'
/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 <main>'
/home/robert/.rbenv/versions/3.3.2/bin/bundle:25:in `load'
/home/robert/.rbenv/versions/3.3.2/bin/bundle:25:in `<main>'

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 <main>'
/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 <main>'
/home/robert/.rbenv/versions/3.3.2/bin/bundle:25:in `load'
/home/robert/.rbenv/versions/3.3.2/bin/bundle:25:in `<main>'

Caused by:
PG::UndefinedTable: ERROR:  relation "ai_topic_embeddings_1_1" does not exist (PG::UndefinedTable)
LINE 3:       FROM ai_topic_embeddings_1_1;

מישהו פתר את זה?

[jahan_gagan]

Checkout this

Applied migrations we shouldn't have with discourse-ai

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 …

[merefield (Robert)]

זה בדיוק מה ש @Crypto_and_Co פרסם, אין לי מושג למה זה סומן??

[merefield (Robert)]

מאוד מבולגן!

[pmusaraj (Penar Musaraj)]

Does this commit address the issue @merefield?

FIX: Remove old code reference on Discourse AI migration

[merefield (Robert)]

אוי תודה, אני אבדוק ואחזור אליך.
מעריך את הטיפול שלך בנושא!

[merefield (Robert)]

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

[pmusaraj (Penar Musaraj)]

כל הקרדיט מגיע לפאלקו.