|
UPDATE job_modules SET result = ? WHERE ( ( job_id = ? AND result = ? ) ): 'none', '100044', 'running'
|
|
BEGIN WORK
|
|
UPDATE jobs SET result = ?, state = ?, t_finished = ? WHERE ( id = ? ): 'passed', 'done', '2018-04-12 09:12:23', '100044'
|
|
COMMIT
|
|
UPDATE job_modules SET result = ? WHERE ( ( job_id = ? AND result = ? ) ): 'none', '100045', 'running'
|
|
BEGIN WORK
|
|
UPDATE jobs SET result = ?, state = ?, t_finished = ? WHERE ( id = ? ): 'failed', 'done', '2018-04-12 09:12:23', '100045'
|
|
COMMIT
|
|
UPDATE job_modules SET result = ? WHERE ( ( job_id = ? AND result = ? ) ): 'none', '100046', 'running'
|
|
BEGIN WORK
|
|
UPDATE jobs SET result = ?, state = ?, t_finished = ? WHERE ( id = ? ): 'failed', 'done', '2018-04-12 09:12:23', '100046'
|
|
COMMIT
|
|
UPDATE job_modules SET result = ? WHERE ( ( job_id = ? AND result = ? ) ): 'none', '100047', 'running'
|
|
BEGIN WORK
|
|
UPDATE jobs SET result = ?, state = ?, t_finished = ? WHERE ( id = ? ): 'failed', 'done', '2018-04-12 09:12:23', '100047'
|
|
COMMIT
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
BEGIN WORK
|
|
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'
|
|
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:23', '2018-04-12 09:12:23'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'NICTYPE', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'tap'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'KVM', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'KVM'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'ISO', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'whatever.iso'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'ISO_MAXSIZE', '2018-04-12 09:12:23', '2018-04-12 09:12:23', '1'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100048', 'DESKTOP', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'DESKTOP'
|
|
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100048', '100045'
|
|
COMMIT
|
|
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'
|
|
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'
|
|
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100048'
|
|
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'
|
|
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'
|
|
BEGIN WORK
|
|
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100048', '2018-04-12 09:12:23', '2018-04-12 09:12:23'
|
|
COMMIT
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
BEGIN WORK
|
|
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'
|
|
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:23', '2018-04-12 09:12:23'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'ISO', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'whatever.iso'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'KVM', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'KVM'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'NICTYPE', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'tap'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'DESKTOP', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'DESKTOP'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100049', 'ISO_MAXSIZE', '2018-04-12 09:12:23', '2018-04-12 09:12:23', '1'
|
|
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100049', '100046'
|
|
COMMIT
|
|
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'
|
|
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'
|
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100049', '2', '100048'
|
|
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'
|
|
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100049'
|
|
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'
|
|
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'
|
|
BEGIN WORK
|
|
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100049', '2018-04-12 09:12:23', '2018-04-12 09:12:23'
|
|
COMMIT
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
BEGIN WORK
|
|
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'
|
|
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:23', '2018-04-12 09:12:23'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'DESKTOP', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'DESKTOP'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'ISO_MAXSIZE', '2018-04-12 09:12:23', '2018-04-12 09:12:23', '1'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'NICTYPE', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'tap'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'KVM', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'KVM'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100050', 'ISO', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'whatever.iso'
|
|
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100050', '100047'
|
|
COMMIT
|
|
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'
|
|
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'
|
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100050', '2', '100048'
|
|
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'
|
|
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100050'
|
|
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'
|
|
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'
|
|
BEGIN WORK
|
|
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100050', '2018-04-12 09:12:23', '2018-04-12 09:12:23'
|
|
COMMIT
|
|
BEGIN WORK
|
|
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'
|
|
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:23', '2018-04-12 09:12:23'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'KVM', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'KVM'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'NICTYPE', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'tap'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'ISO', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'whatever.iso'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'DESKTOP', '2018-04-12 09:12:23', '2018-04-12 09:12:23', 'DESKTOP'
|
|
INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '100051', 'ISO_MAXSIZE', '2018-04-12 09:12:23', '2018-04-12 09:12:23', '1'
|
|
UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '100051', '100044'
|
|
COMMIT
|
|
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'
|
|
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'
|
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100048', '1', '100051'
|
|
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'
|
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100049', '1', '100051'
|
|
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'
|
|
INSERT INTO job_dependencies ( child_job_id, dependency, parent_job_id) VALUES ( ?, ?, ? ): '100050', '1', '100051'
|
|
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'
|
|
SELECT me.parent_job_id FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ? ) ): '1', '100051'
|
|
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'
|
|
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'
|
|
BEGIN WORK
|
|
INSERT INTO jobs_assets ( asset_id, job_id, t_created, t_updated) VALUES ( ?, ?, ?, ? ): '7', '100051', '2018-04-12 09:12:23', '2018-04-12 09:12:23'
|
|
COMMIT
|
|
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', '100046', '100047', '100044', 'none', 'assigned', 'setup', 'waiting', 'running', 'uploading'
|
|
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', '100046', '100047', '100044', 'assigned', 'setup', 'waiting', 'running', 'uploading'
|
|
[debug] new job 100051
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
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'
|
|
ok 190 - job cloned
|
|
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'
|
|
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'
|
|
ok 191 - job has jobA2 as parent
|
|
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'
|
|
ok 192 - job cloned
|
|
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'
|
|
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'
|
|
ok 193 - job has jobA2 as parent
|
|
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'
|
|
ok 194 - job cloned
|
|
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'
|
|
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'
|
|
ok 195 - job has jobA2 as parent
|
|
ok 196 - job has jobB2 as parallel parent
|
|
ok 197 - job has jobB2 as parallel parent
|
|
# Subtest: slepos test workers
|
|
ok 1 - jobA has a clone
|
|
ok 2 - jobB has a clone
|
|
ok 3 - jobA is Parallel parent of jobB
|
|
ok 4 - cloneA is Parallel parent of cloneB
|
|
ok 5 - jobSUS and jobAS
|
|
ok 6 - jobA has a clone
|
|
ok 7 - jobB has a clone
|
|
ok 8 - jobA is Parallel parent of jobB
|
|
ok 9 - cloneA is Parallel parent of cloneB
|
|
ok 10 - jobSUS and jobIS
|
|
ok 11 - jobA has a clone
|
|
ok 12 - jobB has a clone
|
|
ok 13 - jobA is Parallel parent of jobB
|
|
ok 14 - cloneA is Parallel parent of cloneB
|
|
ok 15 - jobSUS and jobBS
|
|
ok 16 - jobA has a clone
|
|
ok 17 - jobB has a clone
|
|
ok 18 - jobA is Chained parent of jobB
|
|
not ok 19 - cloneA is Chained parent of cloneB
|
|
# Failed test 'cloneA is Chained parent of cloneB'
|
|
# at t/05-scheduler-dependencies.t line 827.
|
|
not ok 20 - jobAS and jobIS
|
|
# Failed test 'jobAS and jobIS'
|
|
# at t/05-scheduler-dependencies.t line 869.
|
|
ok 21 - jobA has a clone
|
|
ok 22 - jobB has a clone
|
|
ok 23 - jobA is Chained parent of jobB
|
|
ok 24 - cloneA is Chained parent of cloneB
|
|
ok 25 - jobAS and jobIS2
|
|
ok 26 - jobA has a clone
|
|
ok 27 - jobB has a clone
|
|
ok 28 - jobA is Parallel parent of jobB
|
|
ok 29 - cloneA is Parallel parent of cloneB
|
|
ok 30 - jobAS and jobBS
|
|
ok 31 - jobA has a clone
|
|
ok 32 - jobB has a clone
|
|
ok 33 - jobA is Parallel parent of jobB
|
|
ok 34 - cloneA is Parallel parent of cloneB
|
|
ok 35 - jobBS and jobT
|
|
1..35
|
|
# Looks like you failed 2 tests of 35.
|
|
not ok 198 - slepos test workers
|
|
# Failed test 'slepos test workers'
|
|
# at t/05-scheduler-dependencies.t line 873.
|
|
ok 199 - no (unexpected) warnings (via done_testing)
|
|
1..199
|
|
# Looks like you failed 1 test of 199.
|
|
Dubious, test returned 1 (wstat 256, 0x100)
|
|
Failed 1/199 subtests
|
|
|
|
Test Summary Report
|
|
-------------------
|
|
t/05-scheduler-dependencies.t (Wstat: 256 Tests: 199 Failed: 1)
|
|
Failed test: 198
|
|
Non-zero exit status: 1
|
|
Files=1, Tests=199, 14 wallclock secs ( 0.06 usr 0.00 sys + 7.43 cusr 0.27 csys = 7.76 CPU)
|
|
Result: FAIL
|
|
|
|
real 18m25.641s
|
|
user 10m41.762s
|
|
sys 0m17.189s
|
|
|