Как решить ошибку при установке mysql-server?

Question

[szQocks]

При установке:

root@box-715892:~# sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server is already the newest version (8.0.31-0ubuntu0.20.04.1).
0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up mysql-server-8.0 (8.0.31-0ubuntu0.20.04.1) ...
Renaming removed key_buffer and myisam-recover options (if present)
mysqld will log errors to /var/log/mysql/error.log
2022-11-28T11:28:46.334258Z 0 [ERROR] [MY-011065] [Server] Unable to determine if daemon is running: No such file or directory (rc=0).
2022-11-28T11:28:46.335819Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
Warning: Unable to start the server.
Job for mysql.service failed because a fatal signal was delivered to the control process.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: activating (auto-restart) (Result: signal) since Mon 2022-11-28 14:28:49 MSK; 71ms ago
    Process: 7541 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 7559 ExecStart=/usr/sbin/mysqld (code=killed, signal=KILL)
   Main PID: 7559 (code=killed, signal=KILL)
     Status: "Server startup in progress"
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Errors were encountered while processing:
 mysql-server-8.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@box-715892:~#

При вызове "systemctl status mysql.service":

● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: failed (Result: signal) since Mon 2022-11-28 14:28:57 MSK; 3min 50s ago
    Process: 7633 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 7644 ExecStart=/usr/sbin/mysqld (code=killed, signal=KILL)
   Main PID: 7644 (code=killed, signal=KILL)
     Status: "Server startup in progress"

Nov 28 14:28:57 box-715892 systemd[1]: mysql.service: Failed with result 'signal'.
Nov 28 14:28:57 box-715892 systemd[1]: Failed to start MySQL Community Server.
Nov 28 14:28:57 box-715892 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Nov 28 14:28:57 box-715892 systemd[1]: Stopped MySQL Community Server.
Nov 28 14:28:57 box-715892 systemd[1]: mysql.service: Start request repeated too quickly.
Nov 28 14:28:57 box-715892 systemd[1]: mysql.service: Failed with result 'signal'.
Nov 28 14:28:57 box-715892 systemd[1]: Failed to start MySQL Community Server.

Comments

[Геннадий]

Смотрите, что в /var/log/mysql/error.log

[szQocks]

Геннадий, смотрел, ничего интересного, единственное что-то про юзера там пишет...

root@box-715950:~# cat /var/log/mysql/error.log
2022-11-28T11:58:13.608899Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) initializing of server in progress as process 1683
2022-11-28T11:58:13.642418Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:16.565699Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-11-28T11:58:22.966473Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2022-11-28T11:58:27.878388Z 6 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.31-0ubuntu0.20.04.1).
2022-11-28T11:58:34.219417Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 1734
2022-11-28T11:58:34.311422Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:37.511489Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 1876
2022-11-28T11:58:37.593973Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:40.198876Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 1992
2022-11-28T11:58:40.280916Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:42.282268Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2227
2022-11-28T11:58:42.324368Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:43.837061Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2355
2022-11-28T11:58:43.943555Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:45.395408Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2393
2022-11-28T11:58:45.608825Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:47.428921Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2417
2022-11-28T11:58:47.636624Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:49.944050Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2439
2022-11-28T11:58:50.060890Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:52.595294Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2456
2022-11-28T11:58:52.676111Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:53.992346Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2487
2022-11-28T11:58:54.012315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:55.169586Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2510
2022-11-28T11:58:55.187328Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:56.451401Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2532
2022-11-28T11:58:56.476247Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-28T11:58:57.636715Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 2556
2022-11-28T11:58:57.661802Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
root@box-715950:~#

Answer 1

[szQocks]

Проблема в том что машине недостаточно оперативной памяти для запуска процесса, решить это можно двумя способами на сколько я узнал:
1 - swapfile , гуглиться очень просто к примеру - "swapfile ubuntu"
2 - расширить оперативку сменой тарифа на хосте