This article explains how an external table triggered an out-of-memory (OOM) condition in Vertica, leading to node crashes. Dropping the external table resolved the issue. It also provides context on how Vertica handles memory and what can contribute to OOM scenarios.
Environment
- Vertica Analytics Platform
- External tables
- Cluster experiencing node crashes due to memory exhaustion
Situation
A customer reported repeated node crashes in Vertica. Investigation revealed that the issue was tied to an external table. Once the table was dropped, the node stopped crashing and system stability was restored.
