action #7442
closedCloning a job can lose job settings
Added by dimstar almost 9 years ago. Updated almost 9 years ago.
100%
Description
The job https://openqa.opensuse.org/tests/61594 does not have the variable LIVETEST set to 1, which results in the test failing
This job was cloned from https://openqa.opensuse.org/tests/61517 which had the variable set. So the cloning of a job seems to be able to lose variables on the way.
Updated by coolo almost 9 years ago
[Sat May 9 09:46:15 2015] [debug] duplicating 61517
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00022292 seconds executed: SELECT me.child_job_id, me.parent_job_id, me.dependency FROM job_dependencies me WHERE ( ( dependency = ? AND me.child_job_id = ?
) ): '2', '61517'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00063801 seconds executed: 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 W
HERE ( ( dependency = ? AND me.parent_job_id = ? AND ( state = ? OR state = ? ) ) ): '2', '61517', 'running', 'waiting'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00023413 seconds executed: SELECT me.job_id, me.asset_id, me.created_by, me.t_created, me.t_updated FROM jobs_assets me WHERE ( ( asset_id IN ( SELECT me.as
set_id FROM jobs_assets me WHERE ( ( created_by = ? AND me.job_id = ? ) ) ) AND created_by = ? ) ): '1', '61517', '0'.
[Sat May 9 09:46:15 2015] [debug] BEGIN WORK
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00036192 seconds executed: SELECT me.id, me.key, me.value, me.job_id, me.t_created, me.t_updated FROM job_settings me WHERE ( me.job_id = ? ): '61517'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00056005 seconds executed: INSERT INTO jobs ( group_id, priority, retry_avbl, t_created, t_updated, test) VALUES ( ?, ?, ?, ?, ?, ? ) RETURNING id: '1', '49
', '3', '2015-05-09 07:46:15', '2015-05-09 07:46:15', 'rescue'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00029206 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'DISTRI', '2
015-05-09 07:46:15', '2015-05-09 07:46:15', 'opensuse'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00024891 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'SUSEMIRROR'
, '2015-05-09 07:46:15', '2015-05-09 07:46:15', 'http://openqa.opensuse.org/assets/repo/openSUSE-Tumbleweed-oss-i586-x86_64-Snapshot20150508'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00022793 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'QEMUCPU', '
2015-05-09 07:46:15', '2015-05-09 07:46:15', 'qemu64'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00023293 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'ISO_MAXSIZE
', '2015-05-09 07:46:15', '2015-05-09 07:46:15', '681574400'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00024295 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'FULLURL', '
2015-05-09 07:46:15', '2015-05-09 07:46:15', '1'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00026417 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'REPO_0', '2
015-05-09 07:46:15', '2015-05-09 07:46:15', 'openSUSE-Tumbleweed-oss-i586-x86_64-Snapshot20150508'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00027990 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'FLAVOR', '2
015-05-09 07:46:15', '2015-05-09 07:46:15', 'Rescue-CD'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00026703 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'MACHINE', '2015-05-09 07:46:15', '2015-05-09 07:46:15', '64bit'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00025487 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'VERSION', '2015-05-09 07:46:15', '2015-05-09 07:46:15', 'Tumbleweed'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00025606 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'ISO', '2015-05-09 07:46:15', '2015-05-09 07:46:15', 'openSUSE-Tumbleweed-Rescue-CD-x86_64-Snapshot20150508-Media.iso'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00025988 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'BACKEND', '2015-05-09 07:46:15', '2015-05-09 07:46:15', 'qemu'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00025296 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'NOAUTOLOGIN', '2015-05-09 07:46:15', '2015-05-09 07:46:15', '1'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00025010 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'BUILD', '2015-05-09 07:46:15', '2015-05-09 07:46:15', '20150508'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00035095 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'ARCH', '2015-05-09 07:46:15', '2015-05-09 07:46:15', 'x86_64'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00026011 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'WORKER_CLASS', '2015-05-09 07:46:15', '2015-05-09 07:46:15', 'qemu_x86_64'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00025082 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'LIVECD', '2015-05-09 07:46:15', '2015-05-09 07:46:15', '1'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00024509 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'DESKTOP', '2015-05-09 07:46:15', '2015-05-09 07:46:15', 'xfce'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00024700 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'REBOOTAFTERINSTALL', '2015-05-09 07:46:15', '2015-05-09 07:46:15', '0'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00022602 seconds executed: INSERT INTO job_settings ( job_id, key, t_created, t_updated, value) VALUES ( ?, ?, ?, ?, ? ) RETURNING id: '61594', 'TEST', '2015-05-09 07:46:15', '2015-05-09 07:46:15', 'rescue'.
[Sat May 9 09:46:15 2015] [debug] [DBIx debug] Took 0.00042391 seconds executed: UPDATE jobs SET clone_id = ? WHERE ( ( clone_id IS NULL AND id = ? ) ): '61594', '61517'.
[Sat May 9 09:46:15 2015] [debug] COMMIT
No sign of LIVETEST
Updated by coolo almost 9 years ago
id | key | value | job_id | t_created | t_updated
--------+--------------------+---------------------------------------------------------------------------------------------+--------+---------------------+---------------------
290607 | DISTRI | opensuse | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290606 | SUSEMIRROR | http://openqa.opensuse.org/assets/repo/openSUSE-Tumbleweed-oss-i586-x86_64-Snapshot20150508 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290605 | QEMUCPU | qemu64 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290604 | ISO_MAXSIZE | 681574400 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290603 | FULLURL | 1 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290602 | REPO_0 | openSUSE-Tumbleweed-oss-i586-x86_64-Snapshot20150508 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290601 | FLAVOR | Rescue-CD | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290600 | MACHINE | 64bit | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290599 | TEST | rescue | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290598 | VERSION | Tumbleweed | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290597 | LIVETEST | 1 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290596 | ISO | openSUSE-Tumbleweed-Rescue-CD-x86_64-Snapshot20150508-Media.iso | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290595 | BACKEND | qemu | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290594 | NOAUTOLOGIN | 1 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290593 | BUILD | 20150508 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290592 | ARCH | x86_64 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290591 | WORKER_CLASS | qemu_x86_64 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290590 | LIVECD | 1 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290589 | DESKTOP | xfce | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
290588 | REBOOTAFTERINSTALL | 0 | 61517 | 2015-05-08 21:58:09 | 2015-05-08 21:58:09
(20 rows)
Updated by coolo almost 9 years ago
- Assignee set to oholecek
- Priority changed from Normal to Urgent
https://github.com/os-autoinst/openQA/commit/31cb6afb changed
changed
while (my $js = $settings->next) {
- unless ($js->key eq 'NAME' || $js->key eq 'TEST') {
- unless ($js->key =~ /NAME|TEST|JOBTOKEN/) { push @new_settings, {key => $js->key, value => $js->value}; } }
-> causing exactly this bug.
Updated by oholecek almost 9 years ago
- Category set to Regressions/Crashes
- Status changed from New to In Progress
- % Done changed from 0 to 100
Updated by oholecek almost 9 years ago
- Status changed from In Progress to Resolved