Resolved Update fails: Trying to set psa database version to 017000017... ERROR 2013 (HY000)

[daanse]

Hi,
tonight Plesk Onyx update failed.
I dont really understand what the Problem was.
If i start manually it works.

I had:
OS ‪Debian 8.7‬
Product Plesk Onyx
Version 17.0.17 Update #23; 22. April 2017

What can i do?

Execution failed.
Command: autoinstaller
Arguments: Array
(
    [0] => --select-product-id
    [1] => plesk
    [2] => --select-release-current
    [3] => --upgrade-installed-components
)

Details: Downloading file products.inf3: 0%
Downloading file products.inf3: 100% was finished.
Downloading file plesk.inf3: 0%
Downloading file plesk.inf3: 100% was finished.
Downloading file ppsmbe.inf3: 0% .................

...................

Hit http://autoinstall.plesk.com jessie/extras amd64 Packages
Get:7 http://autoinstall.plesk.com jessie/all i386 Packages [602 B]
Hit http://repo.cloudlinux.com stable InRelease
Hit http://autoinstall.plesk.com jessie/extras i386 Packages
Hit https://download.patchman.co jessie Release.gpg

Fetched 92.5 kB in 3s (27.2 kB/s)
Reading package lists...
W: There is no public key available for the following key IDs:
1397BC53640DB551
W: Duplicate sources.list entry http://autoinstall.plesk.com/debian/PMM_0.1.10/ jessie/all amd64 Packages (/var/lib/apt/lists/autoinstall.plesk.com_debian_PMM%5f0.1.10_dists_jessie_all_binary-amd64_Packages)
Warning: not connected 'contrib' repository section
Warning: not connected 'non-free' repository section
Detecting installed product components.
OK
Synchronizing the Debian APT package index files...
Ign http://debmirror.netcup.net jessie InRelease

....................

Hit https://download.bloonix.de jessie Release
Hit http://debmirror.netcup.net jessie/main Translation-en
Ign https://download.patchman.co jessie InRelease
.........
Reading package lists...
W: There is no public key available for the following key IDs:
1397BC53640DB551
W: Duplicate sources.list entry http://autoinstall.plesk.com/debian/PMM_0.1.10/ jessie/all amd64 Packages (/var/lib/apt/lists/autoinstall.plesk.com_debian_PMM%5f0.1.10_dists_jessie_all_binary-amd64_Packages)
Retrieving information about the installed license key...
Launching component and product checkers...
Downloading file PSA_17.0.17/examiners/disk_space_check.sh: 0%
Downloading file PSA_17.0.17/examiners/disk_space_check.sh: 100% was finished.
Downloading file PSA_17.0.17/examiners/panel_preupgrade_checker.php: 0%
Downloading file PSA_17.0.17/examiners/panel_preupgrade_checker.php: 100% was finished.
Downloading file PSA_17.0.17/examiners/php_launcher.sh: 0%
Downloading file PSA_17.0.17/examiners/php_launcher.sh: 100% was finished.
Checking whether the package dependencies are resolved.
Installing packages
is running
Stopping sw_engine service... done
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).

**** Product prep-install started.

===> Checking for previous installation ... found.
Create user 'psaadm' and group 'psaadm'
 Checking for the group 'psaadm'...
 Group 'psaadm' already exists

 Checking for the user 'psaadm'...
 User 'psaadm' already exists

Create group swkey-data
 Checking for the group 'swkey-data'...
 Group 'swkey-data' already exists

 Checking for the group 'swkey-data'...
 Trying to add supplementary group 'swkey-data' for user 'psaadm'...  already there
Create Mail accounts
 Checking for the group 'popuser'...
 Group 'popuser' already exists

 Checking for the user 'popuser'...
 User 'popuser' already exists

 Checking for the user 'mhandlers-user'...
 User 'mhandlers-user' already exists

 Trying to got legacy variables... done
 Trying to save legacy variables... done
 Trying to resolve hostname 'myhostname' and validate its IP address... done


===> Checking for the necessary system accounts
 Checking for the system groups and users necessary for admin server...
 Checking for the group 'psaadm'...
 Group 'psaadm' already exists

 Checking for the user 'psaadm'...
 User 'psaadm' already exists

 Checking for the group 'psaserv'...
 Group 'psaserv' already exists

 Checking for the group 'psaserv'...
 Trying to add supplementary group 'psaserv' for user 'psaadm'...  already there
 Checking for the group 'psacln'...
 Group 'psacln' already exists

 Checking that /opt/psa/bin/chrootsh registered as login shell...


===> Performing safe prep-install database actions


===> Upgrading database

 Trying to start service mysql... /usr/sbin/mysqld (pid 18298) is running...
done
 Trying to establish test connection... connected
done
 Trying to find psa database... version is 017000017
 Trying to backup MySQL database... done
 MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.17.0.17-17.0.17.20170425-062547.dump.gz
 Trying to allow INNODB engine... done
Restarting mysql Trying to restart service mysql... /usr/sbin/mysqld (pid 18298) is running...
done
===> 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.17.0.17-17.0.17.20170425-062615.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 017000017... ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")

ERROR while trying to execute SQL query, the query was: replace into misc (param,val) values('version', '017000017')
Check the error reason(see log file: /var/log/plesk/install/plesk_17.0.17_installation.log), fix and try again

Stopping sw-cp-server (via systemctl): sw-cp-server.service.
Starting sw_engine service... done
Starting sw_cp_server service... done
Starting mysql service... already started
Starting named service... done
Starting mailer service... already started
Starting spamfilter service... already started
Starting drweb service... done
Starting tomcat service... not installed
Starting apache service... already started
Starting xinetd service... already started
*****  problem report *****
ERROR while trying to execute SQL query, the query was: replace into misc (param,val) values('version', '017000017')
Check the error reason(see log file: /var/log/plesk/install/plesk_17.0.17_installation.log), fix and try again

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.
If you cannot resolve the issue on your own, contact product technical support for assistance.

 

[UFHH01]

Hi daanse,

===> Preparing Plesk database upgrade (revertable stage). Trying to set psa database version to 017000017... ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer" ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")

This indicates, that the MySQL - server may not be running at the moment. Pls. check it with "ps -aux | grep mysql" for example and make sure, that you are able to connect to your psa - database with the example commands:

plesk db

or

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

 

[daanse]

Hi @UFHH01
hi,
well this worked before and it still does. Running command now works.
I have the feeling that everything which can go wrong, does only at 6.30 am in the Morning.