Errore di migrazione Dev: Discourse AI

[merefield (Robert)]

PG::UndefinedTable: ERRORE: la relazione "ai_topic_embeddings_1_1" non esiste
LINEA 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: ERRORE: la relazione "ai_topic_embeddings_1_1" non esiste (ActiveRecord::StatementInvalid)
LINEA 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: ERRORE: la relazione "ai_topic_embeddings_1_1" non esiste (PG::UndefinedTable)
LINEA 3:       FROM ai_topic_embeddings_1_1;

Qualcuno ha risolto questo problema?

[jahan_gagan]

Dai un’occhiata a questo

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

esattamente quello che @Crypto_and_Co ha appena pubblicato, nessuna idea del perché sia stato segnalato??

[merefield (Robert)]

molto disordinato!

[pmusaraj (Penar Musaraj)]

Questa commit risolve il problema @merefield?

FIX: Remove old code reference on Discourse AI migration

[merefield (Robert)]

oh grazie, controllerò e ti farò sapere.

apprezzo che tu abbia esaminato questo!

[merefield (Robert)]

ha funzionato benissimo, grazie mille @pmusaraj @Falco

[pmusaraj (Penar Musaraj)]

Fantastico, tutti i meriti vanno a Falco.