action #110089
closedopenQA in openQA: openqa_webui failing because postgresql is not installed
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
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.
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.
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
Updated by okurz over 2 years ago
- Status changed from New to In Progress
https://github.com/os-autoinst/os-autoinst-distri-openQA/pull/83 created and merged.
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
Updated by tinita over 2 years ago
- Status changed from In Progress to Resolved
Tests passing again, thanks Oliver.