We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Erro on pool general — Vertica Forum

Erro on pool general

in General Discussion

[53000] ERROR: Insufficient resources to execute plan on pool general [Request Too Large:Memory(KB) Exceeded: Requested = 4643949, Free = 296658 (Limit = 1373782, Used = 1077124)]

 

The message is clear, but how can I fix without having to change the hardware?

I need help...!

Comments

  • What kind of operation did you execute?

     

    first you should try to optimize your query

    2nd you could try to spill on disk if it possible for you operation

  • Hi,

    I increased the server swap and worked.

    Thanks a lot for the help...

  • Hi Filipe

    What is steps for checking error in pool. Can you share the information please ? From above information i did not find any. If you could give me the statement that need to be fire on database then it will be great help.

  • Hi,
    I am using ubuntu server 14.04LTS system as the database server, which did was increase from 2GB to 6GB the server SWAP memory.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
You can use Markdown in your post.
Home • General DiscussionComment As ...