問題描述

必須手動(dòng)刪除上面三個(gè)文件后才能啟動(dòng)服務(wù)：

2016-04-29T03:14:39.211523Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T03:14:39.211523Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T03:14:39.211523Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T03:14:39.211523Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T03:14:39.211523Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 3640 ...2016-04-29T03:14:39.273995Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T03:14:39.291382Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T03:14:39.293384Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T03:14:39.294883Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T03:14:39.295384Z 0 [Note] InnoDB: Number of pools: 12016-04-29T03:14:39.295384Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T03:14:39.474057Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T03:14:39.496191Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T03:14:39.735095Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T03:14:39.750717Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T03:14:39.750717Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T03:14:39.750717Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T03:14:39.750717Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T03:15:04.216798Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T03:15:04.216798Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T03:15:04.216798Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T03:15:04.216798Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T03:15:04.216798Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 1516 ...2016-04-29T03:15:04.266493Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T03:15:04.268994Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T03:15:04.269997Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T03:15:04.269997Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T03:15:04.269997Z 0 [Note] InnoDB: Number of pools: 12016-04-29T03:15:04.269997Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T03:15:04.385464Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T03:15:04.416863Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T03:15:04.447967Z 0 [Note] InnoDB: The first innodb_system data file ’ibdata1’ did not exist. A new tablespace will be created!2016-04-29T03:15:04.447967Z 0 [Note] InnoDB: Setting file ’.ibdata1’ size to 12 MB. Physically writing the file full; Please wait ...2016-04-29T03:15:04.733715Z 0 [Note] InnoDB: File ’.ibdata1’ size is now 12 MB.2016-04-29T03:15:04.818559Z 0 [Note] InnoDB: Setting log file .ib_logfile101 size to 48 MB2016-04-29T03:15:06.571837Z 0 [Note] InnoDB: Setting log file .ib_logfile1 size to 48 MB2016-04-29T03:15:07.750690Z 0 [Note] InnoDB: Renaming log file .ib_logfile101 to .ib_logfile02016-04-29T03:15:07.750690Z 0 [Warning] InnoDB: New log files created, LSN=457902016-04-29T03:15:07.750690Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables2016-04-29T03:15:07.750690Z 0 [Note] InnoDB: Setting file ’.ibtmp1’ size to 12 MB. Physically writing the file full; Please wait ...2016-04-29T03:15:08.977632Z 0 [Note] InnoDB: File ’.ibtmp1’ size is now 12 MB.2016-04-29T03:15:08.993256Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new2016-04-29T03:15:09.093534Z 0 [Note] InnoDB: Doublewrite buffer created2016-04-29T03:15:09.115680Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.2016-04-29T03:15:09.115680Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.2016-04-29T03:15:09.131308Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2016-04-29T03:15:09.178186Z 0 [Note] InnoDB: Foreign key constraint system tables created2016-04-29T03:15:09.178186Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.2016-04-29T03:15:09.193811Z 0 [Note] InnoDB: Tablespace and datafile system tables created.2016-04-29T03:15:09.193811Z 0 [Note] InnoDB: Creating sys_virtual system tables.2016-04-29T03:15:09.193811Z 0 [Note] InnoDB: sys_virtual table created2016-04-29T03:15:09.193811Z 0 [Note] InnoDB: Waiting for purge to start2016-04-29T03:15:09.262564Z 0 [Note] InnoDB: 5.7.12 started; log sequence number 02016-04-29T03:15:09.262564Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4846ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)2016-04-29T03:15:09.262564Z 0 [Note] Plugin ’FEDERATED’ is disabled.2016-04-29T03:15:09.262564Z 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 exist2016-04-29T03:15:09.278189Z 0 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.2016-04-29T03:15:09.278189Z 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 exist2016-04-29T03:15:09.278189Z 0 [Warning] Gtid table is not ready to be used. Table ’mysql.gtid_executed’ cannot be opened.2016-04-29T03:15:09.293817Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key2016-04-29T03:15:09.315954Z 0 [Note] Server hostname (bind-address): ’*’; port: 33062016-04-29T03:15:09.315954Z 0 [Note] IPv6 is available.2016-04-29T03:15:09.315954Z 0 [Note] - ’::’ resolves to ’::’;2016-04-29T03:15:09.315954Z 0 [Note] Server socket created on IP: ’::’.2016-04-29T03:15:09.331581Z 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.2016-04-29T03:15:09.331581Z 0 [Warning] Failed to open optimizer cost constant tables

