action #54608
Updated by nicksinger over 5 years ago
Issue to track the update of OSD done by nsinger on 2019-07-24.
Status before deployment:
```
openqaworker2.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-lp151.133.1 installed)
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-lp151.1596.1 installed)
openqaworker7.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-lp151.133.1 installed)
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-lp151.1596.1 installed)
openqaworker5.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-lp151.133.1 installed)
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-lp151.1596.1 installed)
openqaworker8.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-lp151.133.1 installed)
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-lp151.1596.1 installed)
openqaw1.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-133.1 installed)
Version : 4.6.1563871579.7a262516-1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-1596.1 installed)
openqaworker9.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-lp151.133.1 installed)
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-lp151.1596.1 installed)
openqaworker6.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-lp151.133.1 installed)
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-lp151.1596.1 installed)
openqaworker3.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-lp151.133.1 installed)
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-lp151.1596.1 installed)
openqaw2.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-133.1 installed)
Version : 4.6.1563871579.7a262516-1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-1596.1 installed)
openqaworker13.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp150.138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-lp150.133.1 installed)
Version : 4.6.1563871579.7a262516-lp150.1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-lp150.1596.1 installed)
powerqaworker-qam-1:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-133.1 installed)
Version : 4.6.1563871579.7a262516-1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-1596.1 installed)
QA-Power8-4-kvm.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-133.1 installed)
Version : 4.6.1563871579.7a262516-1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-1596.1 installed)
openqaworker-arm-2.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-133.1 installed)
Version : 4.6.1563871579.7a262516-1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-1596.1 installed)
openqaworker-arm-1.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-133.1 installed)
Version : 4.6.1563871579.7a262516-1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-1596.1 installed)
QA-Power8-5-kvm.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-133.1 installed)
Version : 4.6.1563871579.7a262516-1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-1596.1 installed)
malbec.arch.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-133.1 installed)
Version : 4.6.1563871579.7a262516-1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-1596.1 installed)
grenache-1.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : out-of-date (version 4.5.1563188951.f6f7c6b3-133.1 installed)
Version : 4.6.1563871579.7a262516-1623.1
Status : out-of-date (version 4.6.1563301283.5bfa647a-1596.1 installed)
```
Manual db backup created with:
```
su - postgres -c "pg_dump -Fc openqa -f /var/lib/openqa/backup/nsinger_manual_db_backup-2019-07-24.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:
```
QA-Power8-4-kvm.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-1623.1
Status : up-to-date
QA-Power8-5-kvm.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-1623.1
Status : up-to-date
powerqaworker-qam-1:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-1623.1
Status : up-to-date
malbec.arch.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-1623.1
Status : up-to-date
grenache-1.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-1623.1
Status : up-to-date
openqaworker2.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : up-to-date
openqaworker5.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : up-to-date
openqaworker7.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : up-to-date
openqaworker6.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : up-to-date
openqaw1.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-1623.1
Status : up-to-date
openqaworker9.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : up-to-date
openqaworker8.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : up-to-date
openqaworker3.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp151.138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-lp151.1623.1
Status : up-to-date
openqaworker-arm-1.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-1623.1
Status : up-to-date
openqaw2.qa.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-1623.1
Status : up-to-date
openqaworker13.suse.de:
Version : 4.5.1563904797.8d4b96b9-lp150.138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-lp150.1623.1
Status : up-to-date
openqaworker-arm-2.suse.de:
Version : 4.5.1563904797.8d4b96b9-138.1
Status : up-to-date
Version : 4.6.1563871579.7a262516-1623.1
Status : up-to-date
``` 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#x](https://progress.opensuse.org/issues/54608#note-x) [c#5](https://progress.opensuse.org/issues/54344#note-5)
<del>Checked Checked recent finished jobs. Looks reasonable.</del> reasonable.