MySQL Forums
Forum List  »  InnoDB

MySql Shutdown itself
Posted by: NIKUNJ KANSARA
Date: August 09, 2018 11:55AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySql Shutdown itself
124
August 09, 2018 11:55AM
39
August 09, 2018 01:02PM
40
August 09, 2018 02:11PM
40
August 09, 2018 03:36PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.