• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Resolved error plesk upgrade from 18.0.39 to 18.0.41

dj ramc

Basic Pleskian
===> Plesk database scheme was not upgraded completely.

/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.26' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
***** problem report *****
===> Plesk database scheme was not upgraded completely.
Bootstrapper has finished action (exec time: 8 sec.): parent_name='panel', sequence='prep', stage='execute', sequence_order='0', operation='install', exec_cmd='/usr/local/psa/bootstrapper/pp18.0.41-bootstrapper/bootstrapper.sh prep-install BASE'', m_arch='', exit code: 1, output: /usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.26' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)

**** Product prep-install started.
Create user 'psaadm' and group 'psaadm'
Group 'psaadm' already exists
Checking for the user 'psaadm'...
User 'psaadm' already exists
Create group 'swkey-data'
Group 'swkey-data' already exists
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create group 'psaserv'
Group 'psaserv' already exists
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Create group 'psacln'
Group 'psacln' already exists
Trying to got legacy variables... done
Trying to save legacy variables... done
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell

===> Performing safe prep-install database actions


===> Upgrading database

Trying to start service mariadb... active
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 018000000
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.18.0.39-18.0.41.20220222-002622.dump.gz
===> Cumulative APS controller database (apsc) upgrade has been started.
Upgrade or repair for 'apsc' (stage 'prep') is not required
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.apsc.18.0.39-18.0.41.20220222-002625.dump.gz
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
Upgrade or repair for 'core' (stage 'prep') is not required
===> Preparing Plesk database upgrade (revertable stage).
Trying to set psa database version to 018000000... done
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
===> Plesk database scheme upgrade has been started.
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.26' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)

===> Plesk database scheme was not upgraded completely.

/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.26' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /usr/lib64/sw-engine-cli-3.41)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
/usr/lib64/sw-engine-cli-3.41: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /usr/lib64/libboost-plesk-1.74/libboost_filesystem-plesk.so.1.74.0)
***** problem report *****
===> Plesk database scheme was not upgraded completely.

[2022-02-22 00:26:29.465611] Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_18_0_41', sequence='prep', stage='rollback', sequence_order='1', operation='install', exec_cmd='rm -f /tmp/pp-bootstrapper-mode.flag; rm -f /var/lock/parallels-panel-maintenance-mode.flag; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'', m_arch='', exit code: 0, output: ~empty
[2022-02-22 00:26:29.707008] Bootstrapper has finished action (exec time: 0 sec.): parent_name='panel', sequence='prep', stage='rollback', sequence_order='9999', operation='install', exec_cmd='test ! -f /usr/local/psa/admin/plib/scripts/update-failure-notification.php || /usr/local/psa/admin/bin/php /usr/local/psa/admin/plib/scripts/update-failure-notification.php'', m_arch='', exit code: 0, output: ~empty
[2022-02-22 00:26:29.713947] Launching component and product checkers...
[2022-02-22 00:26:29.713979] FileFetcher: get file (~empty)/report-update
[2022-02-22 00:26:29.714069] Downloading file report-update: 0%
[2022-02-22 00:26:29.844307] Downloading file report-update: 100% was finished.
[2022-02-22 00:26:29.844730] FileFetcher: get file (~empty)/pool/PSA_18.0.41_8197/examiners/py_launcher.sh
[2022-02-22 00:26:29.844824] Downloading file pool/PSA_18.0.41_8197/examiners/py_launcher.sh: 0%
[2022-02-22 00:26:29.855228] Downloading file pool/PSA_18.0.41_8197/examiners/py_launcher.sh: 100% was finished.
[2022-02-22 00:26:30.343746] Examination executed ["/root/parallels/pool/PSA_18.0.41_8197/examiners/py_launcher.sh" "/root/parallels/report-update" --op upgrade --rc 1 --start-flag /var/lock/plesk-report-update.flag --to=18.0.41.1 --from=18.0.39] with code 0
Output:
~empty
Error:
~empty
[2022-02-22 00:26:30.349491] Error: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try to install the packages again.
Visit https://support.plesk.com/ to search for a solution.
 
