The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
CREATE LIBRARY got timeout
BHIFP Vertica Customer ✭
dbadmin=> CREATE LIBRARY JavaTransformFunctions AS :libTfile LANGUAGE 'JAVA';
ROLLBACK 5924: Insufficient resources to get resource from jvm pool [Timedout waiting for resource request: General cannot supply required overflow resources: Memory(KB) Exceeded: Requested = 6225920, Free = 4209727 (Limit = 103621008, Used = 99411281) (queueing threshold)]
While the machines seem healthy with enough memory remaining, although nothing really are running at the moment, so I am not sure what is using 65G per node:
Any idea why? Thanks
it looks like in JVM pool already used up 99411281KB and create library is requesting about 6 GB. run the below query and check MEMORY_INUSE_KB for jvm pool. Is 99 GB really being used by the pool or not?
select * from resource_pool_status
what is the best mean to show you that, SruthiA?
I have run SELECT RELEASE_JVM_MEMORY(); nothing really happened.
Can you set plannedconcurrency to 1 for jvm pool and try create library once?
what do you think the first 3 are?
General pool used up almost all the memory available on 2 nodes. JVM pool has to borrow from general pool since it's memory size value is set to 0. General is not able to provide the resources requested to the jvm pool for CREATE LIBRARY Stmt
How do I find what is using memory? In fact, I am not aware of anything running on those nodes.
"General pool used up almost all the memory available on 2 nodes."
htop shows less that half of all memories are used, how should I mobilize the remaining?
run the below query to see the current queries in execution and memory acquired by them.
select * from query_requests where is_executing;
Thanks, SruthiA! That helped.
There was a long running query.
That aside, how should one utilize the remaining memory fully?
the original statement still not running even after the kill:
nothing is running now:
Once I set plannedconcurrency back to AUTO from 1, it started working.
@BHIFP : good to know it is working