I have a LEMP server in a Ubuntu instance and my MySQL are shutting down automatically… I have no idea what’s happening.
I had to manually restart it to keep the site online
Here is my mysql log
171228 9:33:37 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use$ 171228 9:33:37 [Note] Plugin 'FEDERATED' is disabled. 171228 9:33:37 InnoDB: The InnoDB memory heap is disabled 171228 9:33:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins 171228 9:33:37 InnoDB: Compressed tables use zlib 1.2.8 171228 9:33:37 InnoDB: Using Linux native AIO 171228 9:33:37 InnoDB: Initializing buffer pool, size = 32.0M 171228 9:33:37 InnoDB: Completed initialization of buffer pool 171228 9:33:37 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 171228 9:33:37 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 171228 9:33:37 InnoDB: Waiting for the background threads to start 171228 9:33:38 InnoDB: 5.5.53 started; log sequence number 19047428748 171228 9:33:38 InnoDB: !!! innodb_force_recovery is set to 1 !!! 171228 9:33:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 171228 9:33:38 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 171228 9:33:38 [Note] Server socket created on IP: '0.0.0.0'. 171228 9:33:38 [Warning] 'user' entry 'prestashop@%' has both a password and an authentication plugin specified. The password will be ignored. 171228 9:33:38 [Warning] 'user' entry 'tanda@%' has both a password and an authentication plugin specified. The password will be ignored. 171228 9:33:38 [Note] Event Scheduler: Loaded 0 events 171228 9:33:38 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.53-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) Here, my syslog:
Dec 28 06:55:13 ip-172-31-61-50 dhclient: DHCPREQUEST of 172.31.61.50 on eth0 to 172.31.48.1 port 67 (xid=0x6bf08516) Dec 28 06:55:13 ip-172-31-61-50 dhclient: DHCPACK of 172.31.61.50 from 172.31.48.1 Dec 28 06:55:13 ip-172-31-61-50 dhclient: bound to 172.31.61.50 -- renewal in 1505 seconds. Dec 28 07:00:01 ip-172-31-61-50 CRON[5985]: (smmsp) CMD (test -x /etc/init.d/sendmail && /usr/share/sendmail/sendmail cron-msp) Dec 28 07:09:01 ip-172-31-61-50 CRON[6510]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -x /usr/lib/php5/sessionclean ] && [ -d /var/lib/php5 ] && /usr/lib/php$ Dec 28 07:09:01 ip-172-31-61-50 CRON[6511]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean) Dec 28 07:09:01 ip-172-31-61-50 sendmail[6582]: vBS991lM006582: from=root, size=638, class=0, nrcpts=1, msgid=<201712280909.vBS991lM006582@ip-172-31-61-50.ec2.internal$ Dec 28 07:09:01 ip-172-31-61-50 sm-mta[6583]: vBS991Rq006583: from=<root@ip-172-31-61-50.ec2.internal>, size=954, class=0, nrcpts=1, msgid=<201712280909.vBS991lM006582$ Dec 28 07:09:01 ip-172-31-61-50 sendmail[6582]: vBS991lM006582: to=root, ctladdr=root (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=30638, relay=[127.0.0.1$ Dec 28 07:09:01 ip-172-31-61-50 sm-mta[6584]: vBS991Rq006583: to=<root@ip-172-31-61-50.ec2.internal>, ctladdr=<root@ip-172-31-61-50.ec2.internal> (0/0), delay=00:00:00$ Nov 10 02:09:01 ip-172-31-61-50 CRON[6586]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -x /usr/lib/php5/sessionclean ] && [ -d /var/lib/php5 ] && /usr/lib/php$ Dec 28 07:17:01 ip-172-31-61-50 CRON[6594]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Dec 28 07:20:01 ip-172-31-61-50 CRON[6598]: (smmsp) CMD (test -x /etc/init.d/sendmail && /usr/share/sendmail/sendmail cron-msp) Dec 28 07:20:19 ip-172-31-61-50 dhclient: DHCPREQUEST of 172.31.61.50 on eth0 to 172.31.48.1 port 67 (xid=0x6bf08516) Dec 28 07:20:19 ip-172-31-61-50 dhclient: DHCPACK of 172.31.61.50 from 172.31.48.1 Dec 28 07:20:19 ip-172-31-61-50 dhclient: bound to 172.31.61.50 -- renewal in 1572 seconds. Dec 28 07:39:01 ip-172-31-61-50 CRON[6640]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -x /usr/lib/php5/sessionclean ] && [ -d /var/lib/php5 ] && /usr/lib/php$ Dec 28 07:39:01 ip-172-31-61-50 CRON[6641]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean) Dec 28 07:39:02 ip-172-31-61-50 sendmail[6712]: vBS9d2aA006712: from=root, size=638, class=0, nrcpts=1, msgid=<201712280939.vBS9d2aA006712@ip-172-31-61-50.ec2.internal$ Dec 28 07:39:02 ip-172-31-61-50 sm-mta[6713]: vBS9d2ar006713: from=<root@ip-172-31-61-50.ec2.internal>, size=954, class=0, nrcpts=1, msgid=<201712280939.vBS9d2aA006712$ Dec 28 07:39:02 ip-172-31-61-50 sendmail[6712]: vBS9d2aA006712: to=root, ctladdr=root (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=30638, relay=[127.0.0.1$ Dec 28 07:39:02 ip-172-31-61-50 sm-mta[6714]: vBS9d2ar006713: to=<root@ip-172-31-61-50.ec2.internal>, ctladdr=<root@ip-172-31-61-50.ec2.internal> (0/0), delay=00:00:00$ Dec 28 07:40:01 ip-172-31-61-50 CRON[6717]: (smmsp) CMD (test -x /etc/init.d/sendmail && /usr/share/sendmail/sendmail cron-msp) Dec 28 07:46:31 ip-172-31-61-50 dhclient: DHCPREQUEST of 172.31.61.50 on eth0 to 172.31.48.1 port 67 (xid=0x6bf08516) Dec 28 07:46:31 ip-172-31-61-50 dhclient: DHCPACK of 172.31.61.50 from 172.31.48.1 Dec 28 07:46:31 ip-172-31-61-50 dhclient: bound to 172.31.61.50 -- renewal in 1358 seconds. Dec 28 07:52:18 ip-172-31-61-50 kernel: [10770241.774039] net_ratelimit: 200 callbacks suppressed Dec 28 07:53:50 ip-172-31-61-50 kernel: [10770333.651970] nf_conntrack: table full, dropping packet Dec 28 07:53:50 ip-172-31-61-50 kernel: [10770333.659987] nf_conntrack: table full, dropping packet Dec 28 07:53:50 ip-172-31-61-50 kernel: [10770333.693221] nf_conntrack: table full, dropping packet Dec 28 07:53:50 ip-172-31-61-50 kernel: [10770333.703425] nf_conntrack: table full, dropping packet Dec 28 07:53:55 ip-172-31-61-50 kernel: [10770338.539583] net_ratelimit: 823 callbacks suppressed Dec 28 07:53:55 ip-172-31-61-50 kernel: [10770338.539586] nf_conntrack: table full, dropping packet Dec 28 07:53:55 ip-172-31-61-50 kernel: [10770338.548105] nf_conntrack: table full, dropping packet Dec 28 07:53:55 ip-172-31-61-50 kernel: [10770338.627686] nf_conntrack: table full, dropping packet Dec 28 07:53:55 ip-172-31-61-50 kernel: [10770338.628284] nf_conntrack: table full, dropping packet Dec 28 07:53:55 ip-172-31-61-50 kernel: [10770338.655915] nf_conntrack: table full, dropping packet Dec 28 07:53:55 ip-172-31-61-50 kernel: [10770338.700086] nf_conntrack: table full, dropping packet Dec 28 07:53:56 ip-172-31-61-50 kernel: [10770338.791747] nf_conntrack: table full, dropping packet Dec 28 07:53:56 ip-172-31-61-50 kernel: [10770338.800084] nf_conntrack: table full, dropping packet Dec 28 07:53:56 ip-172-31-61-50 kernel: [10770338.928091] nf_conntrack: table full, dropping packet Dec 28 07:53:56 ip-172-31-61-50 kernel: [10770338.948085] nf_conntrack: table full, dropping packet Dec 28 07:54:00 ip-172-31-61-50 kernel: [10770343.727438] net_ratelimit: 796 callbacks suppressed Dec 28 07:54:00 ip-172-31-61-50 kernel: [10770343.727441] nf_conntrack: table full, dropping packet Dec 28 07:54:01 ip-172-31-61-50 kernel: [10770343.809776] nf_conntrack: table full, dropping packet Dec 28 07:54:01 ip-172-31-61-50 kernel: [10770343.810418] nf_conntrack: table full, dropping packet Dec 28 07:54:01 ip-172-31-61-50 kernel: [10770343.810428] nf_conntrack: table full, dropping packet Dec 28 07:54:01 ip-172-31-61-50 kernel: [10770343.813188] nf_conntrack: table full, dropping packet Dec 28 07:54:01 ip-172-31-61-50 kernel: [10770343.813532] nf_conntrack: table full, dropping packet Dec 28 07:54:01 ip-172-31-61-50 kernel: [10770343.902844] nf_conntrack: table full, dropping packet Dec 28 07:54:01 ip-172-31-61-50 kernel: [10770343.903162] nf_conntrack: table full, dropping packet Dec 28 08:00:01 ip-172-31-61-50 CRON[8270]: (smmsp) CMD (test -x /etc/init.d/sendmail && /usr/share/sendmail/sendmail cron-msp) Dec 28 08:09:01 ip-172-31-61-50 CRON[8291]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -x /usr/lib/php5/sessionclean ] && [ -d /var/lib/php5 ] && /usr/lib/php$ Dec 28 08:09:01 ip-172-31-61-50 CRON[8293]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean) Dec 28 08:09:02 ip-172-31-61-50 sendmail[8363]: vBSA92OH008363: from=root, size=638, class=0, nrcpts=1, msgid=<201712281009.vBSA92OH008363@ip-172-31-61-50.ec2.internal$ Dec 28 08:09:02 ip-172-31-61-50 sm-mta[8364]: vBSA92oE008364: from=<root@ip-172-31-61-50.ec2.internal>, size=954, class=0, nrcpts=1, msgid=<201712281009.vBSA92OH008363$ Dec 28 08:09:02 ip-172-31-61-50 sendmail[8363]: vBSA92OH008363: to=root, ctladdr=root (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=30638, relay=[127.0.0.1$ Dec 28 08:09:02 ip-172-31-61-50 sm-mta[8365]: vBSA92oE008364: to=<root@ip-172-31-61-50.ec2.internal>, ctladdr=<root@ip-172-31-61-50.ec2.internal> (0/0), delay=00:00:00$ Dec 28 08:09:09 ip-172-31-61-50 dhclient: DHCPREQUEST of 172.31.61.50 on eth0 to 172.31.48.1 port 67 (xid=0x6bf08516) Dec 28 08:09:09 ip-172-31-61-50 dhclient: DHCPACK of 172.31.61.50 from 172.31.48.1 Dec 28 08:09:09 ip-172-31-61-50 dhclient: bound to 172.31.61.50 -- renewal in 1370 seconds. Dec 28 08:17:01 ip-172-31-61-50 CRON[8381]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Dec 28 08:31:59 ip-172-31-61-50 dhclient: DHCPREQUEST of 172.31.61.50 on eth0 to 172.31.48.1 port 67 (xid=0x6bf08516) Dec 28 08:31:59 ip-172-31-61-50 dhclient: DHCPACK of 172.31.61.50 from 172.31.48.1 Dec 28 08:31:59 ip-172-31-61-50 dhclient: bound to 172.31.61.50 -- renewal in 1463 seconds. Dec 28 08:39:01 ip-172-31-61-50 CRON[8421]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean) Dec 28 08:39:01 ip-172-31-61-50 sendmail[8492]: vBSAd1VO008492: from=root, size=638, class=0, nrcpts=1, msgid=<201712281039.vBSAd1VO008492@ip-172-31-61-50.ec2.internal$ Dec 28 08:39:01 ip-172-31-61-50 sm-mta[8493]: vBSAd1gm008493: from=<root@ip-172-31-61-50.ec2.internal>, size=954, class=0, nrcpts=1, msgid=<201712281039.vBSAd1VO008492$ Dec 28 08:39:01 ip-172-31-61-50 sendmail[8492]: vBSAd1VO008492: to=root, ctladdr=root (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=30638, relay=[127.0.0.1$ Dec 28 08:39:01 ip-172-31-61-50 sm-mta[8494]: vBSAd1gm008493: to=<root@ip-172-31-61-50.ec2.internal>, ctladdr=<root@ip-172-31-61-50.ec2.internal> (0/0), delay=00:00:00$ Dec 28 08:40:01 ip-172-31-61-50 CRON[8497]: (smmsp) CMD (test -x /etc/init.d/sendmail && /usr/share/sendmail/sendmail cron-msp) Dec 28 08:56:23 ip-172-31-61-50 dhclient: DHCPREQUEST of 172.31.61.50 on eth0 to 172.31.48.1 port 67 (xid=0x6bf08516) Dec 28 08:56:23 ip-172-31-61-50 dhclient: DHCPACK of 172.31.61.50 from 172.31.48.1 Dec 28 08:56:23 ip-172-31-61-50 dhclient: bound to 172.31.61.50 -- renewal in 1367 seconds. Dec 28 09:00:01 ip-172-31-61-50 CRON[8531]: (smmsp) CMD (test -x /etc/init.d/sendmail && /usr/share/sendmail/sendmail cron-msp) Dec 28 09:09:01 ip-172-31-61-50 CRON[8552]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -x /usr/lib/php5/sessionclean ] && [ -d /var/lib/php5 ] && /usr/lib/php$ Dec 28 09:09:01 ip-172-31-61-50 CRON[8553]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean) Dec 28 09:09:01 ip-172-31-61-50 sendmail[8624]: vBSB91L4008624: from=root, size=638, class=0, nrcpts=1, msgid=<201712281109.vBSB91L4008624@ip-172-31-61-50.ec2.internal$ Dec 28 09:09:01 ip-172-31-61-50 sm-mta[8625]: vBSB91Uo008625: from=<root@ip-172-31-61-50.ec2.internal>, size=954, class=0, nrcpts=1, msgid=<201712281109.vBSB91L4008624$ Dec 28 09:09:01 ip-172-31-61-50 sendmail[8624]: vBSB91L4008624: to=root, ctladdr=root (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=30638, relay=[127.0.0.1$ Dec 28 09:09:01 ip-172-31-61-50 sm-mta[8626]: vBSB91Uo008625: to=<root@ip-172-31-61-50.ec2.internal>, ctladdr=<root@ip-172-31-61-50.ec2.internal> (0/0), delay=00:00:00$ Dec 28 09:17:01 ip-172-31-61-50 CRON[8636]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Dec 28 09:19:11 ip-172-31-61-50 dhclient: DHCPREQUEST of 172.31.61.50 on eth0 to 172.31.48.1 port 67 (xid=0x6bf08516) Dec 28 09:19:11 ip-172-31-61-50 dhclient: DHCPACK of 172.31.61.50 from 172.31.48.1 Dec 28 09:19:11 ip-172-31-61-50 dhclient: bound to 172.31.61.50 -- renewal in 1689 seconds. Dec 28 09:20:01 ip-172-31-61-50 CRON[8653]: (smmsp) CMD (test -x /etc/init.d/sendmail && /usr/share/sendmail/sendmail cron-msp) Dec 28 09:33:37 ip-172-31-61-50 kernel: [10776319.829595] type=1400 audit(1514460817.047:38): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="$ Dec 28 09:33:39 ip-172-31-61-50 /etc/mysql/debian-start[8917]: Upgrading MySQL tables if necessary. Dec 28 09:33:39 ip-172-31-61-50 /etc/mysql/debian-start[8921]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Dec 28 09:33:39 ip-172-31-61-50 /etc/mysql/debian-start[8921]: Looking for 'mysql' as: /usr/bin/mysql Dec 28 09:33:39 ip-172-31-61-50 /etc/mysql/debian-start[8921]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Dec 28 09:33:39 ip-172-31-61-50 /etc/mysql/debian-start[8921]: This installation of MySQL is already upgraded to 5.5.53, use --force if you still need to run mysql_upg$ Dec 28 09:33:39 ip-172-31-61-50 /etc/mysql/debian-start[8932]: Checking for insecure root accounts. Dec 28 09:33:39 ip-172-31-61-50 /etc/mysql/debian-start[8937]: Triggering myisam-recover for all MyISAM tables Dec 28 09:39:01 ip-172-31-61-50 sendmail[9106]: vBSBd19u009106: from=root, size=638, class=0, nrcpts=1, msgid=<201712281139.vBSBd19u009106@ip-172-31-61-50.ec2.internal$ Dec 28 09:39:01 ip-172-31-61-50 sm-mta[9107]: vBSBd1qH009107: from=<root@ip-172-31-61-50.ec2.internal>, size=954, class=0, nrcpts=1, msgid=<201712281139.vBSBd19u009106$ Dec 28 09:39:01 ip-172-31-61-50 sendmail[9106]: vBSBd19u009106: to=root, ctladdr=root (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=30638, relay=[127.0.0.1$ Dec 28 09:39:01 ip-172-31-61-50 sm-mta[9108]: vBSBd1qH009107: to=<root@ip-172-31-61-50.ec2.internal>, ctladdr=<root@ip-172-31-61-50.ec2.internal> (0/0), delay=00:00:00$ Dec 28 09:40:01 ip-172-31-61-50 CRON[9111]: (smmsp) CMD (test -x /etc/init.d/sendmail && /usr/share/sendmail/sendmail cron-msp) Dec 28 09:47:20 ip-172-31-61-50 dhclient: DHCPREQUEST of 172.31.61.50 on eth0 to 172.31.48.1 port 67 (xid=0x6bf08516) Dec 28 09:47:20 ip-172-31-61-50 dhclient: DHCPACK of 172.31.61.50 from 172.31.48.1 Dec 28 09:47:20 ip-172-31-61-50 dhclient: bound to 172.31.61.50 -- renewal in 1443 seconds. Someone can help me please?
