fromExprRelids.size()

vcarusivcarusi Registered User

Hi,
Have you ever met this error ?

2018-06-25 14:30:15.051 Init Session:7f0e102d5700-a000000a15f78d @v_officedw_node0001: VX001/3594: Internal Optimizer Error (11)
DETAIL: fromExprRelids.size() == 1
HINT: Please report this error to Vertica; try restating your query
LOCATION: populateJoinTree, /scratch_a/release/svrtar12486/vbuild/vertica/Optimizer/Path/JoinGraph.cpp:1094

Thank you,
Veronica

Comments

  • Jim_KnicelyJim_Knicely Employee, Registered User, VerticaExpert
    edited June 25

    Can you post the SQL statement that causes the error?

    There is a fix in Vertica 9.1 that addresses a cause of this error. But we won't know if it'd help you until we see your particular statement.

  • vcarusivcarusi Registered User

    Hi,
    I have this error on Vertica Analytic Database v9.1.0-0.
    I will try to post the tables structure and the query.
    Thank you,
    Veronica

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file