Check that the /usr/lib64/c++-plesk-10.3.0/ folder is missed on the server:
Code:
# ls -l /usr/lib64/c++-plesk-10.3.0/
ls: cannot access /usr/lib64/c++-plesk-10.3.0/: No such file or directory
Seems custom repository /etc/yum.repos.d/gf.repo is enabled on the server.

The gcc10-libstdc++-10.2.1-7.gf.el7.x86_64 package prevents installation of the plesk-libstdc++10.3.0-10.3.0-1centos.7.210902.0954.x86_64.rpm package.

To fix the issue:
  1. Download missed package with the command:
    Code:
    # wget https://autoinstall.plesk.com/PSA_18.0.40/dist-rpm-CentOS-7-x86_64/contrib/plesk-libstdc++10.3.0-10.3.0-1centos.7.210902.0954.x86_64.rpm
  2. Install downloaded package:
    Code:
    # yum localinstall plesk-libstdc++10.3.0-10.3.0-1centos.7.210902.0954.x86_64.rpm
  3. Try to upgrade Plesk.
 
wget https://autoinstall.plesk.com/PSA_1...0.3.0-10.3.0-1centos.7.210902.0954.x86_64.rpm
--2022-02-22 09:10:34-- https://autoinstall.plesk.com/PSA_1...0.3.0-10.3.0-1centos.7.210902.0954.x86_64.rpm
Resolving autoinstall.plesk.com (autoinstall.plesk.com)... 2a02:6ea0:c900::5, 2a02:6ea0:c900::3, 185.93.2.24, ...
Connecting to autoinstall.plesk.com (autoinstall.plesk.com)|2a02:6ea0:c900::5|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2022-02-22 09:10:34 ERROR 404: Not Found.
 
This should give you a list of the installed packages and other packages from the gf-repo:

Code:
yum repo-pkgs gf list
 
my second server won't update either .

[2022-02-22 23:29:35.582993] The following packages from not selected components will be installed because they are required by other components' packages you selected for installation:
[2022-02-22 23:29:35.586350] Installing packages
[2022-02-22 23:29:35.652986] Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www5.atomicorp.com
* base: centos.mirrors.proxad.net
* epel: mirrors.coreix.net
plesk-libboost-1.74-1.74.0.1-1centos.7.211202.1442.x86_6 | 3.6 kB 00:00
plesk-libboost-date-time1.74-1.74.0.1-1centos.7.211202.1 | 4.2 kB 00:00
plesk-libboost-filesystem1.74-1.74.0.1-1centos.7.211202. | 52 kB 00:00
plesk-libboost-system1.74-1.74.0.1-1centos.7.211202.1442 | 4.2 kB 00:00
pp18.0.41-bootstrapper-18.0-2.centos.7+p18.0.41.1+t22020 | 203 kB 00:00
sw-engine-cli-3.41-3.41.1-1centos.7.220111.1225.x86_64.r | 4.5 MB 00:00
Running Transaction Check
Installing: plesk-libboost-1.74-1.74.0.1-1centos.7.211202.1442.x86_64 [1/6]
Installing: plesk-libboost-system1.74-1.74.0.1-1centos.7.211202.1442.x86_64 [2/6]
Installing: plesk-libboost-filesystem1.74-1.74.0.1-1centos.7.211202.1442.x86_64 [3/6]
Installing: plesk-libboost-date-time1.74-1.74.0.1-1centos.7.211202.1442.x86_64 [4/6]
Installing: sw-engine-cli-3.41-3.41.1-1centos.7.220111.1225.x86_64 [5/6]
Installing: pp18.0.41-bootstrapper-18.0-2.centos.7+p18.0.41.1+t220207.2342.x86_64 [6/6]
Verify: 1/6: plesk-libboost-system1.74.x86_64 0:1.74.0.1-1centos.7.211202.1442 - u
Verify: 2/6: plesk-libboost-date-time1.74.x86_64 0:1.74.0.1-1centos.7.211202.1442 - u
Verify: 3/6: sw-engine-cli-3.41.x86_64 0:3.41.1-1centos.7.220111.1225 - u
Verify: 4/6: pp18.0.41-bootstrapper.x86_64 0:18.0-2.centos.7+p18.0.41.1+t220207.2342 - u
Verify: 5/6: plesk-libboost-1.74.x86_64 0:1.74.0.1-1centos.7.211202.1442 - u
Verify: 6/6: plesk-libboost-filesystem1.74.x86_64 0:1.74.0.1-1centos.7.211202.1442 - u
processTransaction event: 10 (Downloading Packages)
processTransaction event: 11 (unknown)
processTransaction event: 20 (Check Package Signatures)
processTransaction event: 30 (Running Test Transaction)
processTransaction event: 40 (Running Transaction)
Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_18_0_41', sequence='prep', stage='execute', sequence_order='-2', operation='install', exec_cmd='touch /var/lock/plesk-report-update.flag; :'', m_arch='', exit code: 0, output: ~empty
[2022-02-22 23:29:36.588369] Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_18_0_41', sequence='prep', stage='execute', sequence_order='-1', operation='install', exec_cmd='touch /tmp/pp-bootstrapper-mode.flag; touch /var/lock/parallels-panel-maintenance-mode.flag; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'', m_arch='', exit code: 0, output: ~empty
[2022-02-22 23:29:36.804041] mysqldump: Got error: 1030: "Got error 194 "Tablespace is missing for a table" from storage engine InnoDB" when using LOCK TABLES

