action #50264
closeddbicdh/_common/upgrade/65-66/001-migrate-jobs.pl crashes causing openQA to fail to start
0%
Description
I hadn't used my openQA instance in a long while and after I updated it now crashes trying to migrate
I am running Leap 15.0 with the following 2 repo's enabled
https://download.opensuse.org/repositories/devel:/openQA/openSUSE_Leap_15.0/
http://download.opensuse.org/repositories/devel:/openQA:/Leap:/15.0/openSUSE_Leap_15.0
The error is as follows:
● openqa-webui.service - The openQA web UI
Loaded: loaded (/usr/lib/systemd/system/openqa-webui.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Wed 2019-04-10 12:07:22 ACST; 4h 19min ago
Process: 2725 ExecStart=/usr/share/openqa/script/openqa prefork -m production --proxy -i 100 -H 400 -w 20 -G 800 (code=exited, status=255)
Main PID: 2725 (code=exited, status=255)
CPU: 1.052s
Apr 10 12:07:19 tek-master.simotek.local systemd[1]: Started The openQA web UI.
Apr 10 12:07:22 tek-master.simotek.local openqa[2725]: failed to run Perl in /usr/share/openqa/script/../dbicdh/_common/upgrade/65-66/001-migrate-jobs.pl: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: column me.externally_skipped_module_count does not exist
Apr 10 12:07:22 tek-master.simotek.local openqa[2725]: LINE 1: ...softfailed_module_count, me.skipped_module_count, me.externa...
Apr 10 12:07:22 tek-master.simotek.local openqa[2725]: ^ [for Statement "SELECT me.id, me.result_dir, me.state, me.priority, me.result, me.clone_id, me.blocked_by_id, 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.externally_skipped_module_count, me.t_created, me.t_updated FROM jobs me WHERE ( state = ? )" with ParamValues: 1='scheduled'] at /usr/share/openqa/script/../dbicdh/_common/upgrade/65-66/001-migrate-jobs.pl line 26
Apr 10 12:07:22 tek-master.simotek.local openqa[2725]: DBIx::Class::Storage::TxnScopeGuard::DESTROY(): A DBIx::Class::Storage::TxnScopeGuard went out of scope without explicit commit or error. Rolling back. at /usr/share/openqa/script/openqa line 0
Apr 10 12:07:22 tek-master.simotek.local systemd[1]: openqa-webui.service: Main process exited, code=exited, status=255/n/a
Apr 10 12:07:22 tek-master.simotek.local systemd[1]: openqa-webui.service: Unit entered failed state.
Apr 10 12:07:22 tek-master.simotek.local systemd[1]: openqa-webui.service: Failed with result 'exit-code'.
Updated by coolo over 5 years ago
- Status changed from New to Rejected
Sorry, but I'm afraid instances not updated for 8 months are out of scope of what we support. Just start the instance from scratch