The entire VPS freezes when updating, where to dig?

Question

MySQL

Hi all.
I'm ashamed to write but I don't have the strength to fight it

With a banal apt update and a subsequent apt upgrade, the VPS goes into a stupor and even the console

hangs
. Not a day goes by without something happening! FACE PALM
If possible, then bypass this division, I didn’t listen to smart people in vain, I fell for the novelty ... :((((

UPD

apt purge memcached
E: Работа dpkg была прервана, вы должны вручную запустить «dpkg --configure -a» для устранения проблемы.

If you run the program again, everything hangs tightly ...

spoiler

This installation of MySQL is already upgraded to 5.7.29, use --force if you still need to run mysql_upgrade
dpkg --configure -a
Настраивается пакет mysql-server-5.7 (5.7.29-0ubuntu0.18.04.1) …
Checking if update is needed.
This installation of MySQL is already upgraded to 5.7.29, use --force if you still need to run mysql_upgrade
^Cdpkg: ошибка при обработке пакета mysql-server-5.7 (--configure):
installed mysql-server-5.7 package post-installation script subprocess was interrupted
dpkg: зависимости пакетов не позволяют настроить пакет mysql-server:
mysql-server зависит от mysql-server-5.7, однако:
Пакет mysql-server-5.7 пока не настроен.

dpkg: ошибка при обработке пакета mysql-server (--configure):
проблемы зависимостей — оставляем не настроенным
Обрабатываются триггеры для linux-image-4.15.0-76-generic (4.15.0-76.86) …
/etc/kernel/postinst.d/initramfs-tools:
update-initramfs: Generating /boot/initrd.img-4.15.0-76-generic
^Cdpkg: ошибка при обработке пакета linux-image-4.15.0-76-generic (--configure):
installed linux-image-4.15.0-76-generic package post-installation script subprocess was interrupted
При обработке следующих пакетов произошли ошибки:
mysql-server-5.7
mysql-server
linux-image-4.15.0-76-generic

apt upgrade
Чтение списков пакетов… Готово
Построение дерева зависимостей
Чтение информации о состоянии… Готово
Расчёт обновлений… Готово
Обновлено 0 пакетов, установлено 0 новых пакетов, для удаления отмечено 0 пакетов, и 0 пакетов не обновлено.
Установлено или удалено не до конца 3 пакетов.
После данной операции объём занятого дискового пространства возрастёт на 0 B.
Хотите продолжить? [Д/н] y
Настраивается пакет linux-image-4.15.0-76-generic (4.15.0-76.86) …
Настраивается пакет mysql-server-5.7 (5.7.29-0ubuntu0.18.04.1) …
/var/lib/mysql/ibdata1: 7055
ERROR: Database files are locked. Daemon already running?
Warning: Unable to start the server. Please restart MySQL and run mysql_upgrade to ensure the database is ready for use.
/var/lib/mysql/ibdata1: 7055
ERROR: Database files are locked. Daemon already running?
Warning: Unable to start the server.
^F^H^G^H^B^N^N

^X
Job for mysql.service canceled.
invoke-rc.d: initscript mysql, action "start" failed.

На этом месте все зависает и консоль не реагирует ни на что....

Answer 1

18 Ubuntu has been on the server for a year and a half (or even more). Rather, it was you who stole something, or the evil and terrible apt broke everything you could.
To get started, you should go to dmesg, check top, htop, iotop, atop, free and finally the size of the disk.
Well, I would like to hear the characteristics of VPS.

Answer 2

Judging by the log, you have an error when updating sql, and as a result, errors now appear when installing any package. Try finishing the update manually.
https://mariadb.com/kb/en/mysql_upgrade/

Answer 3

you must manually run "dpkg --configure -a"
and post the log, otherwise nothing is clear.
basic errors: running out of free space
is not scary, you can add to VPS
it is also possible and necessary to check the disk for errors with fsck
it is quite possible that you have an unreliable host and disks with an error