2016-04-29T03:15:09.413218Z 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.2016-04-29T03:15:09.416218Z 0 [Warning] Can’t open and lock time zone table: Table ’mysql.time_zone_leap_second’ doesn’t exist trying to live without them2016-04-29T03:15:09.416218Z 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.2016-04-29T03:15:09.431851Z 0 [ERROR] Can’t open and lock privilege tables: Table ’mysql.servers’ doesn’t exist2016-04-29T03:15:09.478728Z 0 [Note] Event Scheduler: Loaded 0 events2016-04-29T03:15:09.494354Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld: ready for connections.Version: ’5.7.12’ socket: ’’ port: 3306 MySQL Community Server (GPL)2016-04-29T03:25:56.020988Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld: Normal shutdown

2016-04-29T03:25:56.020988Z 0 [Note] Giving 0 client threads a chance to die gracefully2016-04-29T03:25:56.020988Z 0 [Note] Shutting down slave threads2016-04-29T03:25:56.036614Z 0 [Note] Forcefully disconnecting 0 remaining clients2016-04-29T03:25:56.036614Z 0 [Note] Event Scheduler: Purging the queue. 0 events2016-04-29T03:25:56.036614Z 0 [Note] Binlog end2016-04-29T03:25:56.192875Z 0 [Note] Shutting down plugin ’ngram’2016-04-29T03:25:56.192875Z 0 [Note] Shutting down plugin ’partition’2016-04-29T03:25:56.192875Z 0 [Note] Shutting down plugin ’BLACKHOLE’2016-04-29T03:25:56.192875Z 0 [Note] Shutting down plugin ’ARCHIVE’2016-04-29T03:25:56.192875Z 0 [Note] Shutting down plugin ’PERFORMANCE_SCHEMA’2016-04-29T03:25:56.192875Z 0 [Note] Shutting down plugin ’MRG_MYISAM’2016-04-29T03:25:56.208500Z 0 [Note] Shutting down plugin ’MyISAM’2016-04-29T03:25:56.208500Z 0 [Note] Shutting down plugin ’INNODB_SYS_VIRTUAL’2016-04-29T03:25:56.208500Z 0 [Note] Shutting down plugin ’INNODB_SYS_DATAFILES’2016-04-29T03:25:56.224126Z 0 [Note] Shutting down plugin ’INNODB_SYS_TABLESPACES’2016-04-29T03:25:56.224126Z 0 [Note] Shutting down plugin ’INNODB_SYS_FOREIGN_COLS’2016-04-29T03:25:56.224126Z 0 [Note] Shutting down plugin ’INNODB_SYS_FOREIGN’2016-04-29T03:25:56.239751Z 0 [Note] Shutting down plugin ’INNODB_SYS_FIELDS’2016-04-29T03:25:56.239751Z 0 [Note] Shutting down plugin ’INNODB_SYS_COLUMNS’2016-04-29T03:25:56.239751Z 0 [Note] Shutting down plugin ’INNODB_SYS_INDEXES’2016-04-29T03:25:56.239751Z 0 [Note] Shutting down plugin ’INNODB_SYS_TABLESTATS’2016-04-29T03:25:56.255377Z 0 [Note] Shutting down plugin ’INNODB_SYS_TABLES’2016-04-29T03:25:56.255377Z 0 [Note] Shutting down plugin ’INNODB_FT_INDEX_TABLE’2016-04-29T03:25:56.255377Z 0 [Note] Shutting down plugin ’INNODB_FT_INDEX_CACHE’2016-04-29T03:25:56.271002Z 0 [Note] Shutting down plugin ’INNODB_FT_CONFIG’2016-04-29T03:25:56.271002Z 0 [Note] Shutting down plugin ’INNODB_FT_BEING_DELETED’2016-04-29T03:25:56.271002Z 0 [Note] Shutting down plugin ’INNODB_FT_DELETED’2016-04-29T03:25:56.271002Z 0 [Note] Shutting down plugin ’INNODB_FT_DEFAULT_STOPWORD’2016-04-29T03:25:56.286629Z 0 [Note] Shutting down plugin ’INNODB_METRICS’2016-04-29T03:25:56.286629Z 0 [Note] Shutting down plugin ’INNODB_TEMP_TABLE_INFO’2016-04-29T03:25:56.286629Z 0 [Note] Shutting down plugin ’INNODB_BUFFER_POOL_STATS’2016-04-29T03:25:56.302256Z 0 [Note] Shutting down plugin ’INNODB_BUFFER_PAGE_LRU’2016-04-29T03:25:56.302256Z 0 [Note] Shutting down plugin ’INNODB_BUFFER_PAGE’2016-04-29T03:25:56.302256Z 0 [Note] Shutting down plugin ’INNODB_CMP_PER_INDEX_RESET’2016-04-29T03:25:56.302256Z 0 [Note] Shutting down plugin ’INNODB_CMP_PER_INDEX’2016-04-29T03:25:56.317880Z 0 [Note] Shutting down plugin ’INNODB_CMPMEM_RESET’2016-04-29T03:25:56.317880Z 0 [Note] Shutting down plugin ’INNODB_CMPMEM’2016-04-29T03:25:56.317880Z 0 [Note] Shutting down plugin ’INNODB_CMP_RESET’2016-04-29T03:25:56.333506Z 0 [Note] Shutting down plugin ’INNODB_CMP’2016-04-29T03:25:56.349133Z 0 [Note] Shutting down plugin ’INNODB_LOCK_WAITS’2016-04-29T03:25:56.349133Z 0 [Note] Shutting down plugin ’INNODB_LOCKS’2016-04-29T03:25:56.349133Z 0 [Note] Shutting down plugin ’INNODB_TRX’2016-04-29T03:25:56.349133Z 0 [Note] Shutting down plugin ’InnoDB’2016-04-29T03:25:56.380382Z 0 [Note] InnoDB: FTS optimize thread exiting.2016-04-29T03:25:56.380382Z 0 [Note] InnoDB: Starting shutdown...2016-04-29T03:25:56.505392Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:mysqlmysql-5.7.12-win32dataib_buffer_pool2016-04-29T03:25:56.521018Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160429 11:25:562016-04-29T03:25:57.552330Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12099702016-04-29T03:25:57.552330Z 0 [Note] InnoDB: Removed temporary tablespace data file: 'ibtmp1'2016-04-29T03:25:57.552330Z 0 [Note] Shutting down plugin ’MEMORY’2016-04-29T03:25:57.552330Z 0 [Note] Shutting down plugin ’CSV’2016-04-29T03:25:57.567957Z 0 [Note] Shutting down plugin ’sha256_password’2016-04-29T03:25:57.567957Z 0 [Note] Shutting down plugin ’mysql_native_password’2016-04-29T03:25:57.567957Z 0 [Note] Shutting down plugin ’binlog’2016-04-29T03:25:57.567957Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld: Shutdown complete

