Ditutup

ubuntu 20.04 mysql shutted down automatically - error logs attached

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...

Kemahiran: Linux, MySQL, Ubuntu, Sistem Admin

Lihat lagi: mysql.service: main process exited, code=exited, status=2/invalidargument, mysql.service: start request repeated too quickly., mysql.service: main process exited, code=exited, status=1/failure, a stop job is running for advanced key-value store, mysqld.service: control process exited, code=exited status=1, job for mariadb service failed because a timeout was exceeded, execstartpre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/failure), a stop job is running for mysql community server, ubuntu mail server mysql, ubuntu postfix dovecot mysql, delete error logs ssh, fix error logs linux, wordpress error logs, remove error logs server ssh, ubuntu postfix postfixadmin mysql spamassassin courier, virtuemart error logs, ubuntu server optimize mysql web server, php error logs linux, php script create mysql database automatically, linux ubuntu postfix postfixadmin mysql

Tentang Majikan:
( 167 ulasan ) Doha, Qatar

ID Projek: #27950516

9 pekerja bebas membida secara purata $49 untuk pekerjaan ini

vili1977

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.

$20 USD dalam 7 hari
(918 Ulasan)
7.5
tanujchugh

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

$60 USD dalam sehari
(360 Ulasan)
7.0
kuldeepvk

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

$30 USD dalam sehari
(439 Ulasan)
7.1
anmoltech

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.

$35 USD dalam sehari
(51 Ulasan)
5.6
ArchnaAdmin

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.

$30 USD dalam sehari
(60 Ulasan)
5.0
matinict

Hi, You can pay me after solvemysql problem, I am Expert on Ubuntu especially web server 8 year+ Developer with LEMP/LAMP/Docker stack . I am interested to work with you on this project, I would like to have a conve Lagi

$20 USD dalam 7 hari
(8 Ulasan)
3.2
FutureNOWPK

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 Lagi

$200 USD dalam 11 hari
(2 Ulasan)
3.0
mzalazar

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.

$15 USD dalam sehari
(3 Ulasan)
1.8
falaksafi

Hi, I am an experienced web developer and system admin. I have good knowledge of MySql database management system. I have a good knowledge of MeriaDB configuration and error bugging skills. I have worked in many simil Lagi

$30 USD dalam 7 hari
(3 Ulasan)
1.4