ubuntu 20.04 mysql shutted down automatically - error logs attached
$10-30 USD
Betalt ved levering
Ubuntu 20.04 running mysql just shutted down automatically.
Appreciate your assistance
******** SYS LOG*********
Oct 29 05:56:10 ip-172-31-76-148 systemd-timesyncd[499]: Synchronized to time server [login to view URL] ([login to view URL]).
Oct 29 06:05:33 ip-172-31-76-148 systemd[1]: Starting Daily apt upgrade and clean activities...
Oct 29 06:06:06 ip-172-31-76-148 systemd[1]: Reloading.
Oct 29 06:06:07 ip-172-31-76-148 systemd[1]: Stopping MySQL Community Server...
Oct 29 06:06:10 ip-172-31-76-148 systemd[1]: Stopped MySQL Community Server.
Oct 29 06:06:10 ip-172-31-76-148 systemd[1]: Reloading.
Oct 29 06:06:14 ip-172-31-76-148 kernel: [2217687.756804] kauditd_printk_skb: 1 callbacks suppressed
Oct 29 06:06:14 ip-172-31-76-148 kernel: [2217687.756805] audit: type=1400 audit(1603951574.009:54): apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name="/usr/sbin/mysqld" pid=5416 comm="apparmor_parser"
Oct 29 06:06:21 ip-172-31-76-148 kernel: [2217695.082256] audit: type=1400 audit(1603951581.333:55): apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name="/usr/sbin/mysqld" pid=5548 comm="apparmor_parser"
Oct 29 06:06:21 ip-172-31-76-148 systemd[1]: message repeated 4 times: [ Reloading.]
Oct 29 06:06:21 ip-172-31-76-148 systemd[1]: Starting MySQL Community Server...
Oct 29 06:06:22 ip-172-31-76-148 systemd[1]: Started MySQL Community Server.
Oct 29 06:06:22 ip-172-31-76-148 systemd[1]: Reloading.
Oct 29 06:06:48 ip-172-31-76-148 systemd[1]: Started Daily apt upgrade and clean activities.
****MYSQL ERROR LOG*****
2020-10-28T07:55:50.171399Z 157 [Note] Aborted connection 157 to db: 'DB' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T07:55:50.171528Z 156 [Note] Aborted connection 156 to db: 'DB' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T06:06:07.113119Z 0 [Note] Giving 1 client threads a chance to die gracefully
2020-10-29T06:06:07.115763Z 0 [Note] Shutting down slave threads
2020-10-29T06:06:09.119263Z 0 [Note] Forcefully disconnecting 1 remaining clients
2020-10-29T06:06:09.119317Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 147 user: 'root'
2020-10-29T06:06:09.120199Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T06:06:09.126737Z 0 [Note] Binlog end
2020-10-29T06:06:09.140508Z 0 [Note] Shutting down plugin 'auth_socket'
2020-10-29T06:06:09.141097Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T06:06:09.141108Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T06:06:09.141113Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T06:06:09.142207Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T06:06:09.142215Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T06:06:09.144282Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T06:06:09.144298Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T06:06:09.146592Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T06:06:09.146606Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T06:06:09.146609Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T06:06:09.146614Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T06:06:09.146617Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T06:06:09.146621Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T06:06:09.146625Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T06:06:09.151981Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T06:06:09.152112Z 0 [Note] InnoDB: Starting shutdown...
Projekt ID: #27950516
Om projektet
9 freelancere byder i gennemsnit $49 timen for dette job
Hello. I would like to help you with fixing mysql auto reloading on Uubntu 20. Current logs did not show source a problem simple shutdown without explaining. Please read my feedbacks. Thank you.
Hi I am system admin, will resolve the issues as per your requirement, and have expertise in the relevant field. I have 10 years of experience. Ping me for further queries. Thanks
Hi, I will check and fix why mysql got down and make server live and up again. I have 13 years of experience in server work. Let's discuss. Thank you
Yes, I will surely help you in resolving this error but first I need to check and need some details. Kindly initiate the chat and share some details so I can resolve this. Thanks & Regards Abhishek K.
Hi, I will audit teh configuration and will resolve ubuntu issue. I do have more than 8 years of expertise in web hosting, server setup, server configuration, etc Please discuss to start. Thank you.
From what you post, it appears there maybe data corruption. The connection on the local hosts are being rejected and apparently root is connected more than once. The two possibilities is hardware fault at disk level an Flere
Hello, I have 9+ years of experience as linux sysadmin, I can do the job. I know what happened to your MySQL and I can fix it in a couple of minutes.