Issue trying to upgrade plesk almalinux 8.7

[medhd405]

Server operating system version

almalinux 8.7

Plesk version and microupdate number

18.0.41

i had upgrade from centos 8 to almalinux 8.7
version plesk 18.0.41
but it is not supported by almalinux
when i try to access to plesk (

502 Bad Gateway​

---

nginx
)

ERROR: The currently installed version of the product with ID 'plesk' is no longer available from the installation source.

so the solution is to up to date plesk !!
what is the solution please :
Trying to start service mariadb... active
done
Trying to establish test connection... connected
done
Trying to find Plesk database psa... not found
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.18.0.41-18.0.51.20230316-064433.dump.gz
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
===> Cumulative Plesk database upgrade (revertable stage) has been started.
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
Upgrade or repair for 'core' (stage 'prep') is not required
===> Preparing Plesk database upgrade (revertable stage).
Trying to set psa database version to 018000000... ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'

ERROR while trying to execute SQL query, the query was: replace into misc (param,val) values('version', '018000000')

Check the error reason (see log file: /var/log/plesk/install/plesk_18.0.51_installation.log), fix and try again
***** problem report *****
ERROR while trying to execute SQL query, the query was: replace into misc (param,val) values('version', '018000000')
Launching component and product checkers...
Downloading file report-update: 100% was finished.
Downloading file pool/PSA_18.0.51_11329/examiners/py_launcher.sh: 100% was finished.

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.

 

[Peter Debik]

Looks like a previous update has removed the psa database and maybe more. You can try to restore it as described here:

https://support.plesk.com/hc/en-us/articles/360017353840-How-to-restore-Plesk-system-databases-from-a-Plesk-daily-pre-upgrade-dump

But I think it will be best to create a new server and restore a full backup to it.