action #49187
closed[functional][u] test fails in php7_postgresql (with pgsql11)
0%
Description
Observation¶
openQA test in scenario opensuse-Tumbleweed-DVD-x86_64-textmode@64bit fails in
php7_postgresql
Test suite description¶
Maintainer: okurz
Installation in textmode and selecting the textmode "desktop" during installation.
Reproducible¶
Fails since (at least) Build 20190312 (current job)
Expected result¶
Last good: 20190311 (or more recent)
Further details¶
Always latest result in this scenario: latest
pgsql11 seems already to bring a schema called 'public' which then resutls in an error when trying to create one
Updated by SLindoMansilla about 5 years ago
- Subject changed from test fails in php7_postgresql (with pgsql11) to [functional][u] test fails in php7_postgresql (with pgsql11)
As a result of backlog triaging (see https://progress.opensuse.org/projects/openqatests/wiki#ticket-backlog-triaging for more information).
Please, feel free to adjust the category or the "[label]" if you think different.
Updated by okurz about 5 years ago
- Status changed from New to Workable
- Priority changed from Normal to High
- Target version set to Milestone 24
Updated by szarate about 5 years ago
- Status changed from Workable to Feedback
- Assignee set to szarate
- Target version changed from Milestone 24 to Milestone 23
PostgreSQL comes with the public schema by default, the call to pg_restore blah -1 means that it'd be a single transaction and would expect no errors... Which would be ideal. I think dvdrental database it's just a bit outdated, however it works wonders for the usecase... so, let's just drop the schema public prior to anything else...
https://github.com/os-autoinst/os-autoinst-distri-opensuse/pull/7133
Updated by szarate about 5 years ago
- Related to action #49652: [functional][u] test fails in php7_postgresql - Database get dropped before using it added
Updated by szarate about 5 years ago
- Related to action #49634: [functional][u] test fails in php7_postgresql: schema public does not exist added
Updated by szarate about 5 years ago
- Status changed from Feedback to In Progress
Back to the board again, Need to investigate a bit more in detail what's the difference between versions < 10 and 11. I couldn't find anything quickly on the release notes...
Updated by mlin7442 about 5 years ago
appears in Leap https://openqa.opensuse.org/tests/891466#step/php7_postgresql/112 however we don't have PG11 in Leap
Updated by mgriessmeier about 5 years ago
- Target version changed from Milestone 23 to Milestone 24
moved to M24
Updated by okurz about 5 years ago
This is an autogenerated message for openQA integration by the openqa_review script:
This bug is still referenced in a failing openQA test: textmode
https://openqa.opensuse.org/tests/907789
Updated by okurz almost 5 years ago
This is an autogenerated message for openQA integration by the openqa_review script:
This bug is still referenced in a failing openQA test: textmode
https://openqa.opensuse.org/tests/920490
Updated by okurz almost 5 years ago
This is an autogenerated message for openQA integration by the openqa_review script:
This bug is still referenced in a failing openQA test: textmode
https://openqa.opensuse.org/tests/933987
Updated by mgriessmeier almost 5 years ago
- Target version changed from Milestone 24 to Milestone 25
Updated by okurz almost 5 years ago
This is an autogenerated message for openQA integration by the openqa_review script:
This bug is still referenced in a failing openQA test: textmode
https://openqa.opensuse.org/tests/945401
Updated by ggardet_arm almost 5 years ago
According to the docs, pgsql 11 also uses public schema by default: https://www.postgresql.org/docs/11/ddl-schemas.html#DDL-SCHEMAS-PUBLIC
Updated by ggardet_arm almost 5 years ago
Maybe using --clean or --if-exists flags for pg_restore could help.
Trying --clean flag: https://github.com/os-autoinst/os-autoinst-distri-opensuse/pull/7663
Updated by ggardet_arm almost 5 years ago
--clean flag only failed, but --clean --if-exists combination make it work: https://github.com/os-autoinst/os-autoinst-distri-opensuse/pull/7663
TW x86_64: https://openqa.opensuse.org/tests/956899
TW aarch64: https://openqa.opensuse.org/tests/956898
Updated by mgriessmeier almost 5 years ago
- Target version changed from Milestone 25 to Milestone 26
Updated by szarate almost 5 years ago
- Status changed from In Progress to Resolved
- Assignee changed from szarate to ggardet_arm