Erro on pool general

FilipeFilipe
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

  • FiliNFiliN

    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

  • FilipeFilipe

    Hi,

    I increased the server swap and worked.

    Thanks a lot for the help...

  • UJJWAL_RANAUJJWAL_RANA

    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.

  • FilipeFilipe

    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
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 ...