Suoritettu

MySQL error, service keeps crashing and have problems to reload

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.

Taidot: MySQL, Web hosting, WHMCS, Järjestelmänvalvoja, Apache

Näytä lisää: mysql centos service, capturing mysql error messages php, php capturing mysql error, mysql error 1054 cre loaded, mysql error 2006 hy0000, add products mysql error occured cubecart, sendstudio 2004 mysql error, mysql error code 1054 using case, wordpress keeps crashing server, safari firefox keeps crashing, oscommerce psigate mysql error, wordpress keeps crashing mysql, fix slowness crashing error messages and other problems, mysql workbench keeps crashing, mysql keeps crashing ubuntu, wordpress mysql keeps crashing, the subprocess “/usr/local/cpanel/scripts/restartsrv_mysql” reported error number 255 when it ended., ubuntu mysql keeps crashing, digitalocean mysql keeps crashing

Tietoa työnantajasta:
( 1 arvostelu ) Lima, Peru

Projektin tunnus: #32205812

Myönnetty käyttäjälle:

udayarpandey2022

Greetings! I can debug and fix the issue. Thank you!

$30 USD 1 päivässä
(343 Arvostelua)
6.8

7 freelanceria on tarjonnut keskimäärin $54 tähän työhön

(309 arvostelua)
6.7
drkamine

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 sys Lisää

$30 USD 1 päivässä
(102 arvostelua)
6.1
gattes

Hola como estas? Mandame un mensaje y lo vemos, tengo más de 10 años de experiencia con Linux y DBs como MySQL y Postgres. Saludos

$30 USD 1 päivässä
(21 arvostelua)
4.9
linuxadviser

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 Lisää

$20 USD 1 päivässä
(7 arvostelua)
1.9
ashutoshaet

Hello, I have studied your post and understood the requirement that you are looking for MySQL error, service keeps crashing and have problems to reload. I would like to let you know that I have more than 10 years of Lisää

$30 USD 7 päivässä
(0 arvostelua)
0.0
deepbluesys

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 you Lisää

$200 USD 7 päivässä
(0 arvostelua)
0.0