Knowledge Document: How best to deal with mergeout queue bloat in Vertica?

0 Likes

Environment

Vertica Analytics Platform 24.4 and above
 

Situation

There are two ETL developers  working on different tasks.While Developer A was loading data , Developer B has some CREATE TABLE AS SELECT statements fail with errors:

[Vertica][VJDBC](11863) ERROR: Request failed due to the current cluster health state
[Vertica][VJDBC]Detail: Reason: MERGEOUT QUEUE BLOAT. (Mergeout queue is too large.);


Find resolution on support portal

Labels:

Support Tips/Knowledge Docs
Comment List
Related
Recommended