Database restart when querying session information while IMPORT/EXPORT is active

Details

Detail name Value
Changelog Number 5287
Type Bug
Status Resolved
Affected Versions EXASOL 6.0.5
Fix Versions EXASOL 6.0.6
Resolution Date 2017-11-03

Synopsis
We have discovered a bug in our system which manifests itself by database restarts due to crashes in the controller process when queries on
EXA_DBA/ALL/USER_SESSIONS are run in parallel with ETL queries (IMPORT / EXPORT).

Details
Queries the EXA_DBA/ALL/USER_SESSIONS system tables need to retrieve information about active processes. This bug occurs when retrieving such information about ETL processes and causes a crash in the controller process and consequently a database restart.

Workaround
As a workaround, one should not run queries on EXA_DBA/ALL/USER_SESSIONS when ETL processes are running.