[Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general

Moderator: NorbertKrupa

Post Reply
arulm
Newbie
Newbie
Posts: 1
Joined: Wed May 23, 2018 6:20 am

[Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general

Post by arulm » Wed May 23, 2018 6:25 am

[Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general : 3-Node vertica cluster with each 188GB RAM & 48 core cpu.Very often , I observe this issue in my application where vertica is DWH and Business objects is the BI layer. Below is the table level details.
SELECT host_name,
total_memory_bytes / ( 1024^3 ) AS total_memory_gb,
total_memory_free_bytes / ( 1024^3 ) AS total_memory_free_gb,
total_swap_memory_bytes / ( 1024^3 ) AS total_swap_memory_gb,
total_swap_memory_free_bytes / ( 1024^3 ) AS total_swap_memory_free_gb
FROM v_monitor.host_resources;
host_name tota_memory_gb total_memory_free_gb total_swap_memory_gb total_swap_memory_free_gb
xx.xx.xxx.41 188.795875549316 138.443775177002 191.999996185303 190.413711547852
xx.xx.xxx.42 188.630561828613 138.980602264404 191.999996185303 189.145565032959
xx.xx.xxx.44 188.627906799316 143.035667419434 191.999996185303 189.018726348877

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1817
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: [Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general

Post by JimKnicely » Fri May 25, 2018 8:59 pm

Hi,

Check on the query budget available for each query:

SELECT node_name, memory_size_kb, max_memory_size_kb, planned_concurrency, query_budget_kb FROM resource_pool_status WHERE pool_name = 'general';

Most likely for you it will be 188 GB * (0.95) / 48 = 3.72 GB

Check the last 5 events where memory was requested and rejected:

SELECT last_rejected_value FROM resource_rejections WHERE pool_name = 'general' AND resource_type = 'Memory(KB)' ORDER BY last_rejected_timestamp DESC LIMIT 5;

See:
https://my.vertica.com/docs/9.1.x/HTML/ ... Impact.htm
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “General”