I am using MySql 5.7. I am facing issue with MySql server shutdown itself. Once, I check the MySql Log file I found below error.
2018-08-09T15:05:55.118464Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-09T15:05:55.120874Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.18.04.1) starting as process 31128 ...
2018-08-09T15:05:55.127016Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-08-09T15:05:55.127069Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-08-09T15:05:55.127082Z 0 [Note] InnoDB: Uses event mutexes
2018-08-09T15:05:55.127094Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-08-09T15:05:55.127105Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-08-09T15:05:55.127116Z 0 [Note] InnoDB: Using Linux native AIO
2018-08-09T15:05:55.127523Z 0 [Note] InnoDB: Number of pools: 1
2018-08-09T15:05:55.127684Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-08-09T15:05:55.130790Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2018-08-09T15:05:55.190464Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-08-09T15:05:55.200659Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-08-09T15:05:55.222440Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-08-09T15:05:55.357873Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-08-09T15:05:55.358008Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-08-09T15:05:55.397928Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-08-09T15:05:55.399686Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-08-09T15:05:55.399715Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-08-09T15:05:55.400305Z 0 [Note] InnoDB: Waiting for purge to start
2018-08-09T15:05:55.451161Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 8738970
2018-08-09T15:05:55.451681Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-08-09T15:05:55.451778Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-08-09T15:05:55.453227Z 0 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to
http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
mysqld: Table 'mysql.plugin' doesn't exist
2018-08-09T15:05:55.453289Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-08-09T15:05:55.454227Z 0 [Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to
http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
mysqld: Table 'mysql.gtid_executed' doesn't exist
2018-08-09T15:05:55.454270Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-08-09T15:05:55.454384Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-08-09T15:05:55.454404Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-08-09T15:05:55.454466Z 0 [Note] IPv6 is available.
2018-08-09T15:05:55.454481Z 0 [Note] - '::' resolves to '::';
2018-08-09T15:05:55.454515Z 0 [Note] Server socket created on IP: '::'.
2018-08-09T15:05:55.454899Z 0 [Warning] InnoDB: Cannot open table mysql/server_cost from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to
http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2018-08-09T15:05:55.454930Z 0 [Warning] Failed to open optimizer cost constant tables
2018-08-09T15:05:55.456753Z 0 [Warning] InnoDB: Cannot open table mysql/time_zone_leap_second from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to
http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2018-08-09T15:05:55.456794Z 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2018-08-09T15:05:55.458413Z 0 [Warning] InnoDB: Cannot open table mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to
http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2018-08-09T15:05:55.458441Z 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2018-08-09T15:05:55.469877Z 0 [Note] Event Scheduler: Loaded 0 events
2018-08-09T15:05:55.470255Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.23-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2018-08-09T15:05:55.495739Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180809 15:05:55
2018-08-09T15:06:04.247214Z 2 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
why server shutdown itself? I have tried the increase the innodb_buffer_pool_size to 4GB. But still I am facing same issue.
Can anyone has idea how to resolve this issue.
Thanks
Nikunj Kansara