Insufficient resources to execute plan on pool general erro

[brendon987]

Hi,

What should I be doing if I get the following error in vertica 5 ?

Error Details: com.vertica.util.PSQLException:ERROR: Insufficient resources to execute plan on pool general [Timedout waiting for resource request: Request exceeds limits: Memory(KB) Exceeded: Requested = 7780003, Free = 3990255 (Limit = 11436290, Used = 7446035)]

Thanks

Brendon

[JimKnicely]

Brendon,

Check out the post:

viewtopic.php?f=6&t=3&p=3&hilit=Insuffi ... sources#p3

Thanks!

[scutter]

The referred to topic is focussed mostly on MEMORYCAP. This error is a timeout - where the resources couldn't be allocated before the resource timeout was hit. The tip there on delete vectors could be applicable here - you'll have to assess that (check the delete_vectors table).

In the vertica.log for the initiator node for the query that failed, you'll find a reference to the node that failed to get resources. Go to the vertica.log for that node, and you'll find some output dumped to the log that shows what was executing when the timeout occurred, how much memory each query was using, and the queries that were queued. This will allow you to see if one query was taking the memory, or a number of queries, and to assess how long the offending queries were running for. If it's a single query taking a lot of memory, then it's probably a join with a large inner relation or a cross join. The resolution will depend on what you see for the queries and their explain plans.

[JimKnicely]

Then maybe this post?

viewtopic.php?f=48&t=391&p=1239&hilit=timeout#p1238

[scutter]

Yes - I like that discussion