The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

INTERNAL 4624: ROSSALColumnAccess position not found

Hi.
I have encountered this error for a specific table.
After some investigation, I found that the error occurs only when accessing one of the buddy projections.
Solution that worked:
1. Create a new super projection
2. Drop the old one
3. Rename if needed

Tagged:

Comments

  • Bryan_HBryan_H Employee
    edited July 2019

    Hi, that is the correct fix since it's usually due to a corrupt ROS index file, but we haven't seen this issue since version 7.2. Newer ROS file format and catalog improvements should not experience this issue. What version are you running?

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.