Abnormal transaction collisions involving views (no fix)

Details

Detail name Value
Changelog Number 8323
Type Bug
Status Resolved
Affected Versions EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.rc1
Fix Versions Exasol 6.2.0, Exasol 7.0.0, Exasol 6.1.5, Exasol 6.0.17
Resolution Date 2019-07-16

Synopsis
Under circumstances that are yet to be elucidated, transaction collisions may occur and consequently the affected transactions will be rolled back. The error message reads "can't merge view due to changed referenced objects", even though neither the view nor any of its dependents has been altered in the transaction. The affected view will be shown in the EXA_DBA_TRANSACTION conflicts system table.

Occurence rate
The occurence rate is extremely low, this bug popped only once in years.

Workaround
Simply rerunning the transaction should succeed.

Note
The bug has not yet been fixed as we could not reproduce it, however we did ensured that we'll get extended debug infomation which would help us a great deal in reproducing and fixing it should it ever occur again.