- Server operating system version
- Ubuntu 18.04.6 LTS
- Plesk version and microupdate number
- Version 18.0.34 Update #2
Hello,
I wanted to update Plesk Obsidian 18.0.34 to 18.0.57 via the web updater. So far so good.
But then the installation was aborted (Trying to find Plesk database psa... not found - see the log file).
Now my question is, theoretically I could restore the psa database from the backup - right?
But what happens next? Does the updater recognize that parts of the update have already been completed?
The hosted websites are running, but the Plesk interface is simply not available. It's also a productive server where I can't afford long downtimes.
Thanks
-----------------------------
Log-File
-----------------------------
START Bootstrapper 18.0.57 prep-install for BASE AT Sun Dec 31 14:41:58 CET 2023
**** 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
config updated
===> Updated /etc/psa/psa.conf
Trying to save legacy variables... done
Checking that /opt/psa/bin/chrootsh registered as login shell...
===> Performing safe prep-install database actions
===> Upgrading database
Trying to start service mysql... 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'
ERROR while trying to run the following SQL query: SELECT val FROM misc WHERE param = 'aps_database'
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.18.0.34-18.0.57.20231231-144159.dump.gz
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
ERROR while trying to run the following SQL query: SELECT val FROM misc WHERE param = 'aps_database'
===> Cumulative Plesk database upgrade (revertable stage) has been started.
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
ERROR while trying to run the following SQL query: SHOW TABLES LIKE 'misc'
===> Restoring database from backup /var/lib/psa/dumps/mysql.preupgrade.18.0.34-18.0.57.20231231-144159.dump.gz
**** Product prep-install for BASE failed.
***** problem report *****
ERROR while trying to run the following SQL query: SELECT val FROM misc WHERE param = 'aps_database'
***** problem report *****
ERROR while trying to run the following SQL query: SELECT val FROM misc WHERE param = 'aps_database'
***** problem report *****
ERROR while trying to run the following SQL query: SHOW TABLES LIKE 'misc'
STOP Bootstrapper 18.0.57 prep-install for BASE AT Sun Dec 31 14:42:15 CET 2023
I wanted to update Plesk Obsidian 18.0.34 to 18.0.57 via the web updater. So far so good.
But then the installation was aborted (Trying to find Plesk database psa... not found - see the log file).
Now my question is, theoretically I could restore the psa database from the backup - right?
But what happens next? Does the updater recognize that parts of the update have already been completed?
The hosted websites are running, but the Plesk interface is simply not available. It's also a productive server where I can't afford long downtimes.
Thanks
-----------------------------
Log-File
-----------------------------
START Bootstrapper 18.0.57 prep-install for BASE AT Sun Dec 31 14:41:58 CET 2023
**** 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
config updated
===> Updated /etc/psa/psa.conf
Trying to save legacy variables... done
Checking that /opt/psa/bin/chrootsh registered as login shell...
===> Performing safe prep-install database actions
===> Upgrading database
Trying to start service mysql... 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'
ERROR while trying to run the following SQL query: SELECT val FROM misc WHERE param = 'aps_database'
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.18.0.34-18.0.57.20231231-144159.dump.gz
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
ERROR while trying to run the following SQL query: SELECT val FROM misc WHERE param = 'aps_database'
===> Cumulative Plesk database upgrade (revertable stage) has been started.
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
ERROR while trying to run the following SQL query: SHOW TABLES LIKE 'misc'
===> Restoring database from backup /var/lib/psa/dumps/mysql.preupgrade.18.0.34-18.0.57.20231231-144159.dump.gz
**** Product prep-install for BASE failed.
***** problem report *****
ERROR while trying to run the following SQL query: SELECT val FROM misc WHERE param = 'aps_database'
***** problem report *****
ERROR while trying to run the following SQL query: SELECT val FROM misc WHERE param = 'aps_database'
***** problem report *****
ERROR while trying to run the following SQL query: SHOW TABLES LIKE 'misc'
STOP Bootstrapper 18.0.57 prep-install for BASE AT Sun Dec 31 14:42:15 CET 2023