Project

General

Profile

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) [c#x]() 

 Checked <del>Checked recent finished jobs. Looks reasonable. reasonable.</del>

Back