action #51398
Updated by nicksinger almost 5 years ago
Issue to track the update of OSD done by nsinger on 2019-05-13.
Status before deployment:
```
QA-Power8-5-kvm.qa.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1555336742.ebf62298-85.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1555478309.f6dfdd9b-1312.1 installed)
openqaworker2.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaworker9.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaworker5.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaworker8.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaworker7.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaworker6.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaw1.qa.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaworker13.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaworker3.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaw2.qa.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
QA-Power8-4-kvm.qa.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaworker-arm-1.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
openqaworker-arm-2.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
powerqaworker-qam-1:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
malbec.arch.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1551283945.1b03daca-61.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1553272770.feedf299-1267.1 installed)
grenache-1.qa.suse.de:
Version : 4.5.1557391016.927f3d85-93.1
Status : out-of-date (version 4.5.1556542707.91b1f943-90.1 installed)
Version : 4.6.1557507909.f1b4a2fd-1352.1
Status : out-of-date (version 4.6.1556528203.cf2cab01-1330.1 installed)
```
Manual db backup created with:
```
TODO: openqa:~ # su - postgres -c "pg_dump -Fc openqa -f /var/lib/openqa/backup/nsinger_manual_db_backup-2019-05-13.dump" /var/lib/openqa/backup/nsinger_manual_db_backup-2019-04-17.dump" && mv /var/lib/openqa/backup/nsinger_manual_db_backup-2019-05-13.dump /var/lib/openqa/backup/nsinger_manual_db_backup-2019-04-30.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
```
```
RESULT PENDING
```
And restarting the workers afterwards:
```
TODO: salt -C 'G@roles:worker' cmd.run 'systemctl restart openqa-worker@\*'
```
openqa.suse.de webui upgrade:
```
TODO
```
<del>Checked recent finished jobs. Looks reasonable.</del>