Question

Problems starting MySQL server

Posted October 30, 2019 1.3k views
MySQLUbuntu 18.04

I’m trying to setup Open Game Panel on my droplet, and it needs a MySQL database. When I try to start it, I get:

Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.

Doing systemctl status mysql.service gives me:


● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Wed 2019-10-30 20:27:18 UTC; 34s ago
  Process: 2242 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

Oct 30 20:27:18 colinvps systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Oct 30 20:27:18 colinvps systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Oct 30 20:27:18 colinvps systemd[1]: Stopped MySQL Community Server.
Oct 30 20:27:18 colinvps systemd[1]: mysql.service: Start request repeated too quickly.
Oct 30 20:27:18 colinvps systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 30 20:27:18 colinvps systemd[1]: Failed to start MySQL Community Server.

Doing journalctl -xe gives me:

Oct 30 20:28:57 colinvps systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Oct 30 20:28:57 colinvps systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Automatic restarting of the unit mysql.service has been scheduled, as the result for
-- the configured Restart= setting for the unit.
Oct 30 20:28:57 colinvps systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has finished shutting down.
Oct 30 20:28:57 colinvps systemd[1]: mysql.service: Start request repeated too quickly.
Oct 30 20:28:57 colinvps systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 30 20:28:57 colinvps systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has failed.
--
-- The result is RESULT.

I’ve messed with a bunch of stuff and nothing works.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Hi @colp3505,

Try to restart your mysql and try to use fullstatus instead of status afterwards for the service

systemctl fullstatus mysql

I’ll recommend checking your mysql error_log, it should state why it’s having troubles starting up.

Other common issues come from a droplet being full, not enough inodes, corrupted innodb.

Regards,
KDSys

Submit an Answer