QA » openQA Project

observation¶

Trying to add a testsuite to a job group when the scenario is already enabled in another jobgroup (i.e. same machine, arch, etc.) an error with some database backtrace is displayed. Also logfile output:

[Wed Mar  8 11:19:30 2017] [30046:error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR:  duplicate key value violates unique constraint "job_templates_product_id_machine_id_test_suite_id"
DETAIL:  Key (product_id, machine_id, test_suite_id)=(155, 1, 328) already exists. [for Statement "INSERT INTO job_templates ( group_id, machine_id, prio, product_id, t_created, t_updated, test_suite_id) VALUES ( ?, ?, ?, ?, ?, ?, ? ) RETURNING id" with ParamValues: 1='55', 2='1', 3='50', 4='155', 5='2017-03-08 10:19:30', 6='2017-03-08 10:19:30', 7='328'] at /usr/share/openqa/script/../lib/OpenQA/WebAPI/Controller/API/V1/JobTemplate.pm line 111

steps to reproduce¶

• add testsuite to one job group
• add same testsuite with same parameters (i.e. machine, arch) to another job group over webui
• observe error

problem¶

database internals should not be displayed to the user. logfile should not have an error included. This needs to be handled in the UI.

suggestion¶

catch error in webUI.

workaround¶

delete scenario from whatever job group it is used in