Database index corruption caused by a change in postgres collation
Several self-managed instances have seen index corruption when upgrading their postgresql database to a new operating system, changing the underlying index collation provided by libc. This can happen even when the name of the collation stays the same. These instances see incorrect results from queries involving text-based indexes, and possibly silent of unique index constraints.
Gitlab should improve documentation around postgres upgrades to warn about this scenario, and investigate automatically detecting it and warning the user before corruption can occur.
epic