Project

General

Profile

action #25610

[sle][functional][opensuse][u][medium] postgresql96server is hard to investigate on errors / should be enabled on openSUSE

Added by okurz over 2 years ago. Updated about 2 years ago.

Status:
Resolved
Priority:
Normal
Category:
New test
Start date:
2017-09-27
Due date:
2018-05-22
% Done:

0%

Estimated time:
Difficulty:
Duration: 170

Description

Observation

openQA test in scenario sle-15-Leanos-DVD-x86_64-minimal+base@64bit fails in
postgresql96server
with a not so helpful error output. I checked manually and the substate is "exited" instead of running so I created https://bugzilla.suse.com/show_bug.cgi?id=1060639 but I think the output can be improved.

Suggestions

  • add for openSUSE tests as well
  • output the details for crosschecking and don't just be silent if the grep does not match

Further details

Always latest result in this scenario: latest


Related issues

Blocked by openQA Tests - action #27014: [opensuse][functional][u][easy] Add postgresql_server to openSUSE tests (was: Add postgresql96server to openSUSE tests)Resolved2017-10-25

History

#1 Updated by okurz over 2 years ago

  • Assignee set to osukup

osukup: you are the test module maintainer, do you want to do it? otherwise please unassign again

#2 Updated by osukup over 2 years ago

it looks as product bug, on SLE12-Sp3 with almost same version no problem shown ...

maybe try port to systemctl. and use more verbose calls.

for logs suggested by rmax we need extend postfailhook ..

#3 Updated by pluskalm over 2 years ago

  • Assignee changed from osukup to emiura

#4 Updated by emiura over 2 years ago

By the comments on https://bugzilla.suse.com/show_bug.cgi?id=1060639&GoAheadAndLogIn=1, a version that fixes the "SubState=exited" issue was not released yet (tumbleweed)

#5 Updated by okurz over 2 years ago

  • Target version set to Milestone 13

#6 Updated by emiura over 2 years ago

Seems like the package name changed as well (postgresql10)

#7 Updated by okurz over 2 years ago

Yes. I think for the high-level openQA tests we should not carry around the version numbers of specific packages in the test module names at least. I suggest to just call the test modules like "postgresql_server.pm" and such.

#8 Updated by emiura over 2 years ago

  • Status changed from New to In Progress

After some trials and errors, I did put this code in to the test,
assert_script_run 'systemctl show -p ActiveState postgresql.service | grep ActiveState=active || systemctl status postgresql.service';

#9 Updated by okurz over 2 years ago

Looks reasonable

#10 Updated by okurz over 2 years ago

  • Due date set to 2018-03-27
  • Target version changed from Milestone 13 to Milestone 14

Hi emiura, any progress on this? Did you create a pull request for the code? Would you like to keep this ticket or unassign?

#11 Updated by emiura over 2 years ago

okurz wrote:

Hi emiura, any progress on this? Did you create a pull request for the code? Would you like to keep this ticket or unassign?

Hello Okurz. Yes. I did create a pull request: https://github.com/os-autoinst/os-autoinst-distri-opensuse/pull/4030. Is there a standard procedure when someone places a PR?

#12 Updated by okurz over 2 years ago

I see. Well, you are doing the right thing by just mentioning the PR so people can take a look there on what's going on :) Other than this the wiki also describes a bit of process and how we commonly handle tickets. Thanks for your PR.

#13 Updated by okurz over 2 years ago

  • Blocked by action #27014: [opensuse][functional][u][easy] Add postgresql_server to openSUSE tests (was: Add postgresql96server to openSUSE tests) added

#14 Updated by okurz over 2 years ago

  • Due date changed from 2018-03-27 to 2018-04-10
  • Target version changed from Milestone 14 to Milestone 15

#15 Updated by okurz about 2 years ago

  • Subject changed from [sle][functional][qam][opensuse] postgresql96server is hard to investigate on errors / should be enabled on openSUSE to [sle][functional][qam][opensuse][u] postgresql96server is hard to investigate on errors / should be enabled on openSUSE

#16 Updated by emiura about 2 years ago

  • Status changed from In Progress to Feedback

Log collecting already implemented (by someone else).

#17 Updated by mgriessmeier about 2 years ago

  • Due date changed from 2018-04-10 to 2018-04-24

#18 Updated by mgriessmeier about 2 years ago

  • Due date changed from 2018-04-24 to 2018-05-08
  • Target version changed from Milestone 15 to Milestone 16

emiura wrote:

Log collecting already implemented (by someone else).

so can we close this one?
do you have a reference for this?

#19 Updated by emiura about 2 years ago

mgriessmeier wrote:

emiura wrote:

Log collecting already implemented (by someone else).

so can we close this one?
do you have a reference for this?

Yes, I think that it can be closed.

Okurz suggested to add a post_fail_hook. Since I looked at this ticket only later, someone already implemented it on the postgresql test.

https://github.com/os-autoinst/os-autoinst-distri-opensuse/pull/4030

#20 Updated by okurz about 2 years ago

Nope, can not be closed. The log collection was done with

commit b7516099 (okurz/feature/postgres, lord/feature/postgres)
Author: Oliver Kurz okurz@suse.de
Date: Thu Sep 28 16:25:33 2017 +0200

Provide more postgres logs on fail (bsc#1060639)

Verification run: http://lord.arch/tests/511

so what is missing is adding the test to openSUSE.

emiura if you would like to do that, this would be appreciated, else feel free to unassign and we will try to do that.

#21 Updated by emiura about 2 years ago

  • Assignee deleted (emiura)

Unassigned.

#22 Updated by okurz about 2 years ago

  • Subject changed from [sle][functional][qam][opensuse][u] postgresql96server is hard to investigate on errors / should be enabled on openSUSE to [sle][functional][opensuse][u] postgresql96server is hard to investigate on errors / should be enabled on openSUSE
  • Category changed from Enhancement to existing tests to New test
  • Status changed from Feedback to Workable

ok, fine. So we should do it then: Add corresponding tests to o3

#23 Updated by mgriessmeier about 2 years ago

  • Due date changed from 2018-05-08 to 2018-05-22

#24 Updated by riafarov about 2 years ago

  • Subject changed from [sle][functional][opensuse][u] postgresql96server is hard to investigate on errors / should be enabled on openSUSE to [sle][functional][opensuse][u][medium] postgresql96server is hard to investigate on errors / should be enabled on openSUSE

#25 Updated by SLindoMansilla about 2 years ago

  • Status changed from Workable to In Progress
  • Assignee set to SLindoMansilla

#26 Updated by SLindoMansilla about 2 years ago

  • Status changed from In Progress to Resolved

Blocker resolved.
Module postgresql_server enabled for openSUSE.

Also available in: Atom PDF