action #78438
closedopenQA Project - coordination #80142: [saga][epic] Scale out: Redundant/load-balancing deployments of openQA, easy containers, containers on kubernetes
openQA webui entry "Assigned worker" shows ip instead of names as formerly - manual cleanup work
0%
Description
Motivation¶
Coming up with a nice idea in #77014 (actually before that) we broke the content of the workers table on o3 and osd showing many duplicate entries, for every worker instance where we had an entry with name we now see IP as well. This is confusing and messy as the entries do not automatically go away.
Acceptance criteria¶
- AC1: the webUI workers table on o3 shows only hostnames, not IPv4 addresses
- AC2: Same as AC1 but on osd
Suggestions¶
If possible move all assigned jobs of each IP named worker to name based worker. If not feasible just delete the workers with IP as name
Updated by okurz over 3 years ago
- Copied from action #77014: openQA webui entry "Assigned worker" shows ip instead of names as formerly added
Updated by okurz over 3 years ago
- Status changed from Workable to Resolved
- Assignee set to okurz
I deleted all entries of only IPv4 addresses in the databases of osd as well as all hosts with name "linux-…", e.g. using SQL commands
delete from workers where host ~ 'linux-';
delete from workers where host ~ '10.16';
delete from workers where host ~ 'localhost';
and cleaned up some more older, offline, temporary instances as well as e.g. openqaw1 and openqaworker7
I checked on o3 but there were actually no entries that needed deletion.