Project

General

Profile

Actions

action #164940

closed

openqa-in-openqa test fails in worker

Added by tinita 5 months ago. Updated 5 months ago.

Status:
Resolved
Priority:
High
Assignee:
Category:
Regressions/Crashes
Target version:
Start date:
2024-08-05
Due date:
% Done:

0%

Estimated time:

Description

Observation

openQA test in scenario openqa-Tumbleweed-dev-x86_64-openqa_from_bootstrap@64bit-2G fails in
worker

Liv already located the actual culprit: https://openqa.opensuse.org/tests/4382572#step/openqa_webui/5

ERROR: insert or update on table "api_keys" violates foreign key constraint "api_keys_fk_user_id"
...

Test suite description

Reproducible

Fails since (at least) Build :TW.30390 (current job)

Expected result

Last good: :TW.30389 (or more recent)

Further details

Always latest result in this scenario: latest


Related issues 2 (0 open2 closed)

Related to openQA Tests (public) - action #164919: [openqa-in-openqa][osado] test fails in login showing openid login form instead of using fake authenticationResolvedtinita2024-08-05

Actions
Related to openQA Project (public) - action #162077: Create and maintain up to date version of test distri/needles for webui - enabled by default size:SResolvedmkittler

Actions
Actions #1

Updated by okurz 5 months ago

The complete OCR'd content from the screenshot:

[[ -n 1 ]]

[[ -z 1 ]]

+ hostname
+ grep -q suetest /etc/hosts
+ hostname
+ echo '127.0.0.1 suetest'
+ start-daemons
[[ -z 1 ]]

[[ '' == '
g
h
x
]]
+ systemctl enable --now apache2
Created symlink /etc/systemd/system/httpd.service → /usr/lib/systemd/system/apache2.service'.
Created symlink /etc/systemd/system/apache.service → /usr/lib/systemd/system/apache2.service'.
Created symlink /etc/systemd/system/multi-user.target.wants/apache2.service → /usr/lib/systemd/system/apache2.service'.
+ systemctl enable --now openqa-webui
Created symlink /etc/systemd/system/multi-user.target.wants/openqa-webui.service → /usr/lib/systemd/systemd/system/openqa-webui.service'.
+ systemctl enable --now openqa-scheduler
Created symlink /etc/systemd/system/multi-user.target.wants/openqa-scheduler.service → /usr/lib/systemd/system/openqa-scheduler.service'.
+ curl -sI http://localhost
+ grep 200
+ sleep 3
+ curl -sI http://localhost
+ grep 200
+ sleep 3
+ curl -sI http://localhost
+ grep 200
HTTP/1.1 200 OK
+ curl http://localhost/login
+ hexdump -n 8 -e '2/4 " %08X" 1 " "' /dev/random
++ API_KEY=E7B36B9875025D2E
+ hexdump -n 8 -e '2/4 " %08X" 1 " "' /dev/random
++ API_SECRET=3355A16C1E25F1
+ echo 'INSERT INTO api_keys (key, secret, user_id, t_created, t_updated) VALUES ('\''E7B36B9875025D2E'\'', '\''3355A16C1E25F1'\'', '\''2'\'', NOW(), NOW());'
+ su postgres -c 'psql openqa'
ERROR: insert or update on table "api_keys" violates foreign key constraint "api_keys_fk_user_id"
DETAIL: Key (user_id)=(2) is not present in table "users".

+ start-worker
[[ -z 1 ]]

+ systemctl enable --now openqa-worker@1
Created symlink /etc/systemd/system/multi-user.target.wants/openqa-worker-plain@1.service → /usr/lib/systemd/system/openqa-worker-plain@1.service'.
[[ -n 1 ]]

mind the missing character in "suetest"

Actions #2

Updated by tinita 5 months ago

  • Status changed from New to In Progress
  • Assignee set to tinita
Actions #3

Updated by tinita 5 months ago

  • Related to action #164919: [openqa-in-openqa][osado] test fails in login showing openid login form instead of using fake authentication added
Actions #5

Updated by tinita 5 months ago

I'm currently trying to reproduce it with the latest 20240803 Tumbleweed container and the latest openqa-bootstrap.
I suspect the curl http://localhost/login in openqa-bootstrap fails and doesn't create the demo user.
But I'm getting Repository 'devel_openQA' is invalid. all the time, so I can't really run openqa-bootstrap.

I suspect it could be related to #164595 but not sure yet

Actions #6

Updated by tinita 5 months ago

  • Status changed from In Progress to Feedback
Actions #7

Updated by tinita 5 months ago

  • Related to action #162077: Create and maintain up to date version of test distri/needles for webui - enabled by default size:S added
Actions #8

Updated by tinita 5 months ago

  • Status changed from Feedback to Resolved

After https://github.com/os-autoinst/os-autoinst-distri-openQA/pull/194 the code is using openQA-bootstrap from devel:openQA, so it's passing now.
#164919 has to wait a bit longer until it's been accepted to Tumbleweed.

Actions

Also available in: Atom PDF