Project

General

Profile

expected_error.log

Expected error can be compared with passing.log - szarate, 2018-04-12 11:24

 
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 10:28:33', '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 10:28:33', '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 10:28:33', '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 10:28:33', '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 = ? ): '100047'
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', '100047'
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.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'
23
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'
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 = ? ): '100044'
25
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'
26
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'
27
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'
28
BEGIN WORK
29
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'
30
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 10:28:33', '2018-04-12 10:28:33'
31
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'KVM', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'KVM'
32
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'ISO_MAXSIZE', '2018-04-12 10:28:33', '2018-04-12 10:28:33', '1'
33
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'DESKTOP', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'DESKTOP'
34
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'ISO', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'whatever.iso'
35
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'NICTYPE', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'tap'
36
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100048', '100045'
37
COMMIT
38
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'
39
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'
40
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100048'
41
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'
42
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'
43
BEGIN WORK
44
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100048', '2018-04-12 10:28:33', '2018-04-12 10:28:33'
45
COMMIT
46
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'
47
BEGIN WORK
48
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'
49
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 10:28:33', '2018-04-12 10:28:33'
50
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'NICTYPE', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'tap'
51
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'ISO', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'whatever.iso'
52
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'DESKTOP', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'DESKTOP'
53
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'ISO_MAXSIZE', '2018-04-12 10:28:33', '2018-04-12 10:28:33', '1'
54
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'KVM', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'KVM'
55
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100049', '100047'
56
COMMIT
57
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'
58
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'
59
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100049', '2', '100048'
60
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'
61
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100049'
62
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'
63
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'
64
BEGIN WORK
65
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100049', '2018-04-12 10:28:33', '2018-04-12 10:28:33'
66
COMMIT
67
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'
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 = ? ): '100046'
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', '100046'
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 = ? ): '100045'
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 = ? ): '100044'
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', '100046'
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 = ? ): '100046'
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-C', '42', NULL, '50', '3', '2018-04-12 10:28:33', '2018-04-12 10:28:33'
76
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'NICTYPE', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'tap'
77
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'ISO_MAXSIZE', '2018-04-12 10:28:33', '2018-04-12 10:28:33', '1'
78
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'KVM', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'KVM'
79
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'ISO', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'whatever.iso'
80
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'DESKTOP', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'DESKTOP'
81
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100050', '100046'
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 10:28:33', '2018-04-12 10:28:33'
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 10:28:33', '2018-04-12 10:28:33'
96
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'NICTYPE', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'tap'
97
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'DESKTOP', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'DESKTOP'
98
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'ISO', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'whatever.iso'
99
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'KVM', '2018-04-12 10:28:33', '2018-04-12 10:28:33', 'KVM'
100
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'ISO_MAXSIZE', '2018-04-12 10:28:33', '2018-04-12 10:28:33', '1'
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 = ? ) ): '100049', '1', '100051'
105
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100049', '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 = ? ) ): '100050', '1', '100051'
107
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100050', '1', '100051'
108
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'
109
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100051'
110
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'
111
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'
112
BEGIN WORK
113
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100051', '2018-04-12 10:28:33', '2018-04-12 10:28:33'
114
COMMIT
115
UPDATE jobs SET result = ? WHERE ( ( ( id != ? AND id IN ( ?, ?, ?, ? ) ) AND result = ? AND ( state = ? OR state = ? OR state = ? OR state = ? OR state = ? ) ) ): 'parallel_restarted', '100044', '100045', '100047', '100046', '100044', 'none', 'assigned', 'setup', 'waiting', 'running', 'uploading'
116
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', '100045', '100047', '100046', '100044', 'assigned', 'setup', 'waiting', 'running', 'uploading'
117
[debug] new job 100051
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 ( me.id = ? ): '100044'
119
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'
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 = ? ): '100046'
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 = ? ): '100047'
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 = ? ): '100048'
123
ok 190 - job cloned
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, 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'
125
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'
126
not ok 191 - job has jobA2 as parent
127
#   Failed test 'job has jobA2 as parent'
128
#   at t/05-scheduler-dependencies.t line 792.
129
#     Structures begin differing at:
130
#          $got->[0] = Does not exist
131
#     $expected->[0] = '100051'
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.id = ? ): '100050'
133
ok 192 - job cloned
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, 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'
135
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'
136
ok 193 - job has jobA2 as parent
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.id = ? ): '100049'
138
ok 194 - job cloned
139
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'
140
ok 195 - job has jobA2 as parent
141
ok 196 - job has jobB2 as parallel parent
142
ok 197 - job has jobB2 as parallel parent
143
# Subtest: slepos test workers
144
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'
145
    ok 1 - jobA has a clone
146
    ok 2 - jobB has a clone
147
    ok 3 - jobA is Parallel parent of jobB
148
    ok 4 - cloneA is Parallel parent of cloneB
149
    ok 5 - jobSUS and jobAS
150
    ok 6 - jobA has a clone
151
    ok 7 - jobB has a clone
152
    ok 8 - jobA is Parallel parent of jobB
153
    ok 9 - cloneA is Parallel parent of cloneB
154
    ok 10 - jobSUS and jobIS
155
    ok 11 - jobA has a clone
156
    ok 12 - jobB has a clone
157
    ok 13 - jobA is Parallel parent of jobB
158
    ok 14 - cloneA is Parallel parent of cloneB
159
    ok 15 - jobSUS and jobBS
160
    ok 16 - jobA has a clone
161
    ok 17 - jobB has a clone
162
    ok 18 - jobA is Chained parent of jobB
163
    ok 19 - cloneA is Chained parent of cloneB
164
    ok 20 - jobAS and jobIS
165
    ok 21 - jobA has a clone
166
    ok 22 - jobB has a clone
167
    ok 23 - jobA is Chained parent of jobB
168
    ok 24 - cloneA is Chained parent of cloneB
169
    ok 25 - jobAS and jobIS2
170
    ok 26 - jobA has a clone
171
    ok 27 - jobB has a clone
172
    ok 28 - jobA is Parallel parent of jobB
173
    ok 29 - cloneA is Parallel parent of cloneB
174
    ok 30 - jobAS and jobBS
175
    ok 31 - jobA has a clone
176
    ok 32 - jobB has a clone
177
    ok 33 - jobA is Parallel parent of jobB
178
    ok 34 - cloneA is Parallel parent of cloneB
179
    ok 35 - jobBS and jobT
180
    1..35
181
ok 198 - slepos test workers
182
ok 199 - no (unexpected) warnings (via done_testing)
183
1..199
184
# Looks like you failed 1 test of 199.
185
Dubious, test returned 1 (wstat 256, 0x100)
186
Failed 1/199 subtests
187

    
188
Test Summary Report
189
-------------------
190
t/05-scheduler-dependencies.t (Wstat: 256 Tests: 199 Failed: 1)
191
  Failed test:  191
192
  Non-zero exit status: 1
193
Files=1, Tests=199, 14 wallclock secs ( 0.06 usr  0.00 sys +  7.52 cusr  0.20 csys =  7.78 CPU)
194
Result: FAIL
195

    
196
real    21m38.573s
197
user    12m44.340s
198
sys     0m19.945s