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