Project

General

Profile

Actions

action #110089

closed

openQA in openQA: openqa_webui failing because postgresql is not installed

Added by tinita over 2 years ago. Updated over 2 years ago.

Status:
Resolved
Priority:
High
Assignee:
Category:
Regressions/Crashes
Target version:
Start date:
2022-04-19
Due date:
2022-05-05
% Done:

0%

Estimated time:

Description

Observation

https://openqa.opensuse.org/tests/2304383#step/openqa_webui/24
https://openqa.opensuse.org/tests/2304383/logfile?filename=serial0.txt

[  123.146447] openqa-webui-daemon[3075]: Error when trying to get the database version: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('dbname=openqa','',...) failed: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
[  123.151651] openqa-webui-daemon[3075]:   Is the server running locally and accepting connections on that socket? at /usr/lib/perl5/vendor_perl/5.34.0/DBIx/Class/Storage/DBI.pm line 1639. at inline delegation in DBIx::Class::DeploymentHandler::VersionStorage::Standard for version_rs->database_version (attribute declared in /usr/lib/perl5/vendor_perl/5.34.0/DBIx/Class/DeploymentHandler/VersionStorage/Standard.pm at line 26) line 18
[  123.163510] openqa-webui-daemon[3075]: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('dbname=openqa','',...) failed: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory

In the logs I can see that openQA-local-db and openQA-worker are not installed, but in a passing test they are.

Suggestions

  • check if the zypper config changed to not install recommended packages anymore
Actions #1

Updated by tinita over 2 years ago

I was pointed to https://github.com/openSUSE/libzypp/blame/master/zypp.conf and the corresponding entry

solver.onlyRequires = false

hasn't been changed in the last 14 years.

Actions #2

Updated by okurz over 2 years ago

This is being discussed in https://suse.slack.com/archives/C028VS8TM2B/p1650384229883899 (started by tinita)

In https://openqa.opensuse.org/tests/2304383#step/openqa_webui/8 one can see that postgresql-server is not installed whereas in the "last good" (that is the last good Tumbleweed build as there are no other changes) in https://openqa.opensuse.org/tests/2302733#step/openqa_webui/8 shows postgresql-server being pulled in.

Actions #3

Updated by okurz over 2 years ago

The video in https://openqa.opensuse.org/tests/2304383/video?filename=video.ogv&t=4.7 shows:

The following package is recommended, but will not be installed due to conflicts or dependency issues:
openQA-local-db

Likely we should just explicitly install openQA-local-db instead of just openQA.

$ openqa-clone-custom-git-refspec https://github.com/os-autoinst/os-autoinst-distri-openQA/pull/83 https://openqa.opensuse.org/tests/2305021

Created job #2306269: openqa-Tumbleweed-dev-x86_64-Build:TW.11108-openqa_install+publish@64bit-2G -> https://openqa.opensuse.org/t2306269

Actions #4

Updated by okurz over 2 years ago

  • Status changed from New to In Progress
Actions #5

Updated by openqa_review over 2 years ago

  • Due date set to 2022-05-05

Setting due date based on mean cycle time of SUSE QE Tools

Actions #6

Updated by tinita over 2 years ago

  • Status changed from In Progress to Resolved

Tests passing again, thanks Oliver.

Actions

Also available in: Atom PDF