Dev-Migration-Fehler: Discourse AI

[merefield (Robert)]

PG::UndefinedTable: FEHLER:  Relation „ai_topic_embeddings_1_1“ existiert nicht
ZEILE 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>'

Verursacht durch:
ActiveRecord::StatementInvalid: PG::UndefinedTable: FEHLER:  Relation „ai_topic_embeddings_1_1“ existiert nicht (ActiveRecord::StatementInvalid)
ZEILE 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>'

Verursacht durch:
PG::UndefinedTable: FEHLER:  Relation „ai_topic_embeddings_1_1“ existiert nicht (PG::UndefinedTable)

Hat das jemand gelöst?

[jahan_gagan]

Schau dir das an

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)]

das ist genau das, was @Crypto_and_Co gerade gepostet hat, keine Ahnung, warum es markiert wurde??

[merefield (Robert)]

sehr unordentlich!

[pmusaraj (Penar Musaraj)]

Behebt dieser Commit das Problem, @merefield?

FIX: Remove old code reference on Discourse AI migration

[merefield (Robert)]

Vielen Dank, ich werde nachsehen und mich wieder melden.

Ich weiß es zu schätzen, dass Sie sich das angesehen haben!

[merefield (Robert)]

Das hat super funktioniert, vielen Dank @pmusaraj @Falco

[pmusaraj (Penar Musaraj)]

Großartig, alle Anerkennungen gebühren Falco.