**** Product prep-install started.
Create user 'psaadm' and group 'psaadm'
Group 'psaadm' already exists
Checking for the user 'psaadm'...
User 'psaadm' already exists
Create group 'swkey-data'
Group 'swkey-data' already exists
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create group 'psaserv'
Group 'psaserv' already exists
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Create group 'psacln'
Group 'psacln' already exists
Trying to got legacy variables... done
Trying to save legacy variables... done
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell

===> Performing safe prep-install database actions


===> Upgrading database

Trying to start service mariadb... active
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 018000000
Trying to backup MySQL database... mysqldump: Got error: 1030: "Got error 194 "Tablespace is missing for a table" from storage engine InnoDB" when using LOCK TABLES

ERROR while trying to backup MySQL database

Check the error reason (see log file: /var/log/plesk/install/plesk_18.0.41_installation.log), fix and try again
mysqldump: Got error: 1030: "Got error 194 "Tablespace is missing for a table" from storage engine InnoDB" when using LOCK TABLES
***** problem report *****
ERROR while trying to backup MySQL database
Bootstrapper has finished action (exec time: 1 sec.): parent_name='panel', sequence='prep', stage='execute', sequence_order='0', operation='install', exec_cmd='/usr/local/psa/bootstrapper/pp18.0.41-bootstrapper/bootstrapper.sh prep-install BASE'', m_arch='', exit code: 1, output:
**** Product prep-install started.
Create user 'psaadm' and group 'psaadm'
Group 'psaadm' already exists
Checking for the user 'psaadm'...
User 'psaadm' already exists
Create group 'swkey-data'
Group 'swkey-data' already exists
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create group 'psaserv'
Group 'psaserv' already exists
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Create group 'psacln'
Group 'psacln' already exists
Trying to got legacy variables... done
Trying to save legacy variables... done
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell

===> Performing safe prep-install database actions


===> Upgrading database

Trying to start service mariadb... active
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 018000000
Trying to backup MySQL database... mysqldump: Got error: 1030: "Got error 194 "Tablespace is missing for a table" from storage engine InnoDB" when using LOCK TABLES

ERROR while trying to backup MySQL database

mysqldump: Got error: 1030: "Got error 194 "Tablespace is missing for a table" from storage engine InnoDB" when using LOCK TABLES
***** problem report *****
ERROR while trying to backup MySQL database

