Hacktoberfest 2026: los issues que los mantenedores marcaron para octubre, abiertos y aptos para principiantes. Explorar issues de Hacktoberfest

"database "repmgr" has a collation version mismatch"

Abierto
  • ¿Algo no está bien?
#208 2 comentarios 0 reacciones 0 asignados Ver en GitHub

Nadie ha tomado este issue todavía.

Evaluación

Dificultad
4/5
Tiempo estimado
3-5 días
Aptitud para principiantes
28/100
Tipo de issue
Error
Claridad
Necesita aclaración
Estado de actividad
Estancado
Stack tecnológico
postgresql
Área
databases

Línea de trabajo

No se nombran archivos del repositorio ni pruebas; empieza comparando los cambios de imagen entre v0.0.42 y v0.0.43 y siguiendo el comportamiento de inicio de PostgreSQL y repmgrd que se muestra en los registros. Reproduce la actualización con las versiones de intercalación indicadas y, después, determina si el fix debe evitar las advertencias o documentar una ruta de actualización segura, y verifica ese resultado.

Escrito por el modelo de indexación a partir del texto del issue.

Descripción

bug

After updating from v0.0.42 to v0.0.43 with fly image update, my database started spamming the following warning:

repmgrd | WARNING: database "repmgr" has a collation version mismatch
2023-08-21T22:17:51.251 app[32874599c655d8] lax [info] repmgrd | DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.
2023-08-21T22:17:51.251 app[32874599c655d8] lax [info] repmgrd | HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE repmgr REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
2023-08-21T22:17:52.567 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.567 UTC [17285] WARNING: database "postgres" has a collation version mismatch
2023-08-21T22:17:52.567 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.567 UTC [17285] DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.
2023-08-21T22:17:52.567 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.567 UTC [17285] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
2023-08-21T22:17:52.570 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.570 UTC [17287] WARNING: database "repmgr" has a collation version mismatch
2023-08-21T22:17:52.570 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.570 UTC [17287] DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.
2023-08-21T22:17:52.570 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.570 UTC [17287] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE repmgr REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
2023-08-21T22:17:52.810 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.810 UTC [17289] WARNING: database "repmgr" has a collation version mismatch
2023-08-21T22:17:52.810 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.810 UTC [17289] DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.
2023-08-21T22:17:52.810 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.810 UTC [17289] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE repmgr REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
2023-08-21T22:17:52.816 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.815 UTC [17291] WARNING: database "repmgr" has a collation version mismatch
2023-08-21T22:17:52.816 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.815 UTC [17291] DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.
2023-08-21T22:17:52.816 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:52.815 UTC [17291] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE repmgr REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
2023-08-21T22:17:53.254 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:53.253 UTC [17292] WARNING: database "repmgr" has a collation version mismatch
2023-08-21T22:17:53.254 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:53.253 UTC [17292] DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.
2023-08-21T22:17:53.254 app[32874599c655d8] lax [info] postgres | 2023-08-21 22:17:53.253 UTC [17292] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE repmgr REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

Any suggestions on how to address this?

Lenguaje dominante
Go
Estrellas
171
Forks
76
Merge medio
1 h 19 min
PR fusionados (30 d)
1

Preparar el entorno

Aún no hemos revisado los archivos de configuración de este proyecto. Empieza por su README y consulta nuestra guía para la primera contribución para los pasos generales.

Primeros pasos

  1. Lee el issue completo y luego la guía de contribución del proyecto.
  2. Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
  3. Haz un fork del repositorio y trabaja en una rama.
  4. Abre un pull request que haga referencia al número del issue.

Más de fly-apps/postgres-flex

Todos los issues de fly-apps/postgres-flex

Issues similares

Más issues de Go

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.