[Solved] Problems with mysql after du today

[harley-peter]

After the du today mysql cannot start.

Code Auswählen Erweitern

invoke-rc.d mysql start
Job for mysql.service failed because the control process exited with error code.
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: exit-code) since Mon 2021-09-06 14:16:10 CEST; 14ms ago
    Process: 48273 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=217/USER)


Code Auswählen Erweitern

systemctl status mysql.service
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Mon 2021-09-06 14:16:11 CEST; 53s ago
    Process: 48279 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=217/USER)
        CPU: 2ms

Sep 06 14:16:11 master systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Sep 06 14:16:11 master systemd[1]: Stopped MySQL Community Server.
Sep 06 14:16:11 master systemd[1]: mysql.service: Start request repeated too quickly.
Sep 06 14:16:11 master systemd[1]: mysql.service: Failed with result 'exit-code'.
Sep 06 14:16:11 master systemd[1]: Failed to start MySQL Community Server.


What can I do?

[Geier0815]

Reboot?
If that doesn't help have a closer look with "journalctl -u mysql"

[harley-peter]

Thank's, after a reboot today mysql seems to work but with some warnings and errors.

Code Auswählen Erweitern

systemctl status mysql.service
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: active (running) since Tue 2021-09-07 09:25:40 CEST; 12min ago
    Process: 949 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
   Main PID: 1031 (mysqld)
     Status: "Server is operational"
      Tasks: 37 (limit: 9460)
     Memory: 428.3M
        CPU: 3.342s
     CGroup: /system.slice/mysql.service
             └─1031 /usr/sbin/mysqld

Sep 07 09:25:39 master mysqld[1031]: 2021-09-07T07:25:39.455056Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
Sep 07 09:25:39 master mysqld[1031]: 2021-09-07T07:25:39.455431Z 0 [ERROR] [MY-013180] [Server] Function 'federated' already exists.
Sep 07 09:25:39 master mysqld[1031]: 2021-09-07T07:25:39.455896Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
Sep 07 09:25:39 master mysqld[1031]: 2021-09-07T07:25:39.456185Z 0 [ERROR] [MY-013180] [Server] Function 'innodb' already exists.
Sep 07 09:25:39 master mysqld[1031]: 2021-09-07T07:25:39.456590Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
Sep 07 09:25:39 master mysqld[1031]: 2021-09-07T07:25:39.470983Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: >
Sep 07 09:25:39 master mysqld[1031]: 2021-09-07T07:25:39.920216Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
Sep 07 09:25:39 master mysqld[1031]: 2021-09-07T07:25:39.920875Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are >
Sep 07 09:25:40 master mysqld[1031]: 2021-09-07T07:25:40.148962Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.23-3+b1'  socket:>
Sep 07 09:25:40 master systemd[1]: Started MySQL Community Server.