Knowledge Document: Vertica queries are failing with optimizer error

Environment

Vertica Analytics Database: v24.1.x

Situation

Queries are failing occasionally with the internal optimizer error as below,

Internal Optimizer Error (11)
DETAIL:  newEENode && newEENode->step
HINT:  Please report this error to Vertica; try restating your query
LOCATION:  createOptimizedDeletePlan, /data/jenkins/workspace/RE-ReleaseBuilds/RE-Miner/server/vertica/Optimizer/Pat


Find complete article on support portal