Insufficient resources to execute plan on pool general

Moderator: NorbertKrupa

Post Reply
jfm828
Newbie
Newbie
Posts: 1
Joined: Mon Feb 17, 2014 4:02 pm

Insufficient resources to execute plan on pool general

Post by jfm828 » Mon Feb 17, 2014 4:13 pm

I am migrating data from a database to Vertica.
I have a problem and I would you help me, please. The problem is below:

[Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general [Request Too Large:Memory(KB) Exceeded: Requested = 534202, Free = 467356 (Limit = 512412, Used = 45056)]

My tables are like this:

Code: Select all

select * from resource_pools where name='general';
45035996273718910 general true Special: 95% AUTO 0 MEDIUM 2 300 AUTO (null) (null) false

Code: Select all

select * from resource_pool_status where name='general';
v_datamart_ai_node0001 45035996273718910 general true 512412 512412 0 0 486791 512412 0 4 (null) true 300 AUTO 0 MEDIUM 2 false 121697

I've tried changing the value maxmemorysize to a higher value but I can`t.

When I have tried:

Code: Select all

alter RESOURCE POOL general maxmemorysize '1G'
15:53:19 [ALTER - 0 row(s), 0.000 secs] [Error Code: 3912, SQL State: 22023] [Vertica][VJDBC](3912) ROLLBACK: maxMemorySize of 1G (1048576 KB) is not in bounds [max is 1017216 KB]

I have tried with next, as well:

Code: Select all

alter RESOURCE POOL general maxmemorysize '1017216K'
15:54:19 [ALTER - 0 row(s), 0.000 secs] [Error Code: 5437, SQL State: 22023] [Vertica][VJDBC](5437) ROLLBACK: Vertica should not be run with less than 1GB of RAM

Any idea to help me please?

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Insufficient resources to execute plan on pool general

Post by NorbertKrupa » Mon Feb 17, 2014 7:14 pm

Can you post the output of the following:

Code: Select all

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;
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica Error Codes”