Project

General

Profile

action #50264

dbicdh/_common/upgrade/65-66/001-migrate-jobs.pl crashes causing openQA to fail to start

Added by simotek almost 4 years ago. Updated over 3 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Concrete Bugs
Target version:
-
Start date:
2019-04-11
Due date:
% Done:

0%

Estimated time:
Difficulty:

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'.

History

#1 Updated by okurz over 3 years ago

  • Category set to Concrete Bugs

#2 Updated by coolo over 3 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

Also available in: Atom PDF