지역 사회 배우다 도구 라이브러리 여가
찾다
한국어
mysql服务无法启动1067错误，谁知道正确的解决方法？
PHP中文网
PHP中文网 2017-04-17 14:45:21
0
1
1947

必须手动删除上面三个文件后才能启动服务：

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 functions
2016-04-29T03:14:39.291382Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T03:14:39.293384Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T03:14:39.294883Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T03:14:39.295384Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T03:14:39.295384Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T03:14:39.474057Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T03:14:39.496191Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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.html
2016-04-29T03:14:39.750717Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T03:15:04.268994Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T03:15:04.269997Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T03:15:04.269997Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T03:15:04.269997Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T03:15:04.269997Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T03:15:04.385464Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T03:15:04.416863Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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 MB
2016-04-29T03:15:06.571837Z 0 [Note] InnoDB: Setting log file .ib_logfile1 size to 48 MB
2016-04-29T03:15:07.750690Z 0 [Note] InnoDB: Renaming log file .ib_logfile101 to .ib_logfile0
2016-04-29T03:15:07.750690Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-04-29T03:15:07.750690Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-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 new
2016-04-29T03:15:09.093534Z 0 [Note] InnoDB: Doublewrite buffer created
2016-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 created
2016-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 created
2016-04-29T03:15:09.193811Z 0 [Note] InnoDB: Waiting for purge to start
2016-04-29T03:15:09.262564Z 0 [Note] InnoDB: 5.7.12 started; log sequence number 0
2016-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 exist
2016-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 exist
2016-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 key
2016-04-29T03:15:09.315954Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-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 them
2016-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 exist
2016-04-29T03:15:09.478728Z 0 [Note] Event Scheduler: Loaded 0 events
2016-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 gracefully
2016-04-29T03:25:56.020988Z 0 [Note] Shutting down slave threads
2016-04-29T03:25:56.036614Z 0 [Note] Forcefully disconnecting 0 remaining clients
2016-04-29T03:25:56.036614Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2016-04-29T03:25:56.036614Z 0 [Note] Binlog end
2016-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_pool
2016-04-29T03:25:56.521018Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160429 11:25:56
2016-04-29T03:25:57.552330Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209970
2016-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 functions
2016-04-29T03:26:27.863913Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T03:26:27.863913Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T03:26:27.863913Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T03:26:27.879538Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T03:26:27.879538Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T03:26:28.098287Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T03:26:28.145163Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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.html
2016-04-29T03:26:28.348286Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T03:32:07.711575Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T03:32:07.874214Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T03:32:07.911974Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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.html
2016-04-29T03:32:08.042849Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T03:33:14.162003Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T03:33:14.162003Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T03:33:14.162003Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T03:33:14.177626Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T03:33:14.177626Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T03:33:14.293525Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T03:33:14.324776Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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.html
2016-04-29T03:33:14.393440Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T03:36:37.761282Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T03:36:37.932672Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T03:36:37.979548Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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.html
2016-04-29T03:36:38.102620Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T03:45:46.415920Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T03:45:46.415920Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T03:45:46.447170Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T03:45:46.525301Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T03:45:46.540926Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T03:45:46.712813Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T03:45:46.759690Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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.html
2016-04-29T03:45:46.869071Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T03:46:37.292891Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T03:46:37.292891Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T03:46:37.292891Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T03:46:37.308704Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T03:46:37.308704Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T03:46:37.464779Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T03:46:37.496031Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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.html
2016-04-29T03:46:37.605412Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T04:05:42.113227Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T04:05:42.113227Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T04:05:42.113227Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T04:05:42.113227Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T04:05:42.128852Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T04:05:42.282522Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T04:05:42.313994Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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.html
2016-04-29T04:05:42.513202Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T04:20:55.465018Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T04:20:55.480644Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T04:20:55.480644Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T04:20:55.480644Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T04:20:55.480644Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T04:20:55.637568Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T04:20:55.665197Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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.html
2016-04-29T04:20:55.781097Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T04:21:10.030332Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T04:21:10.030332Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T04:21:10.045958Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T04:21:10.045958Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T04:21:10.045958Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T04:21:10.145977Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T04:21:10.177228Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-04-29T04:21:10.261376Z 0 [Note] InnoDB: Setting log file .ib_logfile101 size to 48 MB
2016-04-29T04:21:11.533828Z 0 [Note] InnoDB: Setting log file .ib_logfile1 size to 48 MB
2016-04-29T04:21:14.459162Z 0 [Note] InnoDB: Renaming log file .ib_logfile101 to .ib_logfile0
2016-04-29T04:21:14.474788Z 0 [Warning] InnoDB: New log files created, LSN=1209970
2016-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.html
2016-04-29T04:21:14.506041Z 0 [ERROR] InnoDB: File .ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
2016-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 functions
2016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Uses event mutexes
2016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Memory barrier is not used
2016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Number of pools: 1
2016-04-29T04:21:28.209377Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-29T04:21:28.325483Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-29T04:21:28.347116Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-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 MB
2016-04-29T04:21:30.862269Z 0 [Note] InnoDB: Setting log file .ib_logfile1 size to 48 MB
2016-04-29T04:21:32.859234Z 0 [Note] InnoDB: Renaming log file .ib_logfile101 to .ib_logfile0
2016-04-29T04:21:32.859234Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-04-29T04:21:32.874867Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-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 new
2016-04-29T04:21:33.683087Z 0 [Note] InnoDB: Doublewrite buffer created
2016-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 created
2016-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 created
2016-04-29T04:21:33.814126Z 0 [Note] InnoDB: Waiting for purge to start
2016-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 0
2016-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 exist
2016-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 exist
2016-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 key
2016-04-29T04:21:33.983230Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-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 them
2016-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 exist
2016-04-29T04:21:36.533410Z 0 [Note] Event Scheduler: Loaded 0 events
2016-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)

请输入代码
PHP中文网
PHP中文网

认证0级讲师

모든 응답(1)
大家讲道理
大家讲道理2017-04-17 14:47:21 1층 
open your my.ini configuration file
under innodb_lock_wait_timeout = 50 add: innodb_flush_method=normal
restart MySql
….enjoy!
좋다 +0
답글 추가
인기 주제
더>
인기 기사
인기 튜토리얼
더>
관련 튜토리얼
인기 추천
최신 강좌
최신 다운로드
더>
웹 효과
웹사이트 소스 코드
웹사이트 자료
프론트엔드 템플릿