Reduced transaction dependencies of logserver automatic index deletion

Details

Detail name Value
Changelog Number 405
Type Improvement
Status Resolved
Fix Versions EXASOL 6.0.7
Resolution Date 2018-01-15

The logserver process (session 4) is responsible for dropping no longer needed indices. To accomplish this, the logserver checks once a day at midnight all indices for their lifetimes. This check read locks every table in the database.

Problem
There is a small chance that these logserver tasks cause user ETL sessions to be forcefully rolled back (transaction conflicts).

Improvement
The index deletion process has been improved to isolate read locking of all tables in a special transaction. Hence dependencies to user transactions are reduced.