windows下mysql-5.7.22-winx64突然启动不了,报错Could not open log file

原创 2019-08-25 19:13 阅读(1634)次

windows下mysql-5.7.22-winx64突然启动不了,感觉启动几秒钟后就自己关闭了,看了下启动日志:

2019-08-25T10:57:08.389404Z 0 [Warning] option 'wait_timeout': unsigned value 31536000 adjusted to 2147483
2019-08-25T10:57:08.389459Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-08-25T10:57:08.389478Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2019-08-25T10:57:08.389481Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2019-08-25T10:57:08.389501Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2019-08-25T10:57:08.390232Z 0 [Note] mysqld.exe (mysqld 5.7.22-log) starting as process 320 ...
2019-08-25T10:57:08.530990Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-25T10:57:08.531628Z 0 [Note] InnoDB: Uses event mutexes
2019-08-25T10:57:08.532009Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-08-25T10:57:08.532526Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-08-25T10:57:08.534128Z 0 [Note] InnoDB: Number of pools: 1
2019-08-25T10:57:08.534711Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2019-08-25T10:57:08.538911Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-08-25T10:57:08.545756Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-25T10:57:08.734599Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-08-25T10:57:10.619901Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-25T10:57:10.620953Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-25T10:57:10.789058Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2019-08-25T10:57:10.792190Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-08-25T10:57:10.792835Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-08-25T10:57:10.793873Z 0 [Note] InnoDB: Waiting for purge to start
2019-08-25T10:57:10.859530Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 602744911
2019-08-25T10:57:10.860725Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\myTools\mysql-5.7.22-winx64\data\ib_buffer_pool
2019-08-25T10:57:10.860891Z 0 [Note] Plugin 'FEDERATED' is disabled.
2019-08-25T10:57:10.954845Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190825 18:57:10
mysqld: File '2019-08-25T10:35:51.589934Z 0 [ERROR] Aborting' not found (Errcode: 13 - Permission denied)
2019-08-25T10:57:10.957735Z 0 [ERROR] Failed to open log (file '2019-08-25T10:35:51.589934Z 0 [ERROR] Aborting', errno 13)
2019-08-25T10:57:10.958291Z 0 [ERROR] Could not open log file
2019-08-25T10:57:10.958712Z 0 [ERROR] Can't init tc log
2019-08-25T10:57:10.959075Z 0 [ERROR] Aborting



2019-08-25T10:57:10.959422Z 0 [Note] Binlog end
2019-08-25T10:57:10.959832Z 0 [Note] Shutting down plugin 'ngram'
2019-08-25T10:57:10.960212Z 0 [Note] Shutting down plugin 'partition'
2019-08-25T10:57:10.960698Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2019-08-25T10:57:10.961494Z 0 [Note] Shutting down plugin 'ARCHIVE'
2019-08-25T10:57:10.962015Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2019-08-25T10:57:10.962476Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2019-08-25T10:57:10.962882Z 0 [Note] Shutting down plugin 'MyISAM'
2019-08-25T10:57:10.963274Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2019-08-25T10:57:10.963767Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2019-08-25T10:57:10.964181Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2019-08-25T10:57:10.964666Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2019-08-25T10:57:10.965071Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2019-08-25T10:57:10.965489Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2019-08-25T10:57:10.965868Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2019-08-25T10:57:10.966281Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2019-08-25T10:57:10.966669Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2019-08-25T10:57:10.967091Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2019-08-25T10:57:10.967463Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2019-08-25T10:57:10.967895Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2019-08-25T10:57:10.968304Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2019-08-25T10:57:10.968684Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2019-08-25T10:57:10.969119Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2019-08-25T10:57:10.970031Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2019-08-25T10:57:10.970487Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2019-08-25T10:57:10.970909Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2019-08-25T10:57:10.971326Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2019-08-25T10:57:10.971776Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2019-08-25T10:57:10.972218Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2019-08-25T10:57:10.972656Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2019-08-25T10:57:10.973125Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2019-08-25T10:57:10.973577Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2019-08-25T10:57:10.974052Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2019-08-25T10:57:10.974561Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2019-08-25T10:57:10.975002Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2019-08-25T10:57:10.975544Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2019-08-25T10:57:10.976035Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2019-08-25T10:57:10.976504Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2019-08-25T10:57:10.976921Z 0 [Note] Shutting down plugin 'InnoDB'
2019-08-25T10:57:10.977359Z 0 [Note] InnoDB: FTS optimize thread exiting.
2019-08-25T10:57:10.977888Z 0 [Note] InnoDB: Starting shutdown...
2019-08-25T10:57:11.082157Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\myTools\mysql-5.7.22-winx64\data\ib_buffer_pool
2019-08-25T10:57:11.085055Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190825 18:57:11
2019-08-25T10:57:12.317633Z 0 [Note] InnoDB: Shutdown completed; log sequence number 602744930
2019-08-25T10:57:12.318944Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-25T10:57:12.319430Z 0 [Note] Shutting down plugin 'MEMORY'
2019-08-25T10:57:12.319937Z 0 [Note] Shutting down plugin 'CSV'
2019-08-25T10:57:12.320401Z 0 [Note] Shutting down plugin 'sha256_password'
2019-08-25T10:57:12.320953Z 0 [Note] Shutting down plugin 'mysql_native_password'
2019-08-25T10:57:12.321609Z 0 [Note] Shutting down plugin 'binlog'
2019-08-25T10:57:12.341979Z 0 [Note] mysqld.exe: Shutdown complete

查看了下别人解决方案说是可以删除binglog日志后重启就可以,我试着先备份如下日志:


然后把data下的这些日志删除了(ibdata1除外,这个删除了数据表会找不到),重启mysql,可以了,另外启动时最好用管理员身份启动,免得出错