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 11 days 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 11 days 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 11 days 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 11 days ago
- Status changed from In Progress to Feedback
https://github.com/os-autoinst/openQA/pull/5821 Fix openqa-bootstrap login
Updated by tinita 11 days 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 10 days 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.