discourse-mirrors/discourse-translator
0
0
Fork 0
mirror of https://ghfast.top/https://github.com/discourse/discourse-translator.git synced 2026-07-16 11:46:33 +08:00
Code Issues Projects Releases Packages Wiki Activity Actions 1
discourse-translator/db
History
Exact
Alan Guo Xiang Tan 5e833a80ad
DEV: Rerun CreateTranslationIndexes migration (#251) 
The previous version of the migration is not idempotent and can result
in indexes created but marked as "invalid" by Postgres.

Per postgres documentation:

If a problem arises while scanning the table, such as a deadlock or a
uniqueness violation in a unique index,
the CREATE INDEX command will fail but leave behind an "invalid" index.
This index will be ignored for querying
purposes because it might be incomplete; however it will still consume
update overhead. The recommended recovery
  method in such cases is to drop the index and try again to perform
  CREATE INDEX CONCURRENTLY.
2025-03-14 09:39:10 +08:00
..
migrate DEV: Rerun CreateTranslationIndexes migration (#251) 2025-03-14 09:39:10 +08:00