Resolved Plesk update failed - seems linkd to mysqld missing.

[nbonniot]

Hello,
For a few days, my Plesk update fails.

The error is "ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129"

or :
"Error while sending QUERY packet. PID=15454 in /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Statement.php:228 "

Both seems linked to mysqld gone. If I try this resolution :

• I got df -h and df -i giving me enough sapce everywhere
• service mysqld start gives Failed to start mysqld.service: Unit mysqld.service not found.
  
• service mysqld status gives
• mysqld.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead)

But in my /var/log/mysql/error.log, nothing popped out.


Here below is the Plesk update log :

ANy clue on resolution for this?

Thanks !

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

Details: Doing restart of Plesk Installer...

/// Cut before everything was OK

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).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
===> Plesk database scheme upgrade has been started.
Applying migrations from: /opt/psa/bootstrapper/pp17.5.3-bootstrapper/migrations/
===> Plesk database scheme upgrade has been completed.
E: dpkg was interrupted, you must manually run 'dpkg --configure -a' to correct the problem.
Plesk is down, performing full restart.
Starting sw_engine service... done
Starting sw_cp_server service... already started
Starting mysql service... already started
Starting named service... already started
Starting mailer service... already started
Starting spamfilter service... not installed
Starting tomcat service... not installed
Starting apache service... already started
Starting xinetd service... already started

ERROR: Une erreur est survenue lors de la tentative d'installation des packs.
Attention ! Votre logiciel risque de ne pas fonctionner.
Contactez l'assistance technique du produit.

 

[UFHH01]

Hi nbonniot,

did you see your error - message?

E: dpkg was interrupted, you must manually run 'dpkg --configure -a' to correct the problem.

As you can see, there are unconfigured packages on your server, which needs to be configured, before you are able to continue to install/update/upgrade additional packages.

Pls. post the result from your command line, after you used the suggested "dpkg" - command, if you need further help.

 

[nbonniot]

Yes, sorry, I did it. THe result was the following :


Paramétrage de initramfs-tools (0.122ubuntu8.8) ...
update-initramfs: deferring update (trigger activated)
Traitement des actions différées (« triggers ») pour initramfs-tools (0.122ubuntu8.8) ...
update-initramfs: Generating /boot/initrd.img-4.8.0-44-generic
W: mdadm: /etc/mdadm/mdadm.conf defines no arrays.

Then bash gave me the hand back. I precise that my Plesk instance run on OVH VPS, so no physical RAID setup.

When I clicked on the "Repair the failed updgrade" on Plesk, it still said "
ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129"

 

[nbonniot]

And there is no array in /etc/mdadm/mdadm.conf. I found this , but before screwing things with MDADM, I would prefer to have some confirmations...

As

root@1:~# fdisk -l
Disk /dev/vda: 25 GiB, 26843545600 bytes, 52428800 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xffcebafc

Device Boot Start End Sectors Size Id Type
/dev/vda1 * 2048 52428766 52426719 25G 83 Linux

Should I conclude that I should add
ARRAY <ignore> devices=/dev/vda1

to remove this warning?

 

[UFHH01]

Hi nbonniot,

after your update/upgrade over the command line, it is highly recommended and essential, that you first continue with "apt-get" or "aptitude", so be sure, that all your packages are up-to-date on your server and installed without issues/errors/problems.

If you desire to get rid of such WARNINGS ( no errors... just warnings! ), pls. use for example:

ARRAY <ignore> devices=/dev/vda

( IF ( !!! ) your harddrive is defined as "vda" ) - This will tell "mdadm" to ignore the described message, as you don't use RAID on your server.​

Additional command suggestions:

apt-get autoremove

apt-get clean

aptitude update

aptitude upgrade

plesk installer --select-product-id plesk --select-release-current --reinstall-patch --install-component base

plesk repair installation -y -v

plesk repair all -y -v

 

[nbonniot]

THanks very much for your suggestions.
I didn't have time to to your commands after the autoremove, Plesk successfully updgrade itself this morning. As a sidenote, could you telle me if all commands you mentionned are embedded in upgrade process?

Thanks again for your quick and clean answer.

Nicolas

 

[nbonniot]

Note : a service mysqld status still gives that mysqld is missing. Nonetheless, I host several websites with databases that are working normally. Is this because MysQL is not using its daemon?