Possible memory corruption caused by system tables accessing large amounts of constraints
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5819 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, EXASolution 5.0.0, Exasol 6.1.0 |
| Fix Versions | Exasol 6.1.0, EXASolution 5.0.22, EXASOL 6.0.9 |
| Resolution Date | 2018-05-14 |
Problem
There is a bug involving system tables accessing constraints (EXA_DBA_CONSTRAINTS, ...) that can lead to rare crashes in sessions that access(ed) those tables.
Conditions
- Several thousand defined primary and foreign key constraints in one database.
- Accessing system tables that reference those constraints
Workaround
As this is unrelated to SQL structure, the only workaround for now is to avoid accessing those system tables when many constraints are defined.
