Project

General

Profile

Actions

action #25610

closed

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

Added by okurz about 7 years ago. Updated over 6 years ago.

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

0%

Estimated time:
Difficulty:

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 1 (0 open1 closed)

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

Actions
Actions #1

Updated by okurz about 7 years ago

  • Assignee set to osukup

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

Actions #2

Updated by osukup about 7 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 ..

Actions #3

Updated by pluskalm about 7 years ago

  • Assignee changed from osukup to emiura
Actions #4

Updated by emiura about 7 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)

Actions #5

Updated by okurz about 7 years ago

  • Target version set to Milestone 13
Actions #6

Updated by emiura about 7 years ago

Seems like the package name changed as well (postgresql10)

Actions #7

Updated by okurz about 7 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.

Actions #8

Updated by emiura almost 7 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';

Actions #9

Updated by okurz almost 7 years ago

Looks reasonable

Actions #10

Updated by okurz almost 7 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?

Actions #11

Updated by emiura almost 7 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?

Actions #12

Updated by okurz almost 7 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.

Actions #13

Updated by okurz almost 7 years ago

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

Updated by okurz almost 7 years ago

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

Updated by okurz over 6 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
Actions #16

Updated by emiura over 6 years ago

  • Status changed from In Progress to Feedback

Log collecting already implemented (by someone else).

Actions #17

Updated by mgriessmeier over 6 years ago

  • Due date changed from 2018-04-10 to 2018-04-24
Actions #18

Updated by mgriessmeier over 6 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?

Actions #19

Updated by emiura over 6 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

Actions #20

Updated by okurz over 6 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.

Actions #21

Updated by emiura over 6 years ago

  • Assignee deleted (emiura)

Unassigned.

Actions #22

Updated by okurz over 6 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

Actions #23

Updated by mgriessmeier over 6 years ago

  • Due date changed from 2018-05-08 to 2018-05-22
Actions #24

Updated by riafarov over 6 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
Actions #25

Updated by SLindoMansilla over 6 years ago

  • Status changed from Workable to In Progress
  • Assignee set to SLindoMansilla
Actions #26

Updated by SLindoMansilla over 6 years ago

  • Status changed from In Progress to Resolved

Blocker resolved.
Module postgresql_server enabled for openSUSE.

Actions

Also available in: Atom PDF