Highest Description
There is a new major version (2.1.210) of H2 database, but it is not backwards compatible.
Unfortunately this major upgrade also introduces system tables which directly conflict on three out of our four tables. This means that the database cannot be directly upgraded.
The tables are renamed as DOMAINS -> AAA_DOMAINS, GRANTS -> AAA_GRANTS, ROLES -> AAA_ROLES and USERS -> AAA_USERS.
Note that AAA_DOMAINS.enabled and USERS.enabled are now a BOOLEAN.
Attachments
Issue Links
- is duplicated by
-
AAA-187 aaa datastore failures when writing domain during startup and authentication fails breaking CSIT
-
- Resolved
-
| # | Subject | Branch | Project | Status | CR | V |
|---|---|---|---|---|---|---|
| 100278,19 | Upgrade H2 to 2.1.210 | master | aaa | Status: MERGED | +2 | +1 |
| 101634,1 | Improve H2 store tests | master | aaa | Status: MERGED | +2 | +1 |
| 101746,4 | Clean up RoleStore SQL interactions | master | aaa | Status: ABANDONED | 0 | +1 |
| 101747,8 | Clean up H2 SQL interactions | master | aaa | Status: MERGED | +2 | +1 |
| 101753,4 | Rename H2 database tables | master | aaa | Status: MERGED | +2 | +1 |