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