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.

Resuming of paused queries may fail after WAIT_FOR_COMMITs

Details

Detail name	Value
Changelog Number	4623
Type	Bug
Status	Resolved
Affected Versions	EXASolution 5.0.0
Fix Versions	EXASolution 5.0.20, EXASOL 6.0.2
Resolution Date	2017-06-20

In some cases, the resuming mechanism may fail, causing queries to be paused "forever".

The error can occur, if following conditions are met

Queries often are in WAIT_FOR_COMMIT state
Many queries are running simultaneously
Resource manager pauses and resumes queries

Workaround

Killing the affected query clears the problem.
If the resource manager stops pausing queries, the deadlock resolves itself.

Resuming of paused queries may fail after WAIT_FOR_COMMITs

Details

PRODUCT

RESOURCES