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.