Actions
Bug #25303
closed
Database tests have non temporary DDL that prevents running them twice
Pull Request:
Severity:
Trivial - no functional impact | cosmetic
UX impact:
User visibility:
Effort required:
Very Small
Priority:
0
Name check:
To do
Fix check:
Checked
Regression:
No
Description
We can no longer run database tests in the Webapp more than once, since a non-temporary DDL has been introduced in #24637 :
CREATE TYPE score AS enum ('A', 'B', 'C', 'D', 'E', 'F', 'X');and that is causing the following error when re-running the tests :
org.specs2.specification.core.FatalExecution: ERROR: type "score" already exists.
We should always drop the Type at the end of database tests.
Updated by Clark ANDRIANASOLO 4 months ago
- Subject changed from Database tests have non temporary DDL that prevents running twice to Database tests have non temporary DDL that prevents running them twice
Updated by Clark ANDRIANASOLO 4 months ago
This happens locally, in CI the tests are running only once so the problem is not visible.
Workaround is to DROP DATABASE test; CREATE DATABASE test; ALTER DATABASE test OWNER TO rudder; as postgres user
Updated by François ARMAND 4 months ago
Can't it be made transcient like the other ones ?
Updated by Clark ANDRIANASOLO 4 months ago
- Status changed from New to In progress
Updated by Clark ANDRIANASOLO 4 months ago
- Status changed from In progress to Pending technical review
- Assignee changed from Clark ANDRIANASOLO to François ARMAND
- Pull Request set to https://github.com/Normation/rudder/pull/5813
Updated by Clark ANDRIANASOLO 4 months ago
- Status changed from Pending technical review to Pending release
Applied in changeset rudder|b6b84015788da2bb147f1fbd0a0678662aca3fca.
Updated by Vincent MEMBRÉ 3 months ago
- Status changed from Pending release to Released
This bug has been fixed in Rudder 8.1.7 which was released today.
Actions