Find Jobs
Hire Freelancers

MySQL error, service keeps crashing and have problems to reload

$10-30 USD

Completed
Posted over 2 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 32205812

About the project

7 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Greetings! I can debug and fix the issue. Thank you!
$30 USD in 1 day
5.0 (343 reviews)
6.8
6.8
7 freelancers are bidding on average $54 USD for this job
User Avatar
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 in 1 day
4.9 (102 reviews)
6.1
6.1
User Avatar
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 in 1 day
5.0 (21 reviews)
4.9
4.9
User Avatar
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 in 1 day
5.0 (7 reviews)
1.9
1.9
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PERU
Lima, Peru
5.0
1
Payment method verified
Member since Nov 26, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.