PostgreSQL vacuum failure during migration from SUSE Multi-Linux Manager 4.3 to 5.0

SUSE Multi-Linux Manager 5.0

Migrating from SUSE Multi-Linux Manager 4.3 to SUSE Multi-Linux Manager 5.0 by using mgradm utility tool, fails with the following error message:

( 52/188) apply upgrade [susemanager-schema-4.3.11-to-susemanager-schema-4.3.12/900-vacuum-analyze.sql.postgresql] .postgresql]
Upgrade failed, please see log [/var/log/spacewalk/schema-upgrade/schema-from-20250516-071648-to-susemanager-schema-5.0.14.log].
You can fix the failed migration in [/var/log/spacewalk/schema-upgrade/schema-from-20250516-071648] and run spacewalk-schema-upgrade again

A review of the end of the schema-upgrade log reveals the following:

psql:<stdin>:2: ERROR:  could not resize shared memory segment "/PostgreSQL.3349103096" to 95413760 bytes: No space left on device

As a workaround, ShmSize to 0 (=unlimited) can be set as a default for the Podman containers to be created.

To do so, create the file /etc/containers/containers.conf on the SUSE MLM 5.0 host with the following content, and run again the migration.

# cat /etc/containers/containers.conf 
[containers]
shm_size = "0"

During the upgrade process, some Podman containers - such as uyuni-finalize-pgsql and uyuni-upgrade-pgsql - are launched on the fly to manage PostgreSQL database migration.

Since ShmSize is not explicitly defined for these containers, the default value of 64 MB is used which may be insufficient and can cause the migration to fail.