License enforcement for raw and memory data licenses
Details
| Detail name | Value |
|---|---|
| Changelog Number | 3661 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | EXASOL 6.0.7 |
| Resolution Date | 2018-03-06 |
Preface
In Exasol versions up to and including 6.0.6, EXAoperation logs an error message once a day if the raw or memory data size limit of the license has been exceeded. These messages are easily overlooked and hence license agreements inadvertedly violated.
For database RAM licenses, the license limit is already enforced when starting databases.
Strict checking and prevention
Limits on raw and/or memory data usage specified by an Exasol license will be enforced starting with Exasol 6.0.7: When the cumulative data size of all running databases in a cluster exceeds 105% of the limit stated in the license, all databases in that cluster will no longer permit inserting statements. Any INSERT, IMPORT, MERGE or CREATE TABLE AS statement will be rejected with an SQL exception in that state.
Required Actions
To get databases back to normal operation mode, you have to reduce the cumulative data size of running databases below 100% of the limit:
You can achieve this by either shutting down databases or deleting or dropping table data.
More information
For more information on managing license limits please consult this article.
To manage multiple databases under the same license, you can limit the local data size of each instance by using database parameters. See SOL-593 for details on this.
Changed behavior
Raw and memory data licenses are enforced. If license limit is substantially exceeded, databases will refuse inserting data. Please check your license status before you update from 6.0.6 or older. Please refer to https://www.exasol.com/portal/display/DOC/Licenses for more information.
