...
If you see an error in the logs when running DDL, you might be able to ignore it since the upgrade might have worked. e.g.
| Code Block |
|---|
ERROR SqlExceptionHelper.logExceptions(142) - [] - Unknown column 'member0_.subject_identifier1' in 'field list' |
Database upgrades in v2.5
...
| Version | Description | Upgrade type | DDL version | Verify |
|---|
| v2.5.22 | Add password and sync tables, adjust some views |
| 32 | This should not have an error | Code Block |
|---|
select count(1) from grouper_sync |
|
| v2.5.31 | Add recent membership tables and views, add PIT
views, add grouper member columns for USDU |
| 33 | This should not have an error | Code Block |
|---|
select distinct subject_resolution_resolvable from grouper_members;
select count(1) from grouper_recent_mships_load_v; |
|
| v2.5.34 | Add config PIT table and grouper_file table |
| 34 | This should not have an error | Code Block |
|---|
select count(1) from grouper_file; |
|
| v2.5.38 | Add provisioning log and sync start columns |
| 35 | This should not have an error | Code Block |
|---|
select count(1) from grouper_sync_membership_v; |
|
| v2.5.40 | Add provisioning error codes, and provisioning membership view |
| 36 | This should not have an error | Code Block |
|---|
select error_code from grouper_sync_membership; |
|
| v2.5.51 | Add metadata column to grouper_sync_group |
| 37 | This should not have an error | Code Block |
|---|
select count(*) from grouper_sync_group where metadata_json is null; |
|
| v2.6.1 | Add zoom user table, adjust grouper_password columns |
| 38 | This should not have an error | Code Block |
|---|
select count(1) from grouper_prov_zoom_user; |
|
| v2.6.5 | Adjust zoom status col, add table for failsafes, add col for usdu_eligible |
| 39 | This should not have an error | Code Block |
|---|
select count(1) from grouper_members where subject_resolution_eligible is null; |
|
| v2.6.6 | Add subject identifier and email cols to grouper_members, add
metadata_json to grouper_sync_members | Minimal | 40 | This should not have an error | Code Block |
|---|
select count(1) from grouper_members where subject_identifier1 is null; |
|
| v2.6.8 | Create table grouper_prov_duo_user | Minimal | 41 | This should not have an error | Code Block |
|---|
select count(1) from grouper_prov_duo_user; |
|
| v2.6.14 | Add columns job_message_clob and job_message_bytes to grouper_loader_log | Minimal | 42 | This should not have an error | Code Block |
|---|
select * from grouper_loader_log where job_message_clob is null and job_message_bytes is null; |
|
| v2.6.16 | Add table grouper_mship_req_change, add column grouper_members.id_index
Remove foreign keys on grouper_stem_view_privilege | Significant Stop
updates
when
running | 43 | These should not have an error | Code Block |
|---|
select count(1) from grouper_mship_req_change;
select count(1) from grouper_members where id_index is null; |
|
| v2.6.18 | Update columns grouper_attribute_assign.disallowed and grouper_pit_attribute_assign.disallowed to: DEFAULT 'F' NOT NULL | Minimal | 44 |
|
| v5.0.3 | Add grouper_members internal_id column
Add grouper_dictionary table
Add grouper_data_provider table
Add grouper_data_field table
Add grouper_data_row table
Add grouper_data_alias table
Add grouper_data_field_assign table
Add grouper_data_row_assign table
Add grouper_data_row_field_assign table
Add grouper_data_global_assign table
Add grouper_data_field_assign_v view
Add grouper_data_row_assign_v view
Add grouper_data_row_field_asgn_v view | Significant Stop
updates
when
running | 45 | This should not have an error | Code Block |
|---|
select count(1) from grouper_members where internal_id is null;
select count(1) from grouper_dictionary;
select count(1) from grouper_data_provider;
select count(1) from grouper_data_field;
select count(1) from grouper_data_row;
select count(1) from grouper_data_alias;
select count(1) from grouper_data_field_assign;
select count(1) from grouper_data_row_assign;
select count(1) from grouper_data_row_field_assign;
select count(1) from grouper_data_global_assign;
select count(1) from grouper_data_field_assign_v;
select count(1) from grouper_data_row_assign_v;
select count(1) from grouper_data_row_field_asgn_v; |
|
| v5.0.4 | Add grouper_fields internal_id column
Add grouper_sql_cache_group table
Add grouper_sql_cache_mship table
Add grouper_sql_cache_mship_hst table
Add grouper_sql_cache_group_v view
Add grouper_sql_cache_mship_v view
Add grouper_sql_cache_mship_hst_v view | Significant Stop
updates
when
running | 46 | This should not have an error | Code Block |
|---|
select count(1) from grouper_fields where internal_id is null;
select count(1) from grouper_sql_cache_group;
select count(1) from grouper_sql_cache_mship;
select count(1) from grouper_sql_cache_mship_hst;
select count(1) from grouper_sql_cache_group_v;
select count(1) from grouper_sql_cache_mship_v;
select count(1) from grouper_sql_cache_mship_hst_v; |
|
Description
Grouper 2.5+ can handle DDL more efficiently and automatically. DDL can now also change during Grouper build number (previously we kept DDL largely to minor upgrades).
...