|
1
|
UPDATE job_modules SET result = ? WHERE ( ( job_id = ? AND result = ? ) ): 'none', '100044', 'running'
|
|
2
|
BEGIN WORK
|
|
3
|
UPDATE jobs SET result = ?, state = ?, t_finished = ? WHERE ( id = ? ): 'passed', 'done', '2018-04-12 09:12:09', '100044'
|
|
4
|
COMMIT
|
|
5
|
UPDATE job_modules SET result = ? WHERE ( ( job_id = ? AND result = ? ) ): 'none', '100045', 'running'
|
|
6
|
BEGIN WORK
|
|
7
|
UPDATE jobs SET result = ?, state = ?, t_finished = ? WHERE ( id = ? ): 'failed', 'done', '2018-04-12 09:12:09', '100045'
|
|
8
|
COMMIT
|
|
9
|
UPDATE job_modules SET result = ? WHERE ( ( job_id = ? AND result = ? ) ): 'none', '100046', 'running'
|
|
10
|
BEGIN WORK
|
|
11
|
UPDATE jobs SET result = ?, state = ?, t_finished = ? WHERE ( id = ? ): 'failed', 'done', '2018-04-12 09:12:09', '100046'
|
|
12
|
COMMIT
|
|
13
|
UPDATE job_modules SET result = ? WHERE ( ( job_id = ? AND result = ? ) ): 'none', '100047', 'running'
|
|
14
|
BEGIN WORK
|
|
15
|
UPDATE jobs SET result = ?, state = ?, t_finished = ? WHERE ( id = ? ): 'failed', 'done', '2018-04-12 09:12:09', '100047'
|
|
16
|
COMMIT
|
|
17
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me JOIN jobs parent ON parent.id = me.parent_job_id WHERE ( ( dependency IN ( ?, ? ) AND me.child_job_id = ? ) ): '2', '1', '100044'
|
|
18
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me JOIN jobs child ON child.id = me.child_job_id WHERE ( ( dependency IN ( ?, ? ) AND me.parent_job_id = ? ) ): '2', '1', '100044'
|
|
19
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100045'
|
|
20
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me JOIN jobs parent ON parent.id = me.parent_job_id WHERE ( ( dependency IN ( ?, ? ) AND me.child_job_id = ? ) ): '2', '1', '100045'
|
|
21
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100044'
|
|
22
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me JOIN jobs child ON child.id = me.child_job_id WHERE ( ( dependency IN ( ?, ? ) AND me.parent_job_id = ? ) ): '2', '1', '100045'
|
|
23
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100046'
|
|
24
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100047'
|
|
25
|
BEGIN WORK
|
|
26
|
SELECT me.id, me.key, me.value, me.job_id, me.t_created, me.t_updated FROM job_settings me WHERE ( me.job_id = ? ): '100045'
|
|
27
|
INSERT INTO jobs ( ARCH, BUILD, DISTRI, FLAVOR, MACHINE, TEST, VERSION, group_id, priority, retry_avbl, t_created, t_updated) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) RETURNING id: 'x86_64', '666', 'Unicorn', 'pink', 'RainbowPC', '360-B', '42', NULL, '50', '3', '2018-04-12 09:12:09', '2018-04-12 09:12:09'
|
|
28
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'ISO', '2018-04-12 09:12:09', '2018-04-12 09:12:09', 'whatever.iso'
|
|
29
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'ISO_MAXSIZE', '2018-04-12 09:12:09', '2018-04-12 09:12:09', '1'
|
|
30
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'DESKTOP', '2018-04-12 09:12:09', '2018-04-12 09:12:09', 'DESKTOP'
|
|
31
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'KVM', '2018-04-12 09:12:09', '2018-04-12 09:12:09', 'KVM'
|
|
32
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'NICTYPE', '2018-04-12 09:12:09', '2018-04-12 09:12:09', 'tap'
|
|
33
|
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100048', '100045'
|
|
34
|
COMMIT
|
|
35
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100048'
|
|
36
|
SELECT me.id, me.key, me.value, me.job_id, me.t_created, me.t_updated FROM job_settings me WHERE ( me.job_id = ? ): '100048'
|
|
37
|
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100048'
|
|
38
|
SELECT me.id, me.type, me.name, me.size, me.checksum, me.last_use_job_id, me.fixed, me.t_created, me.t_updated FROM assets me WHERE ( ( me.name = ? AND me.type = ? ) ): 'whatever.iso', 'iso'
|
|
39
|
SELECT me.job_id, me.asset_id, me.created_by, me.t_created, me.t_updated FROM jobs_assets me WHERE ( ( me.asset_id = ? AND me.job_id = ? ) ): '7', '100048'
|
|
40
|
BEGIN WORK
|
|
41
|
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100048', '2018-04-12 09:12:09', '2018-04-12 09:12:09'
|
|
42
|
COMMIT
|
|
43
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100046'
|
|
44
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me JOIN jobs parent ON parent.id = me.parent_job_id WHERE ( ( dependency IN ( ?, ? ) AND me.child_job_id = ? ) ): '2', '1', '100046'
|
|
45
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100044'
|
|
46
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100045'
|
|
47
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me JOIN jobs child ON child.id = me.child_job_id WHERE ( ( dependency IN ( ?, ? ) AND me.parent_job_id = ? ) ): '2', '1', '100046'
|
|
48
|
BEGIN WORK
|
|
49
|
SELECT me.id, me.key, me.value, me.job_id, me.t_created, me.t_updated FROM job_settings me WHERE ( me.job_id = ? ): '100046'
|
|
50
|
INSERT INTO jobs ( ARCH, BUILD, DISTRI, FLAVOR, MACHINE, TEST, VERSION, group_id, priority, retry_avbl, t_created, t_updated) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) RETURNING id: 'x86_64', '666', 'Unicorn', 'pink', 'RainbowPC', '360-C', '42', NULL, '50', '3', '2018-04-12 09:12:09', '2018-04-12 09:12:09'
|
|
51
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'ISO', '2018-04-12 09:12:09', '2018-04-12 09:12:09', 'whatever.iso'
|
|
52
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'ISO_MAXSIZE', '2018-04-12 09:12:09', '2018-04-12 09:12:09', '1'
|
|
53
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'KVM', '2018-04-12 09:12:09', '2018-04-12 09:12:09', 'KVM'
|
|
54
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'NICTYPE', '2018-04-12 09:12:09', '2018-04-12 09:12:09', 'tap'
|
|
55
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'DESKTOP', '2018-04-12 09:12:09', '2018-04-12 09:12:09', 'DESKTOP'
|
|
56
|
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100049', '100046'
|
|
57
|
COMMIT
|
|
58
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100049'
|
|
59
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me WHERE ( ( me.child_job_id = ? AND me.dependency = ? AND me.parent_job_id = ? ) ): '100049', '2', '100048'
|
|
60
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100049', '2', '100048'
|
|
61
|
SELECT me.id, me.key, me.value, me.job_id, me.t_created, me.t_updated FROM job_settings me WHERE ( me.job_id = ? ): '100049'
|
|
62
|
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100049'
|
|
63
|
SELECT me.id, me.type, me.name, me.size, me.checksum, me.last_use_job_id, me.fixed, me.t_created, me.t_updated FROM assets me WHERE ( ( me.name = ? AND me.type = ? ) ): 'whatever.iso', 'iso'
|
|
64
|
SELECT me.job_id, me.asset_id, me.created_by, me.t_created, me.t_updated FROM jobs_assets me WHERE ( ( me.asset_id = ? AND me.job_id = ? ) ): '7', '100049'
|
|
65
|
BEGIN WORK
|
|
66
|
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100049', '2018-04-12 09:12:10', '2018-04-12 09:12:10'
|
|
67
|
COMMIT
|
|
68
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100047'
|
|
69
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me JOIN jobs parent ON parent.id = me.parent_job_id WHERE ( ( dependency IN ( ?, ? ) AND me.child_job_id = ? ) ): '2', '1', '100047'
|
|
70
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100044'
|
|
71
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100045'
|
|
72
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me JOIN jobs child ON child.id = me.child_job_id WHERE ( ( dependency IN ( ?, ? ) AND me.parent_job_id = ? ) ): '2', '1', '100047'
|
|
73
|
BEGIN WORK
|
|
74
|
SELECT me.id, me.key, me.value, me.job_id, me.t_created, me.t_updated FROM job_settings me WHERE ( me.job_id = ? ): '100047'
|
|
75
|
INSERT INTO jobs ( ARCH, BUILD, DISTRI, FLAVOR, MACHINE, TEST, VERSION, group_id, priority, retry_avbl, t_created, t_updated) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) RETURNING id: 'x86_64', '666', 'Unicorn', 'pink', 'RainbowPC', '360-D', '42', NULL, '50', '3', '2018-04-12 09:12:10', '2018-04-12 09:12:10'
|
|
76
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'ISO', '2018-04-12 09:12:10', '2018-04-12 09:12:10', 'whatever.iso'
|
|
77
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'NICTYPE', '2018-04-12 09:12:10', '2018-04-12 09:12:10', 'tap'
|
|
78
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'KVM', '2018-04-12 09:12:10', '2018-04-12 09:12:10', 'KVM'
|
|
79
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'DESKTOP', '2018-04-12 09:12:10', '2018-04-12 09:12:10', 'DESKTOP'
|
|
80
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'ISO_MAXSIZE', '2018-04-12 09:12:10', '2018-04-12 09:12:10', '1'
|
|
81
|
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100050', '100047'
|
|
82
|
COMMIT
|
|
83
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100050'
|
|
84
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me WHERE ( ( me.child_job_id = ? AND me.dependency = ? AND me.parent_job_id = ? ) ): '100050', '2', '100048'
|
|
85
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100050', '2', '100048'
|
|
86
|
SELECT me.id, me.key, me.value, me.job_id, me.t_created, me.t_updated FROM job_settings me WHERE ( me.job_id = ? ): '100050'
|
|
87
|
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100050'
|
|
88
|
SELECT me.id, me.type, me.name, me.size, me.checksum, me.last_use_job_id, me.fixed, me.t_created, me.t_updated FROM assets me WHERE ( ( me.name = ? AND me.type = ? ) ): 'whatever.iso', 'iso'
|
|
89
|
SELECT me.job_id, me.asset_id, me.created_by, me.t_created, me.t_updated FROM jobs_assets me WHERE ( ( me.asset_id = ? AND me.job_id = ? ) ): '7', '100050'
|
|
90
|
BEGIN WORK
|
|
91
|
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100050', '2018-04-12 09:12:10', '2018-04-12 09:12:10'
|
|
92
|
COMMIT
|
|
93
|
BEGIN WORK
|
|
94
|
SELECT me.id, me.key, me.value, me.job_id, me.t_created, me.t_updated FROM job_settings me WHERE ( me.job_id = ? ): '100044'
|
|
95
|
INSERT INTO jobs ( ARCH, BUILD, DISTRI, FLAVOR, MACHINE, TEST, VERSION, group_id, priority, retry_avbl, t_created, t_updated) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) RETURNING id: 'x86_64', '666', 'Unicorn', 'pink', 'RainbowPC', '360-A', '42', NULL, '50', '3', '2018-04-12 09:12:10', '2018-04-12 09:12:10'
|
|
96
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'ISO_MAXSIZE', '2018-04-12 09:12:10', '2018-04-12 09:12:10', '1'
|
|
97
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'KVM', '2018-04-12 09:12:10', '2018-04-12 09:12:10', 'KVM'
|
|
98
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'NICTYPE', '2018-04-12 09:12:10', '2018-04-12 09:12:10', 'tap'
|
|
99
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'DESKTOP', '2018-04-12 09:12:10', '2018-04-12 09:12:10', 'DESKTOP'
|
|
100
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'ISO', '2018-04-12 09:12:10', '2018-04-12 09:12:10', 'whatever.iso'
|
|
101
|
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100051', '100044'
|
|
102
|
COMMIT
|
|
103
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100051'
|
|
104
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me WHERE ( ( me.child_job_id = ? AND me.dependency = ? AND me.parent_job_id = ? ) ): '100048', '1', '100051'
|
|
105
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100048', '1', '100051'
|
|
106
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me WHERE ( ( me.child_job_id = ? AND me.dependency = ? AND me.parent_job_id = ? ) ): '100049', '1', '100051'
|
|
107
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100049', '1', '100051'
|
|
108
|
SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me WHERE ( ( me.child_job_id = ? AND me.dependency = ? AND me.parent_job_id = ? ) ): '100050', '1', '100051'
|
|
109
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100050', '1', '100051'
|
|
110
|
SELECT me.id, me.key, me.value, me.job_id, me.t_created, me.t_updated FROM job_settings me WHERE ( me.job_id = ? ): '100051'
|
|
111
|
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100051'
|
|
112
|
SELECT me.id, me.type, me.name, me.size, me.checksum, me.last_use_job_id, me.fixed, me.t_created, me.t_updated FROM assets me WHERE ( ( me.name = ? AND me.type = ? ) ): 'whatever.iso', 'iso'
|
|
113
|
SELECT me.job_id, me.asset_id, me.created_by, me.t_created, me.t_updated FROM jobs_assets me WHERE ( ( me.asset_id = ? AND me.job_id = ? ) ): '7', '100051'
|
|
114
|
BEGIN WORK
|
|
115
|
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100051', '2018-04-12 09:12:10', '2018-04-12 09:12:10'
|
|
116
|
COMMIT
|
|
117
|
UPDATE jobs SET result = ? WHERE ( ( ( id != ? AND id IN ( ?, ?, ?, ? ) ) AND result = ? AND ( state = ? OR state = ? OR state = ? OR state = ? OR state = ? ) ) ): 'parallel_restarted', '100044', '100046', '100047', '100045', '100044', 'none', 'assigned', 'setup', 'waiting', 'running', 'uploading'
|
|
118
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( ( ( id != ? AND id IN ( ?, ?, ?, ? ) ) AND ( state = ? OR state = ? OR state = ? OR state = ? OR state = ? ) ) ): '100044', '100046', '100047', '100045', '100044', 'assigned', 'setup', 'waiting', 'running', 'uploading'
|
|
119
|
[debug] new job 100051
|
|
120
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100044'
|
|
121
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100045'
|
|
122
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100046'
|
|
123
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100047'
|
|
124
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100048'
|
|
125
|
ok 190 - job cloned
|
|
126
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated, settings.id, settings.key, settings.value, settings.job_id, settings.t_created, settings.t_updated, parents.child_job_id, parents.parent_job_id, parents.dependency, children.child_job_id, children.parent_job_id, children.dependency FROM jobs me LEFT JOIN job_settings settings ON settings.job_id = me.id LEFT JOIN job_dependencies parents ON parents.child_job_id = me.id LEFT JOIN job_dependencies children ON children.parent_job_id = me.id WHERE ( me.id = ? ) ORDER BY me.id: '100048'
|
|
127
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.clone_id = ? ): '100048'
|
|
128
|
ok 191 - job has jobA2 as parent
|
|
129
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100049'
|
|
130
|
ok 192 - job cloned
|
|
131
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated, settings.id, settings.key, settings.value, settings.job_id, settings.t_created, settings.t_updated, parents.child_job_id, parents.parent_job_id, parents.dependency, children.child_job_id, children.parent_job_id, children.dependency FROM jobs me LEFT JOIN job_settings settings ON settings.job_id = me.id LEFT JOIN job_dependencies parents ON parents.child_job_id = me.id LEFT JOIN job_dependencies children ON children.parent_job_id = me.id WHERE ( me.id = ? ) ORDER BY me.id: '100049'
|
|
132
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.clone_id = ? ): '100049'
|
|
133
|
ok 193 - job has jobA2 as parent
|
|
134
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.id = ? ): '100050'
|
|
135
|
ok 194 - job cloned
|
|
136
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated, settings.id, settings.key, settings.value, settings.job_id, settings.t_created, settings.t_updated, parents.child_job_id, parents.parent_job_id, parents.dependency, children.child_job_id, children.parent_job_id, children.dependency FROM jobs me LEFT JOIN job_settings settings ON settings.job_id = me.id LEFT JOIN job_dependencies parents ON parents.child_job_id = me.id LEFT JOIN job_dependencies children ON children.parent_job_id = me.id WHERE ( me.id = ? ) ORDER BY me.id: '100050'
|
|
137
|
SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.retry_avbl, me.backend, me.backend_info, me.TEST, me.DISTRI, me.VERSION, me.FLAVOR, me.ARCH, me.BUILD, me.MACHINE, me.group_id, me.assigned_worker_id, me.t_started, me.t_finished, me.logs_present, me.passed_module_count, me.failed_module_count, me.softfailed_module_count, me.skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( me.clone_id = ? ): '100050'
|
|
138
|
ok 195 - job has jobA2 as parent
|
|
139
|
ok 196 - job has jobB2 as parallel parent
|
|
140
|
ok 197 - job has jobB2 as parallel parent
|
|
141
|
# Subtest: slepos test workers
|
|
142
|
ok 1 - jobA has a clone
|
|
143
|
ok 2 - jobB has a clone
|
|
144
|
ok 3 - jobA is Parallel parent of jobB
|
|
145
|
ok 4 - cloneA is Parallel parent of cloneB
|
|
146
|
ok 5 - jobSUS and jobAS
|
|
147
|
ok 6 - jobA has a clone
|
|
148
|
ok 7 - jobB has a clone
|
|
149
|
ok 8 - jobA is Parallel parent of jobB
|
|
150
|
ok 9 - cloneA is Parallel parent of cloneB
|
|
151
|
ok 10 - jobSUS and jobIS
|
|
152
|
ok 11 - jobA has a clone
|
|
153
|
ok 12 - jobB has a clone
|
|
154
|
ok 13 - jobA is Parallel parent of jobB
|
|
155
|
ok 14 - cloneA is Parallel parent of cloneB
|
|
156
|
ok 15 - jobSUS and jobBS
|
|
157
|
ok 16 - jobA has a clone
|
|
158
|
ok 17 - jobB has a clone
|
|
159
|
ok 18 - jobA is Chained parent of jobB
|
|
160
|
ok 19 - cloneA is Chained parent of cloneB
|
|
161
|
ok 20 - jobAS and jobIS
|
|
162
|
ok 21 - jobA has a clone
|
|
163
|
ok 22 - jobB has a clone
|
|
164
|
ok 23 - jobA is Chained parent of jobB
|
|
165
|
ok 24 - cloneA is Chained parent of cloneB
|
|
166
|
ok 25 - jobAS and jobIS2
|
|
167
|
ok 26 - jobA has a clone
|
|
168
|
ok 27 - jobB has a clone
|
|
169
|
ok 28 - jobA is Parallel parent of jobB
|
|
170
|
ok 29 - cloneA is Parallel parent of cloneB
|
|
171
|
ok 30 - jobAS and jobBS
|
|
172
|
ok 31 - jobA has a clone
|
|
173
|
ok 32 - jobB has a clone
|
|
174
|
ok 33 - jobA is Parallel parent of jobB
|
|
175
|
ok 34 - cloneA is Parallel parent of cloneB
|
|
176
|
ok 35 - jobBS and jobT
|
|
177
|
1..35
|
|
178
|
ok 198 - slepos test workers
|
|
179
|
ok 199 - no (unexpected) warnings (via done_testing)
|
|
180
|
1..199
|
|
181
|
ok
|
|
182
|
All tests successful.
|
|
183
|
|