The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

INTERNAL 3591: Internal EE Error (11) error on a view

Hello - We have a view combining data from multiple tables and we're getting below error when we're trying to run a query on top of the view. Does anyone know what this means or how to resolve this issue?

Internal EE Error (11)
DETAIL: rootPath.empty() == false && "Temp relation descriptor not provided"
HINT: Please report this error to Vertica; try restating your query

Thanks!

Answers

  • Bryan_HBryan_H Vertica Employee Administrator

    What exact version of Vertica are you running? Is there a UNION or UNION ALL in the query or underlying view?

  • pratheek238pratheek238 Vertica Customer

    We're on v11.1.1-4 and yes, we're doing UNION ALL in the view

  • Bryan_HBryan_H Vertica Employee Administrator

    This known issue will be fixed in upcoming 11.1.1-6 patch.

  • pratheek238pratheek238 Vertica Customer

    Thanks. What is the issue and is there a workaround for this until we can upgrade?

  • Bryan_HBryan_H Vertica Employee Administrator

    Workaround with:
    alter session set EnableWITHTempRelReuseLimit = 0;

Leave a Comment

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