Dev migratiefout: 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;

Heeft iemand dit opgelost?

(Draait PG 16.3)

Voor nu heb ik de plugin verwijderd en de rest van de migratie verloopt soepel.

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

dat is precies wat @Crypto_and_Co zojuist heeft gepost, geen idee waarom het werd gemarkeerd??

(oh ze zijn nu een verwijderde gebruiker, heel vreemd, het was een nuttige post!)

[merefield (Robert)]

erg erg rommelig, maar ja, vereist mogelijk handmatig werk …

[pmusaraj (Penar Musaraj)]

Does this commit address the issue @merefield?

FIX: Remove old code reference on Discourse AI migration

[merefield (Robert)]

ooh bedankt, ik zal het controleren en erop terugkomen.

bedankt dat je hiernaar hebt gekeken!

[merefield (Robert)]

dat werkte prima, bedankt @pmusaraj @Falco

[pmusaraj (Penar Musaraj)]

Geweldig, alle credits gaan naar Falco.