Level 18
First look would be to run journalctl -xe for details on WHY it's not loading, that should give you a starting point of where to look/whats going.
Feb 28, 2019
3
Level 1
mysql not restarting
Server has just rebooted and site wouldn't load. I'm now getting the following error in forge when I reboot mysql
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
Any idea what's going on or where to start debugging?
Level 1
Just run that. Getting the following...
-- The start-up result is RESULT.
Feb 28 20:49:40 walkiees systemd[1435]: Reached target Basic System.
-- Subject: Unit UNIT has finished start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit UNIT has finished starting up.
--
-- The start-up result is RESULT.
Feb 28 20:49:40 walkiees systemd[1435]: Reached target Default.
-- Subject: Unit UNIT has finished start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit UNIT has finished starting up.
--
-- The start-up result is RESULT.
Feb 28 20:49:40 walkiees systemd[1435]: Startup finished in 59ms.
-- Subject: User manager start-up is now complete
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The user manager instance for user 1000 has been started. All services queued
-- for starting have been started. Note that other services might still be starting
-- up or be started at any later time.
--
-- Startup of the manager took 59706 microseconds.
Feb 28 20:55:10 walkiees sshd[2864]: error: connect_to 127.0.0.1 port 3306: failed.
Feb 28 20:55:10 walkiees sshd[2864]: error: connect_to 139.162.198.254 port 3306: failed.
Feb 28 20:55:10 walkiees sshd[2864]: Received disconnect from 95.145.150.200 port 62766:11: disconnected by user
Feb 28 20:55:10 walkiees sshd[2864]: Disconnected from user forge 95.145.150.200 port 62766
Feb 28 21:13:08 walkiees sshd[1524]: Received disconnect from 95.145.150.200 port 62666:11: cleanup
Feb 28 21:13:08 walkiees sshd[1524]: Disconnected from user forge 95.145.150.200 port 62666
Feb 28 21:14:35 walkiees sshd[3961]: Received disconnect from 95.145.150.200 port 63151:11: cleanup
Feb 28 21:14:35 walkiees sshd[3961]: Disconnected from user forge 95.145.150.200 port 63151
Feb 28 21:15:32 walkiees sshd[4045]: Received disconnect from 95.145.150.200 port 63152:11: cleanup
Feb 28 21:15:32 walkiees sshd[4045]: Disconnected from user forge 95.145.150.200 port 63152
Feb 28 21:15:39 walkiees sshd[4130]: Received disconnect from 95.145.150.200 port 63171:11: cleanup
Feb 28 21:15:39 walkiees sshd[4130]: Disconnected from user forge 95.145.150.200 port 63171
Feb 28 21:16:03 walkiees sshd[4212]: Received disconnect from 95.145.150.200 port 63173:11: cleanup
Feb 28 21:16:03 walkiees sshd[4212]: Disconnected from user forge 95.145.150.200 port 63173
Feb 28 21:29:35 walkiees sshd[1609]: Received disconnect from 95.145.150.200 port 62688:11: cleanup
Feb 28 21:29:35 walkiees sshd[1609]: Disconnected from user forge 95.145.150.200 port 62688
Feb 28 21:54:54 walkiees sshd[4493]: Received disconnect from 95.145.150.200 port 63855:11: cleanup
Feb 28 21:54:54 walkiees sshd[4493]: Disconnected from user forge 95.145.150.200 port 63855
Not really sure what that points to?
Level 9
There is usually an error log for mariadb in /var/lib/mysql, probably a file ending in .err
Please or to participate in this conversation.