Skip to content

Geo: A few projects' repository files view never loads

Problem

Postgres streaming replication requires both the primary and the read-replica to run on OSes with compatible C library locale data. Otherwise, the read-replica may return erroneous query results and other incorrect behavior.

See https://wiki.postgresql.org/wiki/Locale_data_changes for details.

Steps to reproduce

  1. Set up a GitLab site with the Postgres database running on a VM on Ubuntu 18.04
  2. Set up a Geo secondary site with the Postgres read-replica DB running on Ubuntu 18.10
  3. Have many projects with Git repositories
  4. Visit each project, and visit Repository > Files
  5. Some projects' files view will spin forever, i.e. never load.
    1. Because a GraphQL query response contains project: null even though the project clearly exists.
    2. Because a SQL query doesn't return results
    3. Because a PG index should be sorted differently on Ubuntu 18.10 vs 18.04

Proposal

Edited by Michael Kozono