Project

General

Profile

Actions

action #157981

open

coordination #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

Added by okurz 7 months ago. Updated 2 months ago.

Status:
Workable
Priority:
Normal
Assignee:
-
Category:
Organisational
Target version:
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

Further details

  • If we loose access to the machine we need the help of EngineeringInfrastructure as only they have access to the VM

Related issues 1 (0 open1 closed)

Copied from openQA Project - action #130594: Upgrade osd webUI host to openSUSE Leap 15.5Resolvedokurz

Actions
Actions #1

Updated by okurz 7 months ago

  • Copied from action #130594: Upgrade osd webUI host to openSUSE Leap 15.5 added
Actions #2

Updated by okurz 7 months ago

  • Subject changed from Upgrade osd webUI host to openSUSE Leap 15.5 to Upgrade osd webUI host to openSUSE Leap 15.6
  • Description updated (diff)
  • Assignee deleted (okurz)
  • Target version changed from Ready to future
Actions #3

Updated by okurz 5 months ago

  • Target version changed from future to Tools - Next
Actions #4

Updated by okurz 3 months 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
Actions #5

Updated by okurz 3 months 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 #6

Updated by okurz 3 months ago

  • Status changed from In Progress to New
  • Assignee deleted (okurz)
Actions #7

Updated by livdywan 2 months ago

  • Subject changed from Upgrade osd webUI host to openSUSE Leap 15.6 to Upgrade osd webUI host to openSUSE Leap 15.6 size:S
  • Description updated (diff)
  • Status changed from New to Workable
Actions

Also available in: Atom PDF