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.