MySQL error, service keeps crashing and have problems to reload
Budget: $10 – $30 USD
Hello, I am getting this error daily:
*****************
(XID s39h52) The “mysql” service is down.
The subprocess “/usr/local/cpanel/scripts/restartsrv_mysql” reported error number 2 when it ended.
***********************************
***********************************
200118 12:24:05 mysqld_safe mysqld from pid file /var/lib/mysql/mim.nsmimir.com.pid ended
2020-01-18 12:24:05 1807 [Note] /usr/sbin/mysqld: Shutdown complete
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1103 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1082 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 912 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1044 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1083 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 993 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1089 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1114 user: 'slimfit_wp990'
2020-01-18 12:24:01 1807 [Note] /usr/sbin/mysqld: Normal shutdown
2020-01-18 11:45:59 1807 [Note] /usr/sbin/mysqld: ready for connections.
200118 11:45:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200118 11:45:53 mysqld_safe Logging to '/var/lib/mysql/mim.nsmimir.com.err'.
200118 11:45:12 mysqld_safe mysqld from pid file /var/lib/mysql/mim.nsmimir.com.pid ended
2020-01-18 11:45:12 1814 [Note] /usr/sbin/mysqld: Shutdown complete
*********************************
What I find awkward is that the user ssgenius_55g no longer exists but something is calling it.
I want a definite solution for this please and also want to know what happened to prevent it in the future.
Regardos,
*****************
(XID s39h52) The “mysql” service is down.
The subprocess “/usr/local/cpanel/scripts/restartsrv_mysql” reported error number 2 when it ended.
***********************************
***********************************
200118 12:24:05 mysqld_safe mysqld from pid file /var/lib/mysql/mim.nsmimir.com.pid ended
2020-01-18 12:24:05 1807 [Note] /usr/sbin/mysqld: Shutdown complete
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1103 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1082 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 912 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1044 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1083 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 993 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1089 user: 'ssgenius_55g'
2020-01-18 12:24:03 1807 [Warning] /usr/sbin/mysqld: Forcing close of thread 1114 user: 'slimfit_wp990'
2020-01-18 12:24:01 1807 [Note] /usr/sbin/mysqld: Normal shutdown
2020-01-18 11:45:59 1807 [Note] /usr/sbin/mysqld: ready for connections.
200118 11:45:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200118 11:45:53 mysqld_safe Logging to '/var/lib/mysql/mim.nsmimir.com.err'.
200118 11:45:12 mysqld_safe mysqld from pid file /var/lib/mysql/mim.nsmimir.com.pid ended
2020-01-18 11:45:12 1814 [Note] /usr/sbin/mysqld: Shutdown complete
*********************************
What I find awkward is that the user ssgenius_55g no longer exists but something is calling it.
I want a definite solution for this please and also want to know what happened to prevent it in the future.
Regardos,