ใช้ Digital ocean นะครับ คือใช้มาปกติหลายเดือนมาก แต่อยู่ๆมันก็ ปิดตัวเองแล้วรันไม่ได้อีกเลย
เอาคำสั่งกับ error มาให้ช่วยดูหน่อยอะครับ งมมาหลายวันแล้ว รบกวนด้วยนะครับ ขอบคุณมากครับ อยากแก้โดยไม่ต้องลงใหม่นะครับ เพราะมี db สำคัญอยู่ ไม่รู้จะ backup ออกมายังไงครับถ้ารัน mysql ไม่ได้
เป็น Ubuntu 16.04.1 LTS
ใช้คำสั่งนี้# service 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.
เช็ค error ด้วย# systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start-post) (Result: exit-code) since Mon 2016-11-28 18:19:21 UTC; 22s ago
Process: 21703 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 21700 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 21703 (code=exited, status=1/FAILURE); : 21704 (mysql-systemd-s)
Tasks: 2
Memory: 316.0K
CPU: 378ms
CGroup: /system.slice/mysql.service
└─control
├─21704 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─21754 sleep 1
Nov 28 18:19:21 MONOWHEEL.BIKE systemd[1]: Starting MySQL Community Server…
Nov 28 18:19:22 MONOWHEEL.BIKE systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
กับ# journalctl -xe
– Unit mysql.service has failed.
– The result is failed.
Nov 28 18:19:21 MONOWHEEL.BIKE systemd[1]: mysql.service: Unit entered failed state.
Nov 28 18:19:21 MONOWHEEL.BIKE systemd[1]: mysql.service: Failed with result ‘exit-code’.
Nov 28 18:19:21 MONOWHEEL.BIKE systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Nov 28 18:19:21 MONOWHEEL.BIKE systemd[1]: Stopped MySQL Community Server.
– Subject: Unit mysql.service has finished shutting down
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
– Unit mysql.service has finished shutting down.
Nov 28 18:19:21 MONOWHEEL.BIKE systemd[1]: Starting MySQL Community Server…
– Subject: Unit mysql.service has begun start-up
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
– Unit mysql.service has begun starting up.
Nov 28 18:19:22 MONOWHEEL.BIKE systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Nov 28 18:19:52 MONOWHEEL.BIKE systemd[1]: Failed to start MySQL Community Server.
– Subject: Unit mysql.service has failed
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
– Unit mysql.service has failed.
– The result is failed.
Nov 28 18:19:52 MONOWHEEL.BIKE systemd[1]: mysql.service: Unit entered failed state.
Nov 28 18:19:52 MONOWHEEL.BIKE systemd[1]: mysql.service: Failed with result ‘exit-code’.
Nov 28 18:19:52 MONOWHEEL.BIKE systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Nov 28 18:19:52 MONOWHEEL.BIKE systemd[1]: Stopped MySQL Community Server.
– Subject: Unit mysql.service has finished shutting down
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
– Unit mysql.service has finished shutting down.
Nov 28 18:19:52 MONOWHEEL.BIKE systemd[1]: Starting MySQL Community Server…
– Subject: Unit mysql.service has begun start-up
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
– Unit mysql.service has begun starting up.
Nov 28 18:19:52 MONOWHEEL.BIKE systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE