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.