coordination #15132: [saga][epic] Better structure of test plans in main.pm
scenario opensuse-Tumbleweed-DVD-x86_64-desktopapps-remote-desktop-xrdp-client1@64bit_virtio shows the not so helpful test suite description "The base test suite is used for job templates defined in YAML documents. It has no settings of its own." as it is defined within https://openqa.opensuse.org/admin/job_templates/1 with only
'' as description. The job template is defined in https://openqa.opensuse.org/admin/job_templates/1 probably due to #60329 but I see it as a problem that we still have the test suite defined in https://openqa.opensuse.org/admin/test_suites . If this problem is there for one job template and test suite I assume the same is the case for other job templates and test suites.
- AC1: Job templates inheriting from "testsuite: null" are not duplicated as test suites
- Check how often test suites are used on o3, if 0 times, delete it (optional: backup in before)
- … if 1 time, ensure it's defined as job template and delete from test suites
- … if multiple times, keep test suite and use in job templates rather than duplicating in job templates inheriting null
Always latest result in this scenario: latest
#2 Updated by tinita over 1 year ago
Getting all testsuites used once:
SELECT ts.id, ts.name, count(*) AS c, STRING_AGG(jt.group_id::character varying, ' ') AS ids FROM job_templates jt INNER JOIN test_suites ts ON jt.test_suite_id=ts.id GROUP BY ts.id, ts.name HAVING COUNT(*) = 1 ORDER BY ts.name;
Getting all testsuites used nowhere:
SELECT ts.id, ts.name FROM test_suites ts LEFT JOIN job_templates jt ON ts.id=jt.test_suite_id WHERE jt.id IS NULL;
#3 Updated by okurz over 1 year ago
- Status changed from New to Workable
Discussed with cdywan and tinita:
tinita please conduct backup of all test suites or the ones you want to delete, save backup to internal share folder, e.g. w3.suse.de. For that copy the data to any computer connected to the Nbg NFS/NIS shares , for example login with ssh to login.suse.de . For o3 you can attach to this ticket, there are no precious regcodes. Then delete all unused test suites (optionally inform users).
For the "test suites just used once" tinita found some users that do not want their test suites to be moved into job group yaml templates so we will leave this point for now.
#4 Updated by tinita over 1 year ago
Today there are 118 testsuites not used in o3. There are two created this week, so I left them out.
Deleted 116 test_suites/test_suite_settings from database.
#6 Updated by okurz over 1 year ago
- Status changed from Workable to Resolved
osd backup is available on https://w3.nue.suse.com/~timueller/osd-testsuites-not-used-2020-05-15.tgz