[2022-02-22 23:29:37.052921] Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_18_0_41', sequence='prep', stage='rollback', sequence_order='1', operation='install', exec_cmd='rm -f /tmp/pp-bootstrapper-mode.flag; rm -f /var/lock/parallels-panel-maintenance-mode.flag; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'', m_arch='', exit code: 0, output: ~empty
[2022-02-22 23:29:37.160784] Bootstrapper has finished action (exec time: 0 sec.): parent_name='panel', sequence='prep', stage='rollback', sequence_order='9999', operation='install', exec_cmd='test ! -f /usr/local/psa/admin/plib/scripts/update-failure-notification.php || /usr/local/psa/admin/bin/php /usr/local/psa/admin/plib/scripts/update-failure-notification.php'', m_arch='', exit code: 0, output: ~empty
[2022-02-22 23:29:37.161895] Launching component and product checkers...
[2022-02-22 23:29:37.161911] FileFetcher: get file (~empty)/report-update
[2022-02-22 23:29:37.161952] Downloading file report-update: 0%
[2022-02-22 23:29:37.190869] Downloading file report-update: 100% was finished.
[2022-02-22 23:29:37.190970] FileFetcher: get file (~empty)/pool/PSA_18.0.41_8197/examiners/py_launcher.sh
[2022-02-22 23:29:37.190996] Downloading file pool/PSA_18.0.41_8197/examiners/py_launcher.sh: 0%
[2022-02-22 23:29:37.199970] Downloading file pool/PSA_18.0.41_8197/examiners/py_launcher.sh: 100% was finished.
[2022-02-22 23:29:37.436037] Examination executed ["/root/parallels/pool/PSA_18.0.41_8197/examiners/py_launcher.sh" "/root/parallels/report-update" --op upgrade --rc 1 --start-flag /var/lock/plesk-report-update.flag --to=18.0.41.1 --from=18.0.39] with code 0
Output:
~empty
Error:
~empty
[2022-02-22 23:29:37.438742] Error: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try to install the packages again.
Visit https://support.plesk.com/ to search for a solution.
 
Could you show the output of this command please?

yum list installed | grep @epel

You've enabled the epel repository which can give issues when updating the server.
 
awstats.noarch 7.8-2.el7 @epel
beanstalkd.x86_64 1.10-2.el7 @epel
epel-release.noarch 7-14 @epel
libbsd.x86_64 0.8.3-1.el7 @epel
libc-client.x86_64 2007f-16.el7 @epel
libidn2.x86_64 2.3.2-1.el7 @epel
libopendkim.x86_64 2.11.0-0.1.el7 @epel
lua-socket.x86_64 3.0-0.17.rc1.el7 @epel
perl-Data-Validate-IP.noarch 0.27-13.el7 @epel
perl-Geo-IP.x86_64 1.43-3.el7 @epel
perl-Net-IP.noarch 1.26-4.el7 @epel
php-pecl-igbinary.x86_64 1.2.1-1.el7 @epel
php-pecl-msgpack.x86_64 0.5.5-5.el7 @epel
pigz.x86_64 2.3.4-1.el7 @epel
python-meld3.x86_64 0.6.10-1.el7 @epel
supervisor.noarch 3.4.0-1.el7 @epel
webalizer.x86_64 2.23_08-6.el7 @epel
 
mysqldump: Got error: 1030: "Got error 194 "Tablespace is missing for a table" from storage engine InnoDB" when using LOCK TABLES
Incorrect user ownership and/or group for files inside /var/lib/mysql/apsc.
Fix the permissions on all files on the domain's database:

# chown -R mysql:mysql /var/lib/mysql/*

Restart mariadb service:

# systemctl restart mariadb
 
Incorrect user ownership and/or group for files inside /var/lib/mysql/apsc.
Fix the permissions on all files on the domain's database:

# chown -R mysql:mysql /var/lib/mysql/*

Restart mariadb service:

# systemctl restart mariadb
Hi IgorG
checked that file it's already mysql the owner
drwx------ 2 mysql mysql 4096 Feb 14 13:15 apsc
 
Besides the above mentioned suggestion on the apsc directory, have you checked your /var/log/syslog (/var/log/messages) for mysql/mariadb related messages, specificially when you try to restart the database service? If errors regarding missing table space(s) are logged, this might help: How to fix error in Mysql "tablespace is missing for table XXXXX"

Have you run Igor's chown command to make sure that not only the directory groups and owners of apsc are correct, but all directories and files inside these directories of the /var/lib/mysql directory have the correct group and owner?
 
thanks alot for support.
i fixed db errors by reinstalling mariadb and imported backup. now mariadb errors are gone
this night i'll try upgrade plesk
 
Back
Top