Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

Upgrade from 6.0.13 to 6.1.0 requires manual intervention (for IMPORT, EXPORT and priority groups)

Details

Detail name	Value
Changelog Number	7232
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.1.0, Exasol 6.0.13
Fix Versions	Exasol 6.0.14, Exasol 6.1.1
Resolution Date	2019-01-10

Description

The upgrade from 6.0.13 to 6.1.0 should automatically adapt the database but is missing two steps:

The role PUBLIC is not given to the new introduced system privileges IMPORT and EXPORT.
The weights of the priority groups are not adapted.

These steps were planned to avoid changed behavior (coming with EXASOL-2242 and EXASOL-2151) for existing databases. However, due to a bug, these steps were not applied properly after the upgrade.

Please note that this bug only affects upgrading existing databases and only the upgrade from version 6.0.13 to 6.1.0.

Workaround

After the upgrade run the following queries in 6.1.0 manually:

GRANT IMPORT, EXPORT to PUBLIC;
ALTER PRIORITY GROUP LOW    SET WEIGHT = 100;
ALTER PRIORITY GROUP MEDIUM SET WEIGHT = 300;
ALTER PRIORITY GROUP HIGH   SET WEIGHT = 900;

Notes

Choose an upgrade path which does not contain the upgrade from 6.0.13 or higher to 6.1.0. For example 6.0.12 to 6.1.0 and 6.0.13 to 6.1.1 are not affected by this bug.
Please also note that upgrading from 6.1.0 to 6.1.1 does not fix the issue, if the database was upgraded from 6.0.13 to 6.1.0 before. In this case the manual workaround described above must still be used.

Recommended upgrade path

We recommend to upgrade always from the latest 6.0.x to the latest 6.1.x.