Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-13336

Add a script to rebuild all indexes using collations

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2023-11-13
    • None
    • Database setup
    • None

      After upgrading a system running PostgreSQL, it may happen that the versions of libc/icu installed on the system differ from the versions using to build various indexes using collations from those providers. This may in turn cause silent index corruption, as happened with MBS-13333.

      It's an issue both externally (MBVM-90) and in production.

      In order to mitigate this issue, we should provide a script that can be used to rebuild all indexes using collations after a system upgrade has been performed.

            bitmap Michael Wiencek
            bitmap Michael Wiencek
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2023-11-13