-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Minor
-
Affects Version/s: None
-
Component/s: None
-
None
This column is being converted from a timestamp/date to a bigint/number. Note that timestamps might be off by small amounts during this conversion but any discrepancies will be corrected when the sql cache full sync daemon runs (though it may take more than one run since the daemon limits the time it spends on objects that haven't changed recently). The discrepancies would be due to timestamp/date precision in the database (which would make it off by milliseconds or microseconds) or due to timezone issues with the database client session (which would make it off by a few hours or so).
If anyone is upgrading from 5.13.0-5.13.5 and has more than a few million rows in grouper_sql_cache_mship, they may want to run a script to migrate the data before upgrading. Script will be made available.
In a test Oracle database with 147 million rows in grouper_sql_cache_mship, the conversion took 195 minutes. So if this is done after the upgrade, that would be the time period where the temp change log daemon wouldn't be able to process records.