2016-04-29T03:26:27.676414Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T03:26:27.676414Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T03:26:27.676414Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T03:26:27.676414Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T03:26:27.676414Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 2852 ...2016-04-29T03:26:27.832663Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T03:26:27.863913Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T03:26:27.863913Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T03:26:27.863913Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T03:26:27.879538Z 0 [Note] InnoDB: Number of pools: 12016-04-29T03:26:27.879538Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T03:26:28.098287Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T03:26:28.145163Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T03:26:28.317037Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T03:26:28.332662Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T03:26:28.348286Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T03:26:28.348286Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T03:26:28.348286Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T03:32:07.611309Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T03:32:07.611309Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T03:32:07.611309Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T03:32:07.611309Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T03:32:07.611309Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 4436 ...2016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Number of pools: 12016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T03:32:07.874214Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T03:32:07.911974Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T03:32:08.027382Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T03:32:08.042849Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T03:32:08.042849Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T03:32:08.042849Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T03:32:08.042849Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T03:33:14.124636Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T03:33:14.124636Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T03:33:14.124636Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T03:33:14.124636Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T03:33:14.124636Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 7772 ...2016-04-29T03:33:14.162003Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T03:33:14.162003Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T03:33:14.162003Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T03:33:14.162003Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T03:33:14.177626Z 0 [Note] InnoDB: Number of pools: 12016-04-29T03:33:14.177626Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T03:33:14.293525Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T03:33:14.324776Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T03:33:14.393440Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T03:33:14.393440Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T03:33:14.393440Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T03:33:14.393440Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T03:33:14.393440Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T03:36:37.725411Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T03:36:37.725411Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T03:36:37.725411Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T03:36:37.725411Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T03:36:37.725411Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 888 ...2016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Number of pools: 12016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T03:36:37.932672Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T03:36:37.979548Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T03:36:38.080479Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T03:36:38.096107Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T03:36:38.100116Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T03:36:38.102620Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T03:36:38.102620Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T03:45:46.197156Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T03:45:46.197156Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T03:45:46.197156Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T03:45:46.197156Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T03:45:46.197156Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 2716 ...2016-04-29T03:45:46.415920Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T03:45:46.415920Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T03:45:46.415920Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T03:45:46.447170Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T03:45:46.525301Z 0 [Note] InnoDB: Number of pools: 12016-04-29T03:45:46.540926Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T03:45:46.712813Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T03:45:46.759690Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T03:45:46.837821Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T03:45:46.853445Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T03:45:46.869071Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T03:45:46.869071Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T03:45:46.869071Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T03:46:37.214763Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T03:46:37.214763Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T03:46:37.214763Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T03:46:37.214763Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T03:46:37.214763Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 6268 ...2016-04-29T03:46:37.292891Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T03:46:37.292891Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T03:46:37.292891Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T03:46:37.292891Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T03:46:37.308704Z 0 [Note] InnoDB: Number of pools: 12016-04-29T03:46:37.308704Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T03:46:37.464779Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T03:46:37.496031Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T03:46:37.605412Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T03:46:37.605412Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T03:46:37.605412Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T03:46:37.605412Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T03:46:37.621038Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T04:05:42.081975Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T04:05:42.081975Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T04:05:42.081975Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T04:05:42.081975Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T04:05:42.081975Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 7676 ...2016-04-29T04:05:42.113227Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T04:05:42.113227Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T04:05:42.113227Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T04:05:42.113227Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T04:05:42.113227Z 0 [Note] InnoDB: Number of pools: 12016-04-29T04:05:42.128852Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T04:05:42.282522Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T04:05:42.313994Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T04:05:42.497577Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T04:05:42.497577Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T04:05:42.497577Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T04:05:42.513202Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T04:05:42.513202Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T04:20:55.427256Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T04:20:55.427256Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T04:20:55.427256Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T04:20:55.427256Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T04:20:55.427256Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 6388 ...2016-04-29T04:20:55.465018Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T04:20:55.465018Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T04:20:55.480644Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T04:20:55.480644Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T04:20:55.480644Z 0 [Note] InnoDB: Number of pools: 12016-04-29T04:20:55.480644Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T04:20:55.637568Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T04:20:55.665197Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T04:20:55.765464Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T04:20:55.781097Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T04:20:55.781097Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T04:20:55.781097Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T04:20:55.781097Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T04:21:09.992446Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T04:21:09.992446Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T04:21:09.992446Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T04:21:09.992446Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T04:21:09.992446Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 2596 ...2016-04-29T04:21:10.030332Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T04:21:10.030332Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T04:21:10.030332Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T04:21:10.045958Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T04:21:10.045958Z 0 [Note] InnoDB: Number of pools: 12016-04-29T04:21:10.045958Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T04:21:10.145977Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T04:21:10.177228Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T04:21:10.261376Z 0 [Note] InnoDB: Setting log file .ib_logfile101 size to 48 MB2016-04-29T04:21:11.533828Z 0 [Note] InnoDB: Setting log file .ib_logfile1 size to 48 MB2016-04-29T04:21:14.459162Z 0 [Note] InnoDB: Renaming log file .ib_logfile101 to .ib_logfile02016-04-29T04:21:14.474788Z 0 [Warning] InnoDB: New log files created, LSN=12099702016-04-29T04:21:14.474788Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2016-04-29T04:21:14.490413Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.2016-04-29T04:21:14.490413Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html2016-04-29T04:21:14.506041Z 0 [ERROR] InnoDB: File .ib_logfile0: ’aio read’ returned OS error 187. Cannot continue operation2016-04-29T04:21:14.506041Z 0 [ERROR] InnoDB: Cannot continue operation.2016-04-29T04:21:28.162500Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-04-29T04:21:28.162500Z 0 [Warning] ’NO_ZERO_DATE’, ’NO_ZERO_IN_DATE’ and ’ERROR_FOR_pISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2016-04-29T04:21:28.162500Z 0 [Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.2016-04-29T04:21:28.162500Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.2016-04-29T04:21:28.178125Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld (mysqld 5.7.12) starting as process 6436 ...2016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Uses event mutexes2016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Memory barrier is not used2016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.32016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Number of pools: 12016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Not using CPU crc32 instructions2016-04-29T04:21:28.325483Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2016-04-29T04:21:28.347116Z 0 [Note] InnoDB: Completed initialization of buffer pool2016-04-29T04:21:28.378553Z 0 [Note] InnoDB: The first innodb_system data file ’ibdata1’ did not exist. A new tablespace will be created!2016-04-29T04:21:28.378553Z 0 [Note] InnoDB: Setting file ’.ibdata1’ size to 12 MB. Physically writing the file full; Please wait ...2016-04-29T04:21:28.938487Z 0 [Note] InnoDB: File ’.ibdata1’ size is now 12 MB.2016-04-29T04:21:29.038883Z 0 [Note] InnoDB: Setting log file .ib_logfile101 size to 48 MB2016-04-29T04:21:30.862269Z 0 [Note] InnoDB: Setting log file .ib_logfile1 size to 48 MB2016-04-29T04:21:32.859234Z 0 [Note] InnoDB: Renaming log file .ib_logfile101 to .ib_logfile02016-04-29T04:21:32.859234Z 0 [Warning] InnoDB: New log files created, LSN=457902016-04-29T04:21:32.874867Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables2016-04-29T04:21:32.874867Z 0 [Note] InnoDB: Setting file ’.ibtmp1’ size to 12 MB. Physically writing the file full; Please wait ...2016-04-29T04:21:33.190789Z 0 [Note] InnoDB: File ’.ibtmp1’ size is now 12 MB.2016-04-29T04:21:33.237669Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new2016-04-29T04:21:33.683087Z 0 [Note] InnoDB: Doublewrite buffer created2016-04-29T04:21:33.729964Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.2016-04-29T04:21:33.745590Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.2016-04-29T04:21:33.745590Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2016-04-29T04:21:33.798500Z 0 [Note] InnoDB: Foreign key constraint system tables created2016-04-29T04:21:33.798500Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.2016-04-29T04:21:33.798500Z 0 [Note] InnoDB: Tablespace and datafile system tables created.2016-04-29T04:21:33.798500Z 0 [Note] InnoDB: Creating sys_virtual system tables.2016-04-29T04:21:33.814126Z 0 [Note] InnoDB: sys_virtual table created2016-04-29T04:21:33.814126Z 0 [Note] InnoDB: Waiting for purge to start2016-04-29T04:21:33.883144Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5536ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)2016-04-29T04:21:33.883144Z 0 [Note] InnoDB: 5.7.12 started; log sequence number 02016-04-29T04:21:33.883144Z 0 [Note] Plugin ’FEDERATED’ is disabled.2016-04-29T04:21:33.914396Z 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 exist2016-04-29T04:21:33.930022Z 0 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.2016-04-29T04:21:33.967282Z 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 exist2016-04-29T04:21:33.967282Z 0 [Warning] Gtid table is not ready to be used. Table ’mysql.gtid_executed’ cannot be opened.2016-04-29T04:21:33.967282Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key2016-04-29T04:21:33.983230Z 0 [Note] Server hostname (bind-address): ’*’; port: 33062016-04-29T04:21:33.983230Z 0 [Note] IPv6 is available.2016-04-29T04:21:33.983230Z 0 [Note] - ’::’ resolves to ’::’;2016-04-29T04:21:33.983230Z 0 [Note] Server socket created on IP: ’::’.2016-04-29T04:21:34.014483Z 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.2016-04-29T04:21:34.014483Z 0 [Warning] Failed to open optimizer cost constant tables

2016-04-29T04:21:34.262246Z 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.2016-04-29T04:21:34.267247Z 0 [Warning] Can’t open and lock time zone table: Table ’mysql.time_zone_leap_second’ doesn’t exist trying to live without them2016-04-29T04:21:34.345412Z 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.2016-04-29T04:21:34.345412Z 0 [ERROR] Can’t open and lock privilege tables: Table ’mysql.servers’ doesn’t exist2016-04-29T04:21:36.533410Z 0 [Note] Event Scheduler: Loaded 0 events2016-04-29T04:21:36.533410Z 0 [Note] C:mysqlmysql-5.7.12-win32binmysqld: ready for connections.Version: ’5.7.12’ socket: ’’ port: 3306 MySQL Community Server (GPL)

請輸入代碼

問題解答

open your my.ini configuration fileunder innodb_lock_wait_timeout = 50 add: innodb_flush_method=normalrestart MySql….enjoy!