Article ID: 114444, created on Jul 26, 2012, last review on May 6, 2014

  • Applies to:
  • Small Business Panel 10.x for Windows

Symptoms

The following error appears on PSBP login page:

Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'localhost' (10061)' in C:\Parallels\Plesk\admin\smb\application\externals\Zend\Db\Adapter\Pdo\Abstract.php:143 Stack trace: #0 C:\Parallels\Plesk\admin\smb\application\externals\Zend\Db\Adapter\Abstract.php(417): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 C:\Parallels\Plesk\admin\smb\application\externals\Zend\Db\Adapter\Pdo\Abstract.php(230): Zend_Db_Adapter_Abstract->query('SELECT 1', Array) #2 C:\Parallels\Plesk\admin\smb\application\library\Smb\Application\Abstract.php(96): Zend_Db_Adapter_Pdo_Abstract->query('SELECT 1') #3 C:\Parallels\Plesk\admin\smb\application\library\Smb\Application\Web.php(47): Smb_Application_Abstract->_initDbAdapter() #4 C:\Parallels\Plesk\admin\smb\application\public\index.php(20): Smb_Application_Web->run() #5 {main} thrown in C:\Parallels\Plesk\admin\smb\application\externals\Zend\Db\Adapter\Pdo\Abstract.php on line 143

Cause

MySQL InnoDB pool buffer size limit exceeded. The following warning appears in MySQL error log C:\Parallels\Plesk\Databases\MySQL\Data\sxxxxxxx.err :

InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.
120725 21:47:13InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (18363 search iterations)! Consider
InnoDB: increasing the buffer pool size.


Resolution

Increase the value of innodb_buffer_pool_size parameter in MySQL configuration file %plesk_dir%\Databases\MySQL\Data\my.ini:

Default:
innodb_buffer_pool_size=512K

Increase it to:
innodb_buffer_pool_size=16M

And restart the MySQL service.

fecffcac0f5f6ab17f124183fee58c91 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8

Email subscription for changes to this article
Save as PDF