Invalid timezones are not adjusted during update
Details
| Detail name | Value |
|---|---|
| Changelog Number | 11709 |
| Type | Improvement |
| Status | Open |
Description
Timezones are only rarely removed from the IANA database, but e.g. the US/PACIFIC-NEW timezone was removed from the timezone database that is included in Exasol 7.0.4+ and 6.2.12+.
If a timezone is set for the Exasol cluster, and the cluster is updated to a newer Exasol version, then the timezone that was set will not be changed even if it was removed from the IANA timezone database and is not available in the new Exasol version.
The result is that the database will fail to start until a valid timezone is configured.
Improvement
Better error handling will be implemented to catch this problem early and set a valid timezone or inform the administrator which action has to be taken.