|
莫名其妙无法启动了，在面板后台怎么启动都不行。 windows服务启动报错如下： 本地计算机上的mysql服务启动后停止,某些服务在未由其他服务或程序使用时将自动停止 myslq报错信息日志如下： 2021-01-07T12:27:32.162301Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:32.162489Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:32.162768Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:32.162959Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:32.163172Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:32.163355Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:32.163558Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:32.163807Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:32.164010Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:32.164203Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:32.164415Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:32.164655Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:32.164883Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:32.165065Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:32.165253Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:32.165427Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:32.165674Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:32.166076Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:32.166566Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:32.166842Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:32.167156Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:32.268374Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:32.269940Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:32 2021-01-07T12:27:33.456513Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530803 2021-01-07T12:27:33.457285Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:27:33.457590Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:27:33.457763Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:27:33.457930Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:27:33.458124Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:27:33.458428Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:27:33.475139Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:27:34.472624Z 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. 2021-01-07T12:27:34.473063Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:27:34.473891Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 10704 ... 2021-01-07T12:27:34.523747Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:27:34.524618Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:27:34.525025Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:27:34.525333Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:27:34.526455Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:27:34.527305Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:27:34.527706Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:27:34.530678Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:27:34.581722Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:27:34.654671Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:27:34.859211Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:27:34.859936Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:27:35.101255Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:27:35.103187Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:27:35.103992Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:27:35.105025Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:27:35.161936Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530803 2021-01-07T12:27:35.162583Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:35.162634Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:27:35.197033Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:27:35.197810Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:27:35.198656Z 0 [Note] IPv6 is available. 2021-01-07T12:27:35.198882Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:27:35.199238Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:27:35.217328Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:35 2021-01-07T12:27:35.218856Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:35.219412Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:35.219883Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:27:35.220806Z 0 [ERROR] Aborting 2021-01-07T12:27:35.220957Z 0 [Note] Binlog end 2021-01-07T12:27:35.224814Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:27:35.224982Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:27:35.225155Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:27:35.225369Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:27:35.225536Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:27:35.225757Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:27:35.225935Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:27:35.226110Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:27:35.226411Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:27:35.226611Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:27:35.226815Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:27:35.227021Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:27:35.227262Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:27:35.227453Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:27:35.227647Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:27:35.227841Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:27:35.228043Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:27:35.228342Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:27:35.228565Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:27:35.228769Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:35.228959Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:35.229295Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:35.229553Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:35.230108Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:35.230508Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:35.231075Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:35.231568Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:35.232045Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:35.232361Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:35.232574Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:35.232772Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:35.232968Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:35.233149Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:35.233340Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:35.233514Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:35.233705Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:35.233883Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:35.234057Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:35.234351Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:35.234669Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:35.336064Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:35.337883Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:35 2021-01-07T12:27:36.841657Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530838 2021-01-07T12:27:36.842515Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:27:36.842805Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:27:36.842978Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:27:36.843147Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:27:36.843343Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:27:36.843752Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:27:36.861037Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:27:37.497139Z 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. 2021-01-07T12:27:37.497204Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:27:37.497654Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 7348 ... 2021-01-07T12:27:37.540265Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:27:37.541236Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:27:37.541745Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:27:37.541998Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:27:37.542331Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:27:37.543003Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:27:37.543341Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:27:37.546651Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:27:37.597028Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:27:37.699376Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:27:37.856328Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:27:37.856990Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:27:38.046143Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:27:38.048348Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:27:38.048805Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:27:38.049485Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:27:38.100854Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530838 2021-01-07T12:27:38.101558Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:27:38.101629Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:38.141225Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:27:38.142096Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:27:38.143110Z 0 [Note] IPv6 is available. 2021-01-07T12:27:38.143437Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:27:38.143743Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:27:38.162313Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:38 2021-01-07T12:27:38.164879Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:38.165706Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:38.166749Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:27:38.167629Z 0 [ERROR] Aborting 2021-01-07T12:27:38.167794Z 0 [Note] Binlog end 2021-01-07T12:27:38.171540Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:27:38.171724Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:27:38.171904Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:27:38.172084Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:27:38.172313Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:27:38.172542Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:27:38.172727Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:27:38.172909Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:27:38.173112Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:27:38.173320Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:27:38.173649Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:27:38.173932Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:27:38.174160Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:27:38.174390Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:27:38.174595Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:27:38.174796Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:27:38.175006Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:27:38.175209Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:27:38.175480Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:27:38.175688Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:38.175883Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:38.176095Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:38.176360Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:38.176580Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:38.176769Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:38.176979Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:38.177222Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:38.177451Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:38.177652Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:38.177872Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:38.178077Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:38.178281Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:38.178468Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:38.178665Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:38.178847Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:38.179046Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:38.179334Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:38.179519Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:38.179751Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:38.180041Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:38.281189Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:38.282570Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:38 2021-01-07T12:27:39.681241Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530857 2021-01-07T12:27:39.682025Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:27:39.682266Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:27:39.682434Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:27:39.682592Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:27:39.682824Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:27:39.683116Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:27:39.698258Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:27:40.529188Z 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. 2021-01-07T12:27:40.529298Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:27:40.529773Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 9132 ... 2021-01-07T12:27:40.570650Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:27:40.571514Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:27:40.571834Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:27:40.572062Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:27:40.572708Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:27:40.574224Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:27:40.574590Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:27:40.577828Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:27:40.623878Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:27:40.719682Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:27:40.917281Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:27:40.918834Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:27:41.160553Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:27:41.162516Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:27:41.162937Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:27:41.163641Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:27:41.228413Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530857 2021-01-07T12:27:41.229142Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:41.229151Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:27:41.284819Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:27:41.285380Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:27:41.286205Z 0 [Note] IPv6 is available. 2021-01-07T12:27:41.286432Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:27:41.286768Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:27:41.305909Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:41 2021-01-07T12:27:41.307595Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:41.308157Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:41.308629Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:27:41.309651Z 0 [ERROR] Aborting 2021-01-07T12:27:41.309803Z 0 [Note] Binlog end 2021-01-07T12:27:41.313481Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:27:41.313649Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:27:41.313822Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:27:41.314042Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:27:41.314209Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:27:41.314431Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:27:41.314609Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:27:41.314784Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:27:41.315061Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:27:41.315276Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:27:41.315479Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:27:41.315685Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:27:41.315879Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:27:41.316174Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:27:41.316368Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:27:41.316563Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:27:41.316764Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:27:41.317010Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:27:41.317212Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:27:41.317413Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:41.317602Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:41.317808Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:41.318071Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:41.318284Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:41.318468Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:41.318672Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:41.318880Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:41.319127Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:41.319378Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:41.319592Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:41.319791Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:41.320045Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:41.320249Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:41.320425Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:41.320589Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:41.320768Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:41.320975Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:41.321156Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:41.321384Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:41.321686Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:41.423226Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:41.425037Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:41 2021-01-07T12:27:42.680493Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530876 2021-01-07T12:27:42.681322Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:27:42.681625Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:27:42.681793Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:27:42.681952Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:27:42.682139Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:27:42.682434Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:27:42.699246Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:27:43.576171Z 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. 2021-01-07T12:27:43.576274Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:27:43.576795Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 12240 ... 2021-01-07T12:27:43.618374Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:27:43.619751Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:27:43.620096Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:27:43.620341Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:27:43.620673Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:27:43.621260Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:27:43.621601Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:27:43.624781Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:27:43.670787Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:27:43.781072Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:27:44.020840Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:27:44.021541Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:27:44.234367Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:27:44.236702Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:27:44.237134Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:27:44.237808Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:27:44.294767Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530876 2021-01-07T12:27:44.295725Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:44.295822Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:27:44.340281Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:27:44.340975Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:27:44.341782Z 0 [Note] IPv6 is available. 2021-01-07T12:27:44.342011Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:27:44.342297Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:27:44.361314Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:44 2021-01-07T12:27:44.362683Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:44.363196Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:44.363666Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:27:44.364542Z 0 [ERROR] Aborting 2021-01-07T12:27:44.364693Z 0 [Note] Binlog end 2021-01-07T12:27:44.368266Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:27:44.368434Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:27:44.368608Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:27:44.368781Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:27:44.368954Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:27:44.369641Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:27:44.370128Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:27:44.370569Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:27:44.371088Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:27:44.371308Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:27:44.371512Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:27:44.371719Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:27:44.371913Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:27:44.372108Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:27:44.372302Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:27:44.372496Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:27:44.372698Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:27:44.372889Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:27:44.373194Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:27:44.373396Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:44.373586Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:44.373794Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:44.374049Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:44.374279Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:44.374463Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:44.374667Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:44.374875Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:44.375081Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:44.375276Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:44.375489Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:44.375688Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:44.375885Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:44.376069Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:44.376258Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:44.376433Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:44.376625Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:44.376804Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:44.377050Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:44.377274Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:44.377652Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:44.478850Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:44.480687Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:44 2021-01-07T12:27:45.797425Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530895 2021-01-07T12:27:45.798239Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:27:45.798478Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:27:45.798680Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:27:45.798838Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:27:45.799025Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:27:45.799338Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:27:45.815248Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:27:46.605023Z 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. 2021-01-07T12:27:46.605088Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:27:46.605546Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 9220 ... 2021-01-07T12:27:46.648560Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:27:46.649391Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:27:46.649810Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:27:46.650053Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:27:46.650409Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:27:46.651047Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:27:46.651394Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:27:46.654646Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:27:46.701904Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:27:46.800165Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:27:47.028978Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:27:47.029744Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:27:47.296854Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:27:47.298819Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:27:47.299219Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:27:47.299918Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:27:47.372222Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530895 2021-01-07T12:27:47.373059Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:27:47.373077Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:47.428596Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:27:47.429149Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:27:47.430018Z 0 [Note] IPv6 is available. 2021-01-07T12:27:47.430246Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:27:47.430788Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:27:47.449839Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:47 2021-01-07T12:27:47.451359Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:47.451943Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:47.452530Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:27:47.453406Z 0 [ERROR] Aborting 2021-01-07T12:27:47.453615Z 0 [Note] Binlog end 2021-01-07T12:27:47.457263Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:27:47.457429Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:27:47.457639Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:27:47.457811Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:27:47.457977Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:27:47.458195Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:27:47.458371Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:27:47.458586Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:27:47.458781Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:27:47.458979Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:27:47.459181Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:27:47.459386Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:27:47.459617Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:27:47.459807Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:27:47.459999Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:27:47.460192Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:27:47.460393Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:27:47.460662Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:27:47.460862Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:27:47.461062Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:47.461251Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:47.461456Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:47.461683Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:47.461895Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:47.462078Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:47.462280Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:47.462568Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:47.463104Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:47.463538Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:47.463768Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:47.463967Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:47.464162Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:47.464343Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:47.464568Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:47.464741Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:47.464931Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:47.465109Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:47.465282Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:47.465528Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:47.465902Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:47.567242Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:47.568995Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:47 2021-01-07T12:27:48.969047Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530914 2021-01-07T12:27:48.969807Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:27:48.970121Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:27:48.970311Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:27:48.970476Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:27:48.970670Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:27:48.970970Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:27:48.988234Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:27:49.655606Z 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. 2021-01-07T12:27:49.655672Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:27:49.656136Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 1032 ... 2021-01-07T12:27:49.697268Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:27:49.698609Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:27:49.698958Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:27:49.699294Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:27:49.699642Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:27:49.700344Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:27:49.700691Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:27:49.703837Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:27:49.752191Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:27:49.820688Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:27:50.008613Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:27:50.009317Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:27:50.190107Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:27:50.192157Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:27:50.192562Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:27:50.193236Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:27:50.250439Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530914 2021-01-07T12:27:50.251065Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:50.251152Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:27:50.296091Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:27:50.296644Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:27:50.297442Z 0 [Note] IPv6 is available. 2021-01-07T12:27:50.297668Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:27:50.298051Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:27:50.317093Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:50 2021-01-07T12:27:50.318454Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:50.318930Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:50.319442Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:27:50.320372Z 0 [ERROR] Aborting 2021-01-07T12:27:50.320523Z 0 [Note] Binlog end 2021-01-07T12:27:50.325439Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:27:50.325620Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:27:50.325800Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:27:50.326021Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:27:50.326206Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:27:50.326427Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:27:50.326606Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:27:50.326781Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:27:50.327108Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:27:50.327325Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:27:50.327529Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:27:50.327735Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:27:50.327929Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:27:50.328209Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:27:50.328403Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:27:50.328596Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:27:50.328797Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:27:50.328991Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:27:50.329192Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:27:50.329394Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:50.329583Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:50.329788Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:50.330011Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:50.330243Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:50.330427Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:50.330631Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:50.330839Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:50.331092Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:50.331286Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:50.331498Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:50.331697Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:50.331894Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:50.332154Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:50.332343Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:50.332517Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:50.332709Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:50.332888Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:50.333064Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:50.333279Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:50.333603Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:50.434448Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:50.436284Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:50 2021-01-07T12:27:51.692409Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530933 2021-01-07T12:27:51.693199Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:27:51.693482Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:27:51.693657Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:27:51.693822Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:27:51.694056Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:27:51.694357Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:27:51.709809Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:27:52.687487Z 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. 2021-01-07T12:27:52.687611Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:27:52.688075Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 7052 ... 2021-01-07T12:27:52.732042Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:27:52.732859Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:27:52.733286Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:27:52.733597Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:27:52.734054Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:27:52.734809Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:27:52.735164Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:27:52.738218Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:27:52.788845Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:27:52.898091Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:27:53.097622Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:27:53.098290Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:27:53.348623Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:27:53.351779Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:27:53.352615Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:27:53.353290Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:27:53.416561Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530933 2021-01-07T12:27:53.417343Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:53.417478Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:27:53.472853Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:27:53.473522Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:27:53.474364Z 0 [Note] IPv6 is available. 2021-01-07T12:27:53.474591Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:27:53.474875Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:27:53.494025Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:53 2021-01-07T12:27:53.495666Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:53.496286Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:53.496758Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:27:53.497699Z 0 [ERROR] Aborting 2021-01-07T12:27:53.497888Z 0 [Note] Binlog end 2021-01-07T12:27:53.502349Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:27:53.502523Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:27:53.502697Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:27:53.502870Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:27:53.503087Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:27:53.503329Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:27:53.503508Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:27:53.503683Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:27:53.503879Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:27:53.504162Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:27:53.504366Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:27:53.504572Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:27:53.504765Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:27:53.504957Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:27:53.505223Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:27:53.505417Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:27:53.505618Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:27:53.505809Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:27:53.506123Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:27:53.506326Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:53.506516Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:53.506722Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:53.506913Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:53.507171Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:53.507355Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:53.507558Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:53.507766Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:53.507970Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:53.508211Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:53.508424Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:53.508623Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:53.508819Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:53.509003Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:53.509192Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:53.509366Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:53.509751Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:53.510183Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:53.510675Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:53.511191Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:53.511649Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:53.613073Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:53.615182Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:53 2021-01-07T12:27:55.014040Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530952 2021-01-07T12:27:55.014765Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:27:55.015008Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:27:55.015175Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:27:55.015334Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:27:55.015521Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:27:55.015852Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:27:55.031984Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:27:55.717920Z 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. 2021-01-07T12:27:55.717987Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:27:55.718475Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 11800 ... 2021-01-07T12:27:55.760952Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:27:55.761752Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:27:55.762215Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:27:55.762470Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:27:55.762815Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:27:55.763457Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:27:55.763819Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:27:55.767213Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:27:55.814290Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:27:55.876508Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:27:56.072685Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:27:56.073348Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:27:56.296280Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:27:56.298259Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:27:56.298658Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:27:56.299401Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:27:56.361068Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530952 2021-01-07T12:27:56.361900Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:27:56.361901Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:56.384618Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:27:56.385519Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:27:56.386463Z 0 [Note] IPv6 is available. 2021-01-07T12:27:56.386758Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:27:56.387047Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:27:56.394416Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:56 2021-01-07T12:27:56.395873Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:56.396361Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:56.396852Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:27:56.397702Z 0 [ERROR] Aborting 2021-01-07T12:27:56.397861Z 0 [Note] Binlog end 2021-01-07T12:27:56.402201Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:27:56.402380Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:27:56.402559Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:27:56.402736Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:27:56.402908Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:27:56.403132Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:27:56.403315Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:27:56.403495Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:27:56.403697Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:27:56.403901Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:27:56.404110Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:27:56.404321Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:27:56.404613Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:27:56.404814Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:27:56.405016Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:27:56.405217Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:27:56.405450Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:27:56.405724Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:27:56.405933Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:27:56.406142Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:56.406338Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:56.406553Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:56.406749Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:56.406969Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:56.407158Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:56.407367Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:56.407636Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:56.407845Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:56.408110Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:56.408330Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:56.408537Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:56.408739Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:56.408926Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:56.409121Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:56.409300Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:56.409498Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:56.409682Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:56.409862Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:56.410091Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:56.410430Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:56.511598Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:56.513408Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:56 2021-01-07T12:27:57.936644Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530971 2021-01-07T12:27:57.937434Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:27:57.937675Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:27:57.937871Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:27:57.938066Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:27:57.938252Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:27:57.938545Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:27:57.954636Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:27:58.763612Z 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. 2021-01-07T12:27:58.763678Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:27:58.764150Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 11208 ... 2021-01-07T12:27:58.808393Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:27:58.809192Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:27:58.809611Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:27:58.809856Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:27:58.810188Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:27:58.810888Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:27:58.811225Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:27:58.814839Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:27:58.862770Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:27:58.975511Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:27:59.155331Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:27:59.156043Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:27:59.378067Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:27:59.379955Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:27:59.380404Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:27:59.381043Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:27:59.438577Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530971 2021-01-07T12:27:59.439289Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:59.439328Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:27:59.494778Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:27:59.495520Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:27:59.496381Z 0 [Note] IPv6 is available. 2021-01-07T12:27:59.496614Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:27:59.496972Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:27:59.516115Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:59 2021-01-07T12:27:59.517644Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:59.518179Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:27:59.518665Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:27:59.519559Z 0 [ERROR] Aborting 2021-01-07T12:27:59.519788Z 0 [Note] Binlog end 2021-01-07T12:27:59.523859Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:27:59.524042Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:27:59.524275Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:27:59.524453Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:27:59.524625Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:27:59.524852Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:27:59.525035Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:27:59.525256Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:27:59.525458Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:27:59.525663Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:27:59.525871Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:27:59.526158Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:27:59.526361Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:27:59.526559Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:27:59.526760Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:27:59.526961Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:27:59.527240Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:27:59.527438Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:27:59.527645Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:27:59.527854Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:27:59.528095Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:27:59.528353Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:27:59.528615Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:27:59.528855Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:27:59.529092Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:27:59.529326Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:27:59.529541Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:27:59.529750Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:27:59.529950Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:27:59.530212Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:27:59.530418Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:27:59.530620Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:27:59.530848Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:27:59.531095Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:27:59.531292Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:27:59.531490Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:27:59.531675Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:27:59.531855Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:27:59.532145Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:27:59.532518Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:27:59.633273Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:27:59.635190Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:59 2021-01-07T12:28:01.007027Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530990 2021-01-07T12:28:01.007738Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:28:01.007978Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:28:01.008143Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:28:01.008301Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:28:01.008527Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:28:01.008819Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:28:01.026350Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:28:01.797326Z 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. 2021-01-07T12:28:01.797393Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:28:01.798007Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 7928 ... 2021-01-07T12:28:01.842146Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:28:01.842939Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:28:01.843291Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:28:01.843545Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:28:01.843889Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:28:01.844498Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:28:01.844850Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:28:01.848301Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:28:01.898024Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:28:01.963910Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:28:02.209661Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:28:02.210383Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:28:02.459257Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:28:02.461217Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:28:02.461978Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:28:02.463452Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:28:02.526974Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530990 2021-01-07T12:28:02.527760Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:28:02.527820Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:28:02.572566Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:28:02.573242Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:28:02.574248Z 0 [Note] IPv6 is available. 2021-01-07T12:28:02.574516Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:28:02.574856Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:28:02.593685Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:28:02 2021-01-07T12:28:02.595171Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:28:02.595665Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:28:02.596312Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:28:02.597162Z 0 [ERROR] Aborting 2021-01-07T12:28:02.597326Z 0 [Note] Binlog end 2021-01-07T12:28:02.601113Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:28:02.601296Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:28:02.601470Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:28:02.601645Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:28:02.601814Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:28:02.602098Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:28:02.602278Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:28:02.602453Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:28:02.602651Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:28:02.602852Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:28:02.603131Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:28:02.603338Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:28:02.603534Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:28:02.603728Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:28:02.603924Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:28:02.604214Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:28:02.604417Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:28:02.604610Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:28:02.604813Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:28:02.605214Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:28:02.605765Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:28:02.606330Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:28:02.606544Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:28:02.606758Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:28:02.606967Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:28:02.607188Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:28:02.607397Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:28:02.607601Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:28:02.607795Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:28:02.608068Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:28:02.608267Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:28:02.608463Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:28:02.608645Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:28:02.608834Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:28:02.609048Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:28:02.609240Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:28:02.609420Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:28:02.609595Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:28:02.609847Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:28:02.610256Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:28:02.711267Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:28:02.713594Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:28:02 2021-01-07T12:28:03.993556Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2531009 2021-01-07T12:28:03.994202Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:28:03.994453Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:28:03.994626Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:28:03.994795Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:28:03.995031Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:28:03.995479Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:28:04.012368Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:28:04.842241Z 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. 2021-01-07T12:28:04.842307Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:28:04.842816Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 3160 ... 2021-01-07T12:28:04.885075Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:28:04.885903Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:28:04.886243Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:28:04.886559Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:28:04.886887Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:28:04.887619Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:28:04.888599Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:28:04.892018Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:28:04.939195Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:28:05.079691Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:28:05.265156Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:28:05.265857Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:28:05.444822Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:28:05.447946Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:28:05.448366Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:28:05.449053Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:28:05.500578Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2531009 2021-01-07T12:28:05.501258Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:28:05.501262Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:28:05.561496Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:28:05.562227Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:28:05.563116Z 0 [Note] IPv6 is available. 2021-01-07T12:28:05.563377Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:28:05.564398Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:28:05.582413Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:28:05 2021-01-07T12:28:05.584756Z 0 [ERROR] F:BtSoftmysqlMySQL5.7inmysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:28:05.585801Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.mysqluser' is marked as crashed and should be repaired 2021-01-07T12:28:05.586432Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2021-01-07T12:28:05.587666Z 0 [ERROR] Aborting 2021-01-07T12:28:05.587998Z 0 [Note] Binlog end 2021-01-07T12:28:05.592712Z 0 [Note] Shutting down plugin 'ngram' 2021-01-07T12:28:05.593077Z 0 [Note] Shutting down plugin 'partition' 2021-01-07T12:28:05.593297Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-07T12:28:05.593581Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-07T12:28:05.593833Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-07T12:28:05.594157Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-07T12:28:05.594470Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-07T12:28:05.594805Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-07T12:28:05.595274Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-07T12:28:05.595599Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-07T12:28:05.595886Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-07T12:28:05.596146Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-07T12:28:05.596346Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-07T12:28:05.596587Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-07T12:28:05.596786Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-07T12:28:05.596985Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-07T12:28:05.597191Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-07T12:28:05.597386Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-07T12:28:05.597640Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-07T12:28:05.597846Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-07T12:28:05.598040Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-07T12:28:05.598251Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-07T12:28:05.598451Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-07T12:28:05.598671Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-07T12:28:05.598860Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-07T12:28:05.599069Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-07T12:28:05.599283Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-07T12:28:05.599495Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-07T12:28:05.599695Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-07T12:28:05.599914Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-07T12:28:05.600118Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-07T12:28:05.600319Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-07T12:28:05.600584Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-07T12:28:05.600801Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-07T12:28:05.600981Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-07T12:28:05.601179Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-07T12:28:05.601516Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-07T12:28:05.601904Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-07T12:28:05.602184Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-07T12:28:05.602510Z 0 [Note] InnoDB: Starting shutdown... 2021-01-07T12:28:05.703372Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:28:05.705188Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:28:05 2021-01-07T12:28:07.095922Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2531028 2021-01-07T12:28:07.096622Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-07T12:28:07.096944Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-07T12:28:07.097110Z 0 [Note] Shutting down plugin 'CSV' 2021-01-07T12:28:07.097271Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-07T12:28:07.097457Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-07T12:28:07.097767Z 0 [Note] Shutting down plugin 'binlog' 2021-01-07T12:28:07.114154Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: Shutdown complete 2021-01-07T12:28:49.440032Z 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. 2021-01-07T12:28:49.440098Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-01-07T12:28:49.440596Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe (mysqld 5.7.26) starting as process 2484 ... 2021-01-07T12:28:49.486947Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144 2021-01-07T12:28:49.487741Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-01-07T12:28:49.488162Z 0 [Note] InnoDB: Uses event mutexes 2021-01-07T12:28:49.488411Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-01-07T12:28:49.488748Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-07T12:28:49.489414Z 0 [Note] InnoDB: Number of pools: 1 2021-01-07T12:28:49.489755Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-01-07T12:28:49.495042Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2021-01-07T12:28:49.558477Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-07T12:28:49.654003Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-07T12:28:49.885482Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-07T12:28:49.886209Z 0 [Note] InnoDB: Setting file 'F:BtSoftmysqlMySQL5.7dataibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-07T12:28:50.101292Z 0 [Note] InnoDB: File 'F:BtSoftmysqlMySQL5.7dataibtmp1' size is now 12 MB. 2021-01-07T12:28:50.103283Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-07T12:28:50.103685Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-07T12:28:50.104454Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-07T12:28:50.161219Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2531028 2021-01-07T12:28:50.162254Z 0 [Note] InnoDB: Loading buffer pool(s) from F:BtSoftmysqlMySQL5.7dataib_buffer_pool 2021-01-07T12:28:50.162285Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-07T12:28:50.206877Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2021-01-07T12:28:50.207436Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-01-07T12:28:50.208300Z 0 [Note] IPv6 is available. 2021-01-07T12:28:50.208529Z 0 [Note] - '::' resolves to '::'; 2021-01-07T12:28:50.209078Z 0 [Note] Server socket created on IP: '::'. 2021-01-07T12:28:50.227726Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:28:50 2021-01-07T12:28:50.376581Z 0 [Note] Failed to start slave threads for channel '' 2021-01-07T12:28:50.517992Z 0 [Note] Event Scheduler: Loaded 0 events 2021-01-07T12:28:50.518452Z 0 [Note] F:BtSoftmysqlMySQL5.7inmysqld.exe: ready for connections. Version: '5.7.26' socket: '' port: 3306 MySQL Community Server (GPL)
从日志排查出。应该是mysql的user表索引错误。修复即可 修复命令 myisamchk -c -r ../data/mysql/user
修复完成，正常！！！ 更多相关解决教程《MySQL无法启动、无法停止解决方法》 |
