Bug #25303
closed
Database tests have non temporary DDL that prevents running them twice
Added by Clark ANDRIANASOLO 3 months ago.
Updated about 2 months ago.
Category:
Architecture - Test
Severity:
Trivial - no functional impact | cosmetic
Effort required:
Very Small
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.
- 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
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
Can't it be made transcient like the other ones ?
- Status changed from New to In progress
- 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
- Status changed from Pending technical review to Pending release
- Fix check changed from To do to Checked
- Status changed from Pending release to Released
This bug has been fixed in Rudder 8.1.7 which was released today.
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by