Project

General

Profile

action #78438

openQA 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

Added by okurz 8 months ago. Updated 8 months ago.

Status:
Resolved
Priority:
High
Assignee:
Target version:
Start date:
2020-11-05
Due date:
% Done:

0%

Estimated time:

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


Related issues

Copied from openQA Project - action #77014: openQA webui entry "Assigned worker" shows ip instead of names as formerlyWorkable2020-11-05

History

#1 Updated by okurz 8 months ago

  • Copied from action #77014: openQA webui entry "Assigned worker" shows ip instead of names as formerly added

#2 Updated by okurz 8 months ago

  • Estimated time set to 80142.00 h

#3 Updated by okurz 8 months ago

  • Estimated time deleted (80142.00 h)

#4 Updated by okurz 8 months ago

  • Parent task set to #80142

#5 Updated by okurz 8 months 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.

Also available in: Atom PDF