Project

General

Profile

passing.log

Passing test - szarate, 2018-04-12 10:05

 
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