Actions
action #157981
opencoordination #157969: [epic] Upgrade all our infrastructure, e.g. o3+osd workers+webui and production workloads, to openSUSE Leap 15.6
Upgrade osd webUI host to openSUSE Leap 15.6 size:S
Start date:
Due date:
% Done:
0%
Estimated time:
Tags:
Description
Motivation¶
- Need to upgrade machines before EOL of Leap 15.5 and have a consistent environment
Acceptance criteria¶
- AC1: osd webui host runs a clean upgraded openSUSE Leap 15.6 (no failed systemd services, no left over .rpm-new files, etc.)
- AC2: The openQA database runs the default version of PostgreSQL in current Leap
Suggestions¶
- read https://progress.opensuse.org/projects/openqav3/wiki#Distribution-upgrades
- Reserve some time when the instance is only executing a few or no openQA test jobs
- After upgrade reboot and check everything working as expected
- Consider upgrading PostgreSQL according to https://open.qa/docs/#_migrating_postgresql_database_on_opensuse
Further details¶
- If we loose access to the machine we need the help of EngineeringInfrastructure as only they have access to the VM
Updated by okurz 5 months ago
- Copied from action #130594: Upgrade osd webUI host to openSUSE Leap 15.5 added
Updated by okurz 29 days ago
- Status changed from New to In Progress
- Assignee set to okurz
In preparation of the upgrade I am already migrating postgres to 16:
oldver=15 newver=16
zypper in postgresql$newver-server postgresql$newver-contrib
sudo -u postgres /usr/lib/postgresql$newver/bin/initdb --encoding=UTF8 --locale=en_US.UTF-8 --lc-collate=C --lc-ctype=en_US.UTF-8 --lc-messages=C --lc-monetary=C --lc-numeric=C --lc-time=C -D /var/lib/pgsql/data.$newver
sudo -u postgres vimdiff /var/lib/pgsql/data.$oldver/postgresql.conf /var/lib/pgsql/data.$newver/postgresql.conf
sudo -u postgres /usr/lib/postgresql$newver/bin/pg_upgrade --check --link --old-bindir=/usr/lib/postgresql$oldver/bin --new-bindir=/usr/lib/postgresql$newver/bin --old-datadir=/var/lib/pgsql/data.$oldver --new-datadir=/var/lib/pgsql/data.$newver && systemctl stop openqa-webui openqa-scheduler openqa-livehandler openqa-gru postgresql && sudo -u postgres /usr/lib/postgresql$newver/bin/pg_upgrade --link --old-bindir=/usr/lib/postgresql$oldver/bin --new-bindir=/usr/lib/postgresql$newver/bin --old-datadir=/var/lib/pgsql/data.$oldver --new-datadir=/var/lib/pgsql/data.$newver && ln --force --no-dereference --relative --symbolic /var/lib/pgsql/data.$newver /var/lib/pgsql/data && systemctl start postgresql openqa-webui openqa-scheduler openqa-livehandler openqa-gru && sudo -u geekotest psql -c 'select version();' openqa
Updated by okurz 29 days ago ยท Edited
Just prepared. Want to continue after EOB.
EDIT (2024-07-18 19:27Z): Done. Running pgsql 16 now. zypper se --installed-only postgres showed that we also had postgresql13 installed. I removed that but kept postgresql15 for now. Should delete the old data directory after some days without problems.
Actions