CREATE LIBRARY got timeout

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

same:

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.
Thanks!

@BHIFP : good to know it is working