MySQL error, service keeps crashing and have problems to reload
$10-30 USD
Imekamilika
Imechapishwa over 2 years ago
$10-30 USD
Kulipwa wakati wa kufikishwa
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/[login to view URL] 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/[login to view URL]'.
200118 11:45:12 mysqld_safe mysqld from pid file /var/lib/mysql/[login to view URL] 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.
Regards,
********************************
PS:
Here is some extra information when I manually restart the service:
********************************
Waiting for “mysql” to start ……waiting for “mysql” to initialize ………finished.
Service Status
mysqld (/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/[login to view URL]) is running as mysql with PID 8080 (systemd+/proc check method).
Startup Log
Nov 26 11:53:26 [login to view URL] mysqld[8077]: 2021-11-26T16:53:26.761910Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
Nov 26 11:53:26 [login to view URL] mysqld[8077]: 2021-11-26T16:53:26.761917Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
Nov 26 11:53:26 [login to view URL] mysqld[8077]: 2021-11-26T16:53:26.763946Z 0 [Warning] CA certificate [login to view URL] is self signed.
Nov 26 11:53:26 [login to view URL] mysqld[8077]: 2021-11-26T16:53:26.764074Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
Nov 26 11:53:26 [login to view URL] mysqld[8077]: 2021-11-26T16:53:26.766858Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
Nov 26 11:53:26 [login to view URL] mysqld[8077]: 2021-11-26T16:53:26.767016Z 0 [Note] IPv6 is available.
Nov 26 11:53:26 [login to view URL] mysqld[8077]: 2021-11-26T16:53:26.767045Z 0 [Note] - '::' resolves to '::';
Nov 26 11:53:26 [login to view URL] mysqld[8077]: 2021-11-26T16:53:26.767075Z 0 [Note] Server socket created on IP: '::'.
Nov 26 11:53:26 [login to view URL] mysqld[8077]: 2021-11-26T16:53:26.980993Z 0 [Note] Event Scheduler: Loaded 0 events
Nov 26 11:53:26 [login to view URL] systemd[1]: Started MySQL Server.
Hello, I'm an IT expert with more than 15 years of experience in the IT industry . I'm Cisco Certified networking professional 300-100 and 300-115 and Linux Certified Professional lpi 101, 102 and red hat certified system administrator and VMware Certified Professional 4, 5,5.5 and Data Center and Microsoft System administrateur /Engineer ranging from 2003 to 2012 .
Hello,
Hope you are doing well. I have 6 years of experience in the Linux system administration with mysql configuration. It was easy task for me. . We can discuss more in the chat.
I certified from aws and cpanel
Thanks
Please send me error log
I am having over 20 years of experience, with certification in Mysql administration and AWS, I have a master of computer application post graduate degree as well.
Contact me now to resolve your issue.
I will do it today.
Best regards
Constantine Stanley