Plesk SQL server could not start: InnoDB: VirtualAlloc failed; Windows error 8

Created:

2017-01-22 06:49:27 UTC

Modified:

2017-08-08 13:14:53 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk SQL server could not start: InnoDB: VirtualAlloc failed; Windows error 8

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

When trying to login to the admin panel the following error appears:


ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

%plesk_dir%\MySQL\Data\<HOSTNAME>.err file contains the following:


170122 11:38:08 InnoDB: Initializing buffer pool, size = 3.0G
InnoDB: VirtualAlloc(3263692800 bytes) failed; Windows error 8
170122 11:38:08 InnoDB: Completed initialization of buffer pool
170122 11:38:08 InnoDB: Fatal error: cannot allocate memory for the buffer pool

Cause

- INNODB_BUFFER_POOL_SIZE larger than free RAM

- RAM fragmentation

Resolution

1. Decrease INNODB_BUFFER_POOL_SIZE value in "%plesk_dir%\MySQL\my.ini

Note: In general, INNODB_BUFFER_POOL_SIZE should be equal to INNODB data size

Have more questions? Submit a request
Please sign in to leave a comment.