MYSQL error - out of available memory

[S_M]

Hi, 

For the past few days, i occasionally get the following error : 

Would anyone have an idea what this is as i am unable to find anything around it.

Thanks 

[v-ljerr-msft]

Hi @S_M,

Cause

MySQL service is used actively, which causes it to overuse the maximum available limits for process treads.

Resolution

For Ubuntu\Debian\Centos below 6:

Modify the '/etc/security/limits.conf' directly, and configure limits for MySQL as below:

mysql soft nproc 4096

For Centos 6 and above:

Create a file '/etc/security/limits.d/91-mysql.conf' and include the same configuration as described above. The additional files is needed to override the global limit specified in the'/etc/security/limits.d/90-nproc.conf' .

---

Based on research, this issue may occurs when your MySQL service is used actively, which causes it to overuse the maximum available limits for process treads. Could you try the solution above or restarting your MySQL service to see if it works? 

Regards

[Greg_Deckler]

First question would be, are you running out of memory? And, are you using 32-bit or 64-bit ODBC driver?

[S_M]

@Greg_Deckler, not running out of memory at all, so this is odd - also i am using a 64-bit ODBC driver