Resolved 500 Plesk\Exception\Database

[ayadai]

When opening the PLESK login page, the following error appears:

500 Plesk\Exception\Database​

DB query failed: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

Attempting to repair PLESK results in the following error:

Execute mysqlmng_adm --repair failed with error code 1: Stopping service Configuring service Configuring service failure actions Applying service security Starting service Incorrect function. (Error code 1) at Start service PleskSQLServer at (service::startStopService line 997) at Error occurred on starting PleskSQLServer service. Errors in error log file: 2024-08-09 11:04:57 0 [ERROR] InnoDB: Corrupted page identifier at 231411166; set innodb_force_recovery=1 to ignore the record. 2024-08-09 11:04:57 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2024-08-09 11:04:58 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2024-08-09 11:04:58 0 [ERROR] Unknown/unsupported storage engine: INNODB 2024-08-09 11:04:58 0 [ERROR] Aborting (mysqlmng_adm::startService line 222) at (mysqlmng_adm::startService line 225) at startService()(mysqlmng_adm::startService line 228) at repair()(mysqlmng_adm::repair line 508) at Unable to execute console command: '--repair'(vconsoleapp::start line 95) at Unable to execute command: '"C:\Program Files (x86)\Plesk\admin\bin\mysqlmng_adm.exe" --repair'(vconsoleapp::run line 117) at (execPleskUtil line 123) at Unable to execute command: C:\Program Files (x86)\Plesk\admin\bin\mysqlmng_adm.exe --repair(execPleskUtil line 129) at Unable to call execPleskUtil(mysqlmng_adm --repair)(execPleskUtil line 137) at execUtil(mysqlmng_adm, --repair)(PleskRepairAdapter::DefaultSystemHelper::execUtil line 51) at repairPleskSqlServer()(PleskRepair::Adapter::repairPleskSqlServer line 70) at Unable to execute console command: '--repair-plesk-sql-server'(vconsoleapp::start line 95) at Unable to execute command: '"C:\Program Files (x86)\Plesk\admin\bin64\repairmng.exe" --repair-plesk-sql-server'(vconsoleapp::run line 117)

I've attempted to start the database service in services.msc; the windows error log shows the following error:

InnoDB: Corrupted page identifier at 231411166; set innodb_force_recovery=1 to ignore the record.

I've added innodb_force_recovery = 1 to C:\Program Files (x86)\Plesk\Databases\MySQL\my.ini; the problem persists.

The .err file contains the following data:

2024-08-09 10:35:35 0 [Note] Starting MariaDB 10.11.7-MariaDB source revision 87e13722a95af5d9378d990caf48cb6874439347 as process 84
2024-08-09 10:35:35 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-09 10:35:35 0 [Note] InnoDB: Number of transaction pools: 1
2024-08-09 10:35:35 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-08-09 10:35:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16.000MiB, chunk size = 1.000MiB
2024-08-09 10:35:35 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-09 10:35:35 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-08-09 10:35:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=231304523
2024-08-09 10:35:35 0 [ERROR] InnoDB: Corrupted page identifier at 231411166; set innodb_force_recovery=1 to ignore the record.
2024-08-09 10:35:35 0 [Note] InnoDB: End of log at LSN=231411166
2024-08-09 10:35:35 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-08-09 10:35:35 0 [Note] InnoDB: Starting shutdown...
2024-08-09 10:35:36 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-08-09 10:35:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-09 10:35:36 0 [Note] mysqld.exe: SSPI: using principal name 'localhost', mech 'Negotiate'
2024-08-09 10:35:36 0 [ERROR] Unknown/unsupported storage engine: INNODB
2024-08-09 10:35:36 0 [ERROR] Aborting
2024-08-09 10:36:36 0 [Note] Starting MariaDB 10.11.7-MariaDB source revision 87e13722a95af5d9378d990caf48cb6874439347 as process 10476
2024-08-09 10:36:36 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-09 10:36:36 0 [Note] InnoDB: Number of transaction pools: 1
2024-08-09 10:36:36 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-08-09 10:36:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16.000MiB, chunk size = 1.000MiB
2024-08-09 10:36:36 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-09 10:36:36 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-08-09 10:36:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=231304523
2024-08-09 10:36:36 0 [ERROR] InnoDB: Corrupted page identifier at 231411166; set innodb_force_recovery=1 to ignore the record.
2024-08-09 10:36:36 0 [Note] InnoDB: End of log at LSN=231411166
2024-08-09 10:36:36 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-08-09 10:36:36 0 [Note] InnoDB: Starting shutdown...
2024-08-09 10:36:36 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-08-09 10:36:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-09 10:36:36 0 [Note] mysqld.exe: SSPI: using principal name 'localhost', mech 'Negotiate'
2024-08-09 10:36:36 0 [ERROR] Unknown/unsupported storage engine: INNODB
2024-08-09 10:36:36 0 [ERROR] Aborting
2024-08-09 10:38:13 0 [Note] Starting MariaDB 10.11.7-MariaDB source revision 87e13722a95af5d9378d990caf48cb6874439347 as process 13264
2024-08-09 10:38:13 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-09 10:38:13 0 [Note] InnoDB: Number of transaction pools: 1
2024-08-09 10:38:13 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-08-09 10:38:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16.000MiB, chunk size = 1.000MiB
2024-08-09 10:38:13 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-09 10:38:13 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-08-09 10:38:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=231304523
2024-08-09 10:38:13 0 [ERROR] InnoDB: Corrupted page identifier at 231411166; set innodb_force_recovery=1 to ignore the record.
2024-08-09 10:38:13 0 [Note] InnoDB: End of log at LSN=231411166
2024-08-09 10:38:13 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-08-09 10:38:13 0 [Note] InnoDB: Starting shutdown...
2024-08-09 10:38:13 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-08-09 10:38:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-09 10:38:13 0 [Note] mysqld.exe: SSPI: using principal name 'localhost', mech 'Negotiate'
2024-08-09 10:38:13 0 [ERROR] Unknown/unsupported storage engine: INNODB
2024-08-09 10:38:13 0 [ERROR] Aborting
2024-08-09 10:42:38 0 [Note] Starting MariaDB 10.11.7-MariaDB source revision 87e13722a95af5d9378d990caf48cb6874439347 as process 3056
2024-08-09 10:42:38 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-09 10:42:38 0 [Note] InnoDB: Number of transaction pools: 1
2024-08-09 10:42:38 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-08-09 10:42:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16.000MiB, chunk size = 1.000MiB
2024-08-09 10:42:38 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-09 10:42:38 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-08-09 10:42:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=231304523
2024-08-09 10:42:38 0 [ERROR] InnoDB: Corrupted page identifier at 231411166; set innodb_force_recovery=1 to ignore the record.
2024-08-09 10:42:38 0 [Note] InnoDB: End of log at LSN=231411166
2024-08-09 10:42:38 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-08-09 10:42:38 0 [Note] InnoDB: Starting shutdown...
2024-08-09 10:42:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-08-09 10:42:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-09 10:42:38 0 [Note] mysqld.exe: SSPI: using principal name 'localhost', mech 'Negotiate'
2024-08-09 10:42:38 0 [ERROR] Unknown/unsupported storage engine: INNODB
2024-08-09 10:42:38 0 [ERROR] Aborting

 

[ayadai]

Resolved the issue by adding:

innodb_force_recovery = 1
skip-grant-tables

As per this article