[Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general
Posted: 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
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