Issue Unable to login to plesk 500 Plesk\Exception\Database

[cody]

Server operating system version

11

Plesk version and microupdate number

11

Unable to access plesk login page throwing error "DB query failed: SQLSTATE[HY000] [2002] No such file or directory"

i tried to get the log and here it is

May 1 16:17:25 vps mysqld: 2022-05-01 16:17:25 140499251501248 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
May 1 16:17:25 vps mysqld: 2022-05-01 16:17:25 140499251501248 [ERROR] Plugin 'Aria' init function returned error.
May 1 16:17:25 vps mysqld: 2022-05-01 16:17:25 140499251501248 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
May 1 16:17:25 vps mysqld: 2022-05-01 16:17:25 140499251501248 [Note] Plugin 'FEEDBACK' is disabled.
May 1 16:17:25 vps mysqld: 2022-05-01 16:17:25 140499251501248 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
May 1 16:17:25 vps mysqld: 2022-05-01 16:17:25 140499251501248 [ERROR] Aborting
May 1 16:17:26 vps mysqld: Warning: Memory not freed: 520
May 1 16:17:32 vps mysqld: 2022-05-01 16:17:32 140178509138112 [Note] /usr/sbin/mysqld (mysqld 10.2.43-MariaDB) starting as process 32432 ...
May 1 16:17:32 vps mysqld: 2022-05-01 16:17:32 140178509138112 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
May 1 16:17:32 vps mysqld: 2022-05-01 16:17:32 140178509138112 [Note] InnoDB: Uses event mutexes
May 1 16:17:32 vps mysqld: 2022-05-01 16:17:32 140178509138112 [Note] InnoDB: Compressed tables use zlib 1.2.7
May 1 16:17:32 vps mysqld: 2022-05-01 16:17:32 140178509138112 [Note] InnoDB: Using Linux native AIO
May 1 16:17:32 vps mysqld: 2022-05-01 16:17:32 140178509138112 [Note] InnoDB: Number of pools: 1
May 1 16:17:32 vps mysqld: 2022-05-01 16:17:32 140178509138112 [Note] InnoDB: Using SSE2 crc32 instructions
May 1 16:17:32 vps mysqld: 2022-05-01 16:17:32 140178509138112 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
May 1 16:17:32 vps mysqld: 2022-05-01 16:17:32 140178509138112 [Note] InnoDB: Completed initialization of buffer pool
May 1 16:17:32 vps mysqld: 2022-05-01 16:17

Plz help me to solve this problem, tried all available solutions.

 

[IgorG]

1. Shut down MariaDB database server (if it is not stopped):
   

   # mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -h127.0.0.1 --protocol=tcp shutdown

2. Remove the aria_log_control file:
   

   # mv /var/lib/mysql/aria_log_control /var/lib/mysql/aria_log_control.orig

3. Start MariaDB:
   

   # service mariadb start

4. Update Plesk using the command:
   

   # plesk installer update

 

[cody]

1. Shut down MariaDB database server (if it is not stopped):
   

   # mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -h127.0.0.1 --protocol=tcp shutdown

2. Remove the aria_log_control file:
   

   # mv /var/lib/mysql/aria_log_control /var/lib/mysql/aria_log_control.orig

3. Start MariaDB:
   

   # service mariadb start

4. Update Plesk using the command:
   

   # plesk installer update

Hi Sir, Thanks for your response.

I tried as per your instructions and following results i am getting:

[root@ init.d]# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -h127.0.0.1 --protocol=tcp shutdown

mysqladmin: connect to server at '127.0.0.1' failed

error: 'Can't connect to MySQL server on '127.0.0.1' (115)'

Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

[root@ init.d]# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -h127.0.0.1 --protocol=tcp shutdown

mysqladmin: connect to server at '127.0.0.1' failed

error: 'Can't connect to MySQL server on '127.0.0.1' (115)'

Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

[root@ init.d]# mv /var/lib/mysql/aria_log_control /var/lib/mysql/aria_log_control.orig

[root@ init.d]# service mariadb start

Redirecting to /bin/systemctl start mariadb.service

Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

[root@ init.d]# plesk installer update

bash: plesk: command not found

[root@ init.d]# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -h127.0.0.1 --protocol=tcp shutdown

mysqladmin: connect to server at '127.0.0.1' failed

error: 'Can't connect to MySQL server on '127.0.0.1' (115)'

Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

cp backupdomainvps.zip /var/lib/psa/dumps/domain/

 

[cody]

log of journalctl -xe

 

[cody]

It seem's there is no solution for this issue. No response

 

[Kaspar]

I would suggest contacting Plesk support for assistance on your issue. See information on how to get Plesk support here: https://support.plesk.com/hc/en-us/articles/213953025-How-to-get-support-directly-from-Plesk-

You can get your Plesk license key (which you need to submit a ticket) with SSH command:
# plesk bin license --retrieve