We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


vertica scheduler how use all memory for the pool after adding physical memory — Vertica Forum

vertica scheduler how use all memory for the pool after adding physical memory

maksmaks Community Edition User

Hello, Could you please help me? I have vertica's scheduler, it reads data from apache kafka's topic. Sometimes the scheduler stops working because there was not enough memory and I see in log error:
Insufficient resources to execute plan on pool mypool [Timedout waiting for resource request: Request exceeds limits: Memory(KB) Exceeded: Requested = 30333842, Free = 22275670 (Limit = 52609512, Used = 30333842) (queueing threshold)]

I added physical memory (from 64 Gb till 96 Gb) but I have same error. I think that new memory has not been added to the scheduler' pool (I see in error's log that it is still free about 22 GB as it was before I increased the memory). How can I use all memory for the pool? Restarting scheduler and host doesn't help.
That is log after adding memory:
ERROR: Insufficient resources to execute plan on pool mypool [Timedout waiting for resource request: Request exceeds limits: Memory(KB) Exceeded: Requested = 30333842, Free = 22275670 (Limit = 52609512, Used = 30333842) (queueing threshold)]

Tagged:

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file