action #64743
closedArgument "DBD::SQLite::st execute failed…" isn't numeric in numeric eq (==) at lib/OpenQA/Worker/Engines/isotovideo.pm line 287
0%
Description
Observation¶
Observed while debugging #64752
Mar 23 01:04:50 openqaworker6 worker[13716]: [debug] [pid:13716] Accepting job 4021897 from openqa.suse.de.
Mar 23 01:04:50 openqaworker6 worker[13716]: [debug] [pid:13716] Setting job 4021897 from openqa.suse.de up
Mar 23 01:04:50 openqaworker6 worker[13716]: [debug] [pid:13716] Preparing Mojo::IOLoop::ReadWriteProcess::Session
Mar 23 01:04:50 openqaworker6 worker[13716]: [info] [pid:13716] +++ setup notes +++
Mar 23 01:04:50 openqaworker6 worker[13716]: [info] [pid:13716] Running on openqaworker6:11 (Linux 4.12.14-lp151.28.36-default #1 SMP Fri Dec 6 13:50:27 UTC 2019 (8f4a495) x86_64)
…
Mar 23 01:04:50 openqaworker6 worker[13716]: [debug] [pid:13716] Found ISO, caching SLE-12-SP1-Server-DVD-x86_64-GM-DVD1.iso
Mar 23 01:04:50 openqaworker6 worker[13716]: [info] [pid:13716] Downloading SLE-12-SP1-Server-DVD-x86_64-GM-DVD1.iso, request #37230 sent to Cache Service
Mar 23 01:04:55 openqaworker6 worker[13716]: [debug] [pid:13716] Updating status so job 4021897 is not considered dead.
Mar 23 01:04:55 openqaworker6 worker[13716]: [debug] [pid:13716] REST-API call: POST http://openqa.suse.de/api/v1/jobs/4021897/status
Mar 23 01:04:55 openqaworker6 worker[13716]: [info] [pid:13716] Download of SLE-12-SP1-Server-DVD-x86_64-GM-DVD1.iso processed
Mar 23 01:04:55 openqaworker6 worker[13716]: [debug] [pid:13716] Linked asset "/var/lib/openqa/cache/openqa.suse.de/SLE-12-SP1-Server-DVD-x86_64-GM-DVD1.iso" to "/var/lib/openqa/pool/11/SLE-12-SP1-Server-DVD-x86_64-GM-DVD1.iso"
Mar 23 01:04:55 openqaworker6 worker[13716]: [info] [pid:13716] Rsync from 'rsync://openqa.suse.de/tests' to '/var/lib/openqa/cache/openqa.suse.de', request #37231 sent to Cache Service
Mar 23 01:05:00 openqaworker6 worker[13716]: [debug] [pid:13716] Updating status so job 4021897 is not considered dead.
Mar 23 01:05:00 openqaworker6 worker[13716]: [debug] [pid:13716] REST-API call: POST http://openqa.suse.de/api/v1/jobs/4021897/status
Mar 23 01:05:01 openqaworker6 worker[13716]: Argument "DBD::SQLite::st execute failed: database disk image is m..." isn't numeric in numeric eq (==) at /usr/share/openqa/script/../lib/OpenQA/Worker/Engines/isotovideo.pm line 287.
currently running openQA-worker 4.6.1584523598.bcf2f2c16
(originally reported by @okurz after being lost due to database issues)
Updated by okurz about 4 years ago
- Assignee set to kraih
right, thx. This one was also what kraih was asking about.
@kraih interested to handle this?
Updated by kraih about 4 years ago
Ok, the underlying cause of the problem was the corrupted SQLite file (which we resolved in another ticket). That caused the sync job in the cache service to store the exception as a string, which isotovideo.pm couldn't handle. The exising code could almost deal with it, so only a small modification is required to handle catastrophic failures more gracefully. I've opened a PR. https://github.com/os-autoinst/openQA/pull/2892
Updated by kraih about 4 years ago
- Status changed from In Progress to Feedback
The PR has been merged.
Updated by okurz about 4 years ago
- Status changed from Feedback to Resolved
I am confident that the fix was effective but I consider a verification by trying to reproduce a corrupted sqlite database too much effort, hence just setting to Resolved. Thanks for the fix.