Skip to content

Upgrade 2024.12 --> 2025.05 fails with database version error #4156

@vega82

Description

@vega82

During upgrading Uyuni 2024.12 to 2025.05 following the documentation i got following error:

  1. zypper ref
  2. transactional-update
  3. reboot
  4. mgradm upgrade podman
    DETAIL: The database was created using collation version 2.38, but the operating system provides version 2.41.
    HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE uyuni REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

service uyuni-db status
The service command and the rc* symlinks have been deprecated and
will be removed in a future release.
Please use "systemctl status uyuni-db.service" the next time.
â uyuni-db.service - Uyuni database container service
Loaded: loaded (/etc/systemd/system/uyuni-db.service; enabled; preset: disabled)
Drop-In: /etc/systemd/system/uyuni-db.service.d
ââgenerated.conf
Active: active (running) since Wed 2025-07-09 13:10:26 CEST; 20min ago
Invocation: 2e112a5aae3941ae92b6ecf3ae3d0da4
Main PID: 65425 (conmon)
Tasks: 1 (limit: 77066)
CPU: 246ms
CGroup: /system.slice/uyuni-db.service
ââ65425 /usr/bin/conmon --api-version 1 -c 1bf0d63544a4c7296e6b798a6f54319c7a38c63b2c57c7c6be5d1696d2517104 -u 1bf0d63544a4c7296e6b798a6f54319c7a38c63b2c57c7c6be5d1696d2517104 -r /usr/bin/runc -b /var/lib/containers/storage>

Jul 09 13:29:46 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:29:46.900 CEST [2577]DETAIL: The database was created using collation version 2.38, but the operating system provides version 2.41.
Jul 09 13:29:46 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:29:46.900 CEST [2577]HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE uyuni REFRESH COLLATION VERSION, or build Po>
Jul 09 13:29:51 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:29:51.416 CEST [35]LOG: checkpoint starting: time
Jul 09 13:29:57 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:29:57.604 CEST [35]LOG: checkpoint complete: wrote 58 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.736 s, sync=0.415 s, total=6.189 s; sync>
Jul 09 13:30:06 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:30:06.898 CEST [2592]WARNING: database "reportdb" has a collation version mismatch
Jul 09 13:30:06 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:30:06.898 CEST [2592]DETAIL: The database was created using collation version 2.38, but the operating system provides version 2.41.
Jul 09 13:30:06 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:30:06.898 CEST [2592]HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE reportdb REFRESH COLLATION VERSION, or build>
Jul 09 13:30:26 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:30:26.905 CEST [2607]WARNING: database "postgres" has a collation version mismatch
Jul 09 13:30:26 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:30:26.905 CEST [2607]DETAIL: The database was created using collation version 2.38, but the operating system provides version 2.41.
Jul 09 13:30:26 uyuniserver.local uyuni-db[65425]: 2025-07-09 13:30:26.905 CEST [2607]HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build>

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions