action #164940
closedopenqa-in-openqa test fails in worker
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
Updated by okurz about 2 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"
Updated by tinita about 2 months ago
- Status changed from New to In Progress
- Assignee set to tinita
Updated by tinita about 2 months ago
- Related to action #164919: [openqa-in-openqa][osado] test fails in login showing openid login form instead of using fake authentication added
Updated by tinita about 2 months ago
This looks like it is the same issue as #164919
https://openqa.opensuse.org/tests/4382075#step/openqa_bootstrap_container/12
Updated by tinita about 2 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
Updated by tinita about 2 months ago
- Status changed from In Progress to Feedback
https://github.com/os-autoinst/openQA/pull/5821 Fix openqa-bootstrap login
Updated by tinita about 2 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
Updated by tinita about 2 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.