action #48509
Updated by nicksinger about 5 years ago
Issue to track the update of OSD done by nsinger on 2019-01-23.
Status before deployment:
```
openqa:~ # salt -C 'G@roles:worker' cmd.run 'zypper info os-autoinst openqa-worker| grep -E Status\|Version' |& tee ~/current_versions_per_worker_before_deploy
QA-Power8-4-kvm.qa.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
QA-Power8-5-kvm.qa.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
powerqaworker-qam-1:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
Status : out-of-date (version 4.5.1550570215.0f988d1f-47.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1550584043.5098c32d-1169.1 installed)
openqaworker7.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
malbec.arch.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
openqaworker2.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1550925474.8f5465e5-53.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1550673294.3fb7464e-1175.1 installed)
openqaworker9.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
openqaworker6.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
openqaworker5.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
openqaworker8.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
openqaw1.qa.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
openqaworker13.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
openqaworker3.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
openqaw2.qa.suse.de:
Version : 4.5.1551283945.1b03daca-61.1
Status : out-of-date (version 4.5.1548066416.34c49266-27.1 installed)
Version : 4.6.1551270083.e4f08b0f-1184.1
Status : out-of-date (version 4.6.1548078204.c9f60161-1108.1 installed)
openqaworker-arm-2.suse.de:
Minion did not return. [Not connected]
openqaworker-arm-1.suse.de:
Minion did not return. [Not connected]
```
Manual db backup created with:
```
openqa:/etc # su - postgres -c "pg_dump -Fc openqa -f /var/lib/openqa/backup/nsinger_manual_db_backup-2019-01-23.dump" && mv /var/lib/openqa/backup/nsinger_manual_db_backup-2019-02-28.dump /var/lib/openqa/backup/nsinger_manual_db_backup-2019-01-23.dump /root/
```
Deployment of os-autoinst and openqa-worker package on all workers:
```
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
```
```
TODO
```
And restarting the workers afterwards:
```
salt -C 'G@roles:worker' cmd.run 'systemctl restart openqa-worker@\*'
```
openqa.suse.de webui upgrade:
```
SKIPPED
```
TODO: <del>Checked recent finished jobs. Looks reasonable (recent jobs are able to complete, webui loads and is functional).</del>