action #54344
Updated by nicksinger over 5 years ago
Issue to track the update of OSD done by nsinger on 2019-07-17.
Status before deployment:
```
openqaw1.qa.suse.de:
Version : 4.5.1563188951.f6f7c6b3-133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-131.1 installed)
Version : 4.6.1563301283.5bfa647a-1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-1537.1 installed)
openqaw2.qa.suse.de:
Version : 4.5.1563188951.f6f7c6b3-133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-131.1 installed)
Version : 4.6.1563301283.5bfa647a-1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-1537.1 installed)
openqaworker5.suse.de:
Version : 4.5.1563188951.f6f7c6b3-lp151.133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-lp151.131.1 installed)
Version : 4.6.1563301283.5bfa647a-lp151.1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-lp151.1537.1 installed)
openqaworker7.suse.de:
Version : 4.5.1563188951.f6f7c6b3-lp151.133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-lp151.131.1 installed)
Version : 4.6.1563301283.5bfa647a-lp151.1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-lp151.1537.1 installed)
openqaworker2.suse.de:
Version : 4.5.1563188951.f6f7c6b3-lp151.133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-lp151.131.1 installed)
Version : 4.6.1563301283.5bfa647a-lp151.1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-lp151.1537.1 installed)
openqaworker-arm-1.suse.de:
Version : 4.5.1563188951.f6f7c6b3-133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-131.1 installed)
Version : 4.6.1563301283.5bfa647a-1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-1537.1 installed)
openqaworker9.suse.de:
Version : 4.5.1563188951.f6f7c6b3-lp151.133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-lp151.131.1 installed)
Version : 4.6.1563301283.5bfa647a-lp151.1596.1
Status : out-of-date (version 4.6.1562673882.d37a3c61-lp151.1538.1 installed)
openqaworker8.suse.de:
Version : 4.5.1563188951.f6f7c6b3-lp151.133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-lp151.131.1 installed)
Version : 4.6.1563301283.5bfa647a-lp151.1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-lp151.1537.1 installed)
malbec.arch.suse.de:
Version : 4.5.1563188951.f6f7c6b3-133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-131.1 installed)
Version : 4.6.1563301283.5bfa647a-1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-1537.1 installed)
powerqaworker-qam-1:
Version : 4.5.1563188951.f6f7c6b3-133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-131.1 installed)
Version : 4.6.1563301283.5bfa647a-1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-1537.1 installed)
QA-Power8-4-kvm.qa.suse.de:
Version : 4.5.1563188951.f6f7c6b3-133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-131.1 installed)
Version : 4.6.1563301283.5bfa647a-1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-1537.1 installed)
openqaworker-arm-2.suse.de:
Version : 4.5.1563188951.f6f7c6b3-133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-131.1 installed)
Version : 4.6.1563301283.5bfa647a-1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-1537.1 installed)
openqaworker6.suse.de:
Version : 4.5.1563188951.f6f7c6b3-lp151.133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-lp151.131.1 installed)
Version : 4.6.1563301283.5bfa647a-lp151.1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-lp151.1537.1 installed)
openqaworker13.suse.de:
Version : 4.5.1563188951.f6f7c6b3-lp150.133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-lp150.131.1 installed)
Version : 4.6.1563301283.5bfa647a-lp150.1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-lp150.1537.1 installed)
openqaworker3.suse.de:
Version : 4.5.1563188951.f6f7c6b3-lp151.133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-lp151.131.1 installed)
Version : 4.6.1563301283.5bfa647a-lp151.1596.1
Status : out-of-date (version 4.6.1562673882.d37a3c61-lp151.1539.1 installed)
grenache-1.qa.suse.de:
Version : 4.5.1563188951.f6f7c6b3-133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-131.1 installed)
Version : 4.6.1563301283.5bfa647a-1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-1537.1 installed)
QA-Power8-5-kvm.qa.suse.de:
Version : 4.5.1563188951.f6f7c6b3-133.1
Status : out-of-date (version 4.5.1562413838.c3d5e8ac-131.1 installed)
Version : 4.6.1563301283.5bfa647a-1596.1
Status : out-of-date (version 4.6.1562654601.3adf2e38-1537.1 installed)
```
*Note*: due to the ongoing Leap15.1 migration, some of the workers have different/newer versions already installed.
Manual db backup created with:
```
su - postgres -c "pg_dump -Fc openqa -f /var/lib/openqa/backup/nsinger_manual_db_backup-2019-07-17.dump" && mv /var/lib/openqa/backup/nsinger_manual_db_backup-*.dump /root/
```
Deployment of os-autoinst and openqa-worker package on all workers:
```
TODO: openqa:~ # salt -C 'G@roles:worker' cmd.run 'zypper -n ref && zypper -n up os-autoinst openQA-worker && zypper info os-autoinst openqa-worker| grep -E Status\|Version' |& tee ~/current_versions_per_worker_after_deploy
```
Status after deployment: See [c#3](https://progress.opensuse.org/issues/54344#note-3)
And restarting the workers afterwards:
```
salt -C 'G@roles:worker' cmd.run 'systemctl restart openqa-worker@\*'
```
openqa.suse.de webui upgrade:
See [c#5](https://progress.opensuse.org/issues/54344#note-5)
Checked recent finished jobs. Looks reasonable.