Find Jobs
Hire Freelancers

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.
Kitambulisho cha mradi: 32205812

Kuhusu mradi

7 mapendekezo
Mradi wa mbali
Inatumika 2 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Greetings! I can debug and fix the issue. Thank you!
$30 USD ndani ya siku 1
5.0 (343 hakiki)
6.8
6.8
7 wafanyakazi huru wana zabuni kwa wastani $54 USD kwa kazi hii
Picha ya Mtumiaji
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 .
$30 USD ndani ya siku 1
4.9 (102 hakiki)
6.1
6.1
Picha ya Mtumiaji
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 ndani ya siku 1
5.0 (21 hakiki)
4.9
4.9
Picha ya Mtumiaji
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
$20 USD ndani ya siku 1
5.0 (7 hakiki)
1.9
1.9
Picha ya Mtumiaji
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
$200 USD ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya PERU
Lima, Peru
5.0
1
Njia ya malipo imethibitishwa
Mwanachama tangu Nov 26, 2021

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.