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

pratheek238pratheek238 Vertica Customer
in General Discussion

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!

Tagged:

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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...