The operating system failed to allocate memory (MemSQL memory use 25576.12 Mb). The request was not processed

We are receiving below error. Why it is coming.

Error occurred during SQL script execution

Reason:
SQL Error [1712] [HY000]: Leaf Error (10.100.0.18:3306): The operating system failed to allocate memory (MemSQL memory use 25576.12 Mb). The request was not processed. See https://docs.memsql.com/troubleshooting/latest/memory-errors for additional information

That error is usually due to a linux miss configuration. It means MemSQL sees lots of memory available on the machine but linux is refusing memory allocation requests.

you may want to try running this to see if it can find the miss configuration:

otherwise, send a cluster report to bug-report@memsql.com and we can take a look at what the issue may be.

-Adam

what about k8s instalments? does memsql know how to ignore the underlying node’s ram?
currently the studio node reports are all off.

MemSQL is looking at the maximum_memory system variable to know if there is memory available for it to use (We have safe guards to prevents maximum_memory higher then the physical memory on the machine - but if your running multiple memsql on the same host those safe guards don’t work). So its up to the code setting up memsql on k8s to set maximum_memory appropriately to split up your underlying host (which our k8s operator will do for you).