AMH 社区首页
AMH社区 - 开放自由有价值的社区
[综合话题] mysql-5.7 启动失败。 |
|
---|---|
236014723 |
236014723 发表于 2021-05-20 17:10:38
点赞,加油! (0分)
2021-05-20 17:10:38 1
|
amysql |
复制页面提供完整些日志信息,不要截图,看到的信息太少。
回复
2021-05-20 17:46:35 2
AMH面板 - 好用高效低占用、安全可靠极稳定 |
236014723 |
=============================================================
[Linux] AMH 6.0 http://amh.sh [mysql-5.7 start] ============================================================= [OK] mysql-5.7 is already installed. Starting MySQL... ERROR! The server quit without updating PID file (/home/usrdata/mysql-5.7/mysql.pid). 2021-05-20T09:45:04.987294Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-05-20T09:45:04.987303Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-05-20T09:45:04.987311Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-05-20T09:45:04.987319Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-05-20T09:45:04.987327Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-05-20T09:45:04.987335Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-05-20T09:45:04.987344Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-05-20T09:45:04.987352Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-05-20T09:45:04.987360Z 0 [Note] Shutting down plugin 'InnoDB' 2021-05-20T09:45:04.987447Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-05-20T09:45:04.987827Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/usrdata/mysql-5.7/ib_buffer_pool 2021-05-20T09:45:04.988109Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210520 17:45:04 2021-05-20T09:45:04.988185Z 0 [Note] InnoDB: Starting shutdown... 2021-05-20T09:45:05.088623Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/usrdata/mysql-5.7/ib_buffer_pool 2021-05-20T09:45:05.089001Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210520 17:45:05 2021-05-20T09:45:06.397297Z 0 [Note] InnoDB: Shutdown completed; log sequence number 16292629794 2021-05-20T09:45:06.399053Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-05-20T09:45:06.399077Z 0 [Note] Shutting down plugin 'MEMORY' 2021-05-20T09:45:06.399091Z 0 [Note] Shutting down plugin 'CSV' 2021-05-20T09:45:06.399100Z 0 [Note] Shutting down plugin 'sha256_password' 2021-05-20T09:45:06.399106Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-05-20T09:45:06.399238Z 0 [Note] Shutting down plugin 'binlog' 2021-05-20T09:45:06.399397Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete 2021-05-20T09:45:29.402810Z 0 [Warning] The use of InnoDB is mandatory since MySQL 5.7. The former options like '--innodb=0/1/OFF/ON' or '--skip-innodb' are ignored. 2021-05-20T09:45:29.402979Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-05-20T09:45:29.402999Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2021-05-20T09:45:29.403055Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-05-20T09:45:29.403127Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.27-log) starting as process 11622 ... 2021-05-20T09:45:29.411872Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-05-20T09:45:29.411956Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-05-20T09:45:29.411970Z 0 [Note] InnoDB: Uses event mutexes 2021-05-20T09:45:29.411979Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-05-20T09:45:29.411989Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-05-20T09:45:29.412742Z 0 [Note] InnoDB: Number of pools: 1 2021-05-20T09:45:29.413037Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-05-20T09:45:29.415238Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-05-20T09:45:29.430371Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-05-20T09:45:29.433236Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-05-20T09:45:29.446304Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-05-20T09:45:29.462890Z 0 [Note] InnoDB: Transaction 26830900 was in the XA prepared state. 2021-05-20T09:45:29.463900Z 0 [Note] InnoDB: Transaction 26830839 was in the XA prepared state. 2021-05-20T09:45:29.464258Z 0 [Note] InnoDB: Transaction 26830843 was in the XA prepared state. 2021-05-20T09:45:29.464286Z 0 [Note] InnoDB: Transaction 26830885 was in the XA prepared state. 2021-05-20T09:45:29.464305Z 0 [Note] InnoDB: 4 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2021-05-20T09:45:29.464316Z 0 [Note] InnoDB: Trx id counter is 26850048 2021-05-20T09:45:29.498584Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-05-20T09:45:29.498762Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-05-20T09:45:29.500987Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2021-05-20T09:45:29.501053Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2021-05-20T09:45:29.607385Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-05-20T09:45:29.609923Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-05-20T09:45:29.609958Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-05-20T09:45:29.611982Z 0 [Note] InnoDB: Waiting for purge to start 2021-05-20T09:45:29.662277Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 16292629794 2021-05-20T09:45:29.662927Z 0 [Note] Plugin 'FEDERATED' is disabled. mysqld: File './mysql-bin.000015' not found (Errcode: 2 - No such file or directory) 2021-05-20T09:45:29.670569Z 0 [ERROR] Failed to open log (file './mysql-bin.000015', errno 2) 2021-05-20T09:45:29.670586Z 0 [ERROR] Could not open log file 2021-05-20T09:45:29.670623Z 0 [ERROR] Can't init tc log 2021-05-20T09:45:29.670679Z 0 [ERROR] Aborting 2021-05-20T09:45:29.670706Z 0 [Note] Binlog end 2021-05-20T09:45:29.670844Z 0 [Note] Shutting down plugin 'ngram' 2021-05-20T09:45:29.670870Z 0 [Note] Shutting down plugin 'partition' 2021-05-20T09:45:29.670885Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-05-20T09:45:29.670898Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-05-20T09:45:29.670908Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-05-20T09:45:29.671041Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-05-20T09:45:29.671054Z 0 [Note] Shutting down plugin 'MyISAM' 2021-05-20T09:45:29.671081Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-05-20T09:45:29.671094Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-05-20T09:45:29.671105Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-05-20T09:45:29.671118Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-05-20T09:45:29.671130Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-05-20T09:45:29.671140Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-05-20T09:45:29.671150Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-05-20T09:45:29.671159Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-05-20T09:45:29.671168Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-05-20T09:45:29.671177Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-05-20T09:45:29.671186Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-05-20T09:45:29.671197Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-05-20T09:45:29.671208Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-05-20T09:45:29.671221Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-05-20T09:45:29.671233Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-05-20T09:45:29.671245Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-05-20T09:45:29.671258Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-05-20T09:45:29.671270Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-05-20T09:45:29.671282Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-05-20T09:45:29.671294Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-05-20T09:45:29.671396Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-05-20T09:45:29.671419Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-05-20T09:45:29.671431Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-05-20T09:45:29.671441Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-05-20T09:45:29.671451Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-05-20T09:45:29.671461Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-05-20T09:45:29.671474Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-05-20T09:45:29.671484Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-05-20T09:45:29.671496Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-05-20T09:45:29.671508Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-05-20T09:45:29.671518Z 0 [Note] Shutting down plugin 'InnoDB' 2021-05-20T09:45:29.671651Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-05-20T09:45:29.671854Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/usrdata/mysql-5.7/ib_buffer_pool 2021-05-20T09:45:29.672132Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210520 17:45:29 2021-05-20T09:45:29.672202Z 0 [Note] InnoDB: Starting shutdown... 2021-05-20T09:45:29.772724Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/usrdata/mysql-5.7/ib_buffer_pool 2021-05-20T09:45:29.773080Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210520 17:45:29 2021-05-20T09:45:31.086367Z 0 [Note] InnoDB: Shutdown completed; log sequence number 16292629813 2021-05-20T09:45:31.088245Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-05-20T09:45:31.088269Z 0 [Note] Shutting down plugin 'MEMORY' 2021-05-20T09:45:31.088310Z 0 [Note] Shutting down plugin 'CSV' 2021-05-20T09:45:31.088322Z 0 [Note] Shutting down plugin 'sha256_password' 2021-05-20T09:45:31.088328Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-05-20T09:45:31.088474Z 0 [Note] Shutting down plugin 'binlog' 2021-05-20T09:45:31.088840Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete 2021-05-20T17:27:12.140096Z 0 [Warning] The use of InnoDB is mandatory since MySQL 5.7. The former options like '--innodb=0/1/OFF/ON' or '--skip-innodb' are ignored. 2021-05-20T17:27:12.140314Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-05-20T17:27:12.140340Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2021-05-20T17:27:12.146147Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-05-20T17:27:12.146255Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.27-log) starting as process 14453 ... 2021-05-20T17:27:12.181439Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-05-20T17:27:12.181497Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-05-20T17:27:12.181510Z 0 [Note] InnoDB: Uses event mutexes 2021-05-20T17:27:12.181521Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-05-20T17:27:12.181531Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-05-20T17:27:12.182231Z 0 [Note] InnoDB: Number of pools: 1 2021-05-20T17:27:12.182522Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-05-20T17:27:12.185354Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-05-20T17:27:12.240245Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-05-20T17:27:12.261532Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-05-20T17:27:12.289193Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-05-20T17:27:12.455529Z 0 [Note] InnoDB: Transaction 26830900 was in the XA prepared state. 2021-05-20T17:27:12.468956Z 0 [Note] InnoDB: Transaction 26830839 was in the XA prepared state. 2021-05-20T17:27:12.470602Z 0 [Note] InnoDB: Transaction 26830843 was in the XA prepared state. 2021-05-20T17:27:12.470662Z 0 [Note] InnoDB: Transaction 26830885 was in the XA prepared state. 2021-05-20T17:27:12.470691Z 0 [Note] InnoDB: 4 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2021-05-20T17:27:12.470704Z 0 [Note] InnoDB: Trx id counter is 26850560 2021-05-20T17:27:12.520541Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-05-20T17:27:12.520658Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-05-20T17:27:12.547848Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2021-05-20T17:27:12.547898Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2021-05-20T17:27:12.636505Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-05-20T17:27:12.637621Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-05-20T17:27:12.637662Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-05-20T17:27:12.638420Z 0 [Note] InnoDB: Waiting for purge to start 2021-05-20T17:27:12.691826Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 16292629813 2021-05-20T17:27:12.692339Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-05-20T17:27:12.701341Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/usrdata/mysql-5.7/ib_buffer_pool mysqld: File './mysql-bin.000015' not found (Errcode: 2 - No such file or directory) 2021-05-20T17:27:12.716773Z 0 [ERROR] Failed to open log (file './mysql-bin.000015', errno 2) 2021-05-20T17:27:12.716784Z 0 [ERROR] Could not open log file 2021-05-20T17:27:12.716796Z 0 [ERROR] Can't init tc log 2021-05-20T17:27:12.716812Z 0 [ERROR] Aborting 2021-05-20T17:27:12.716831Z 0 [Note] Binlog end 2021-05-20T17:27:12.716935Z 0 [Note] Shutting down plugin 'ngram' 2021-05-20T17:27:12.716956Z 0 [Note] Shutting down plugin 'partition' 2021-05-20T17:27:12.716978Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-05-20T17:27:12.716987Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-05-20T17:27:12.716995Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-05-20T17:27:12.717094Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-05-20T17:27:12.717105Z 0 [Note] Shutting down plugin 'MyISAM' 2021-05-20T17:27:12.717134Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-05-20T17:27:12.717144Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-05-20T17:27:12.717151Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-05-20T17:27:12.717158Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-05-20T17:27:12.717165Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-05-20T17:27:12.717172Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-05-20T17:27:12.717179Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-05-20T17:27:12.717186Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-05-20T17:27:12.717193Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-05-20T17:27:12.717200Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-05-20T17:27:12.717207Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-05-20T17:27:12.717214Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-05-20T17:27:12.717221Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-05-20T17:27:12.717228Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-05-20T17:27:12.717235Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-05-20T17:27:12.717242Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-05-20T17:27:12.717250Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-05-20T17:27:12.717257Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-05-20T17:27:12.717264Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-05-20T17:27:12.717271Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-05-20T17:27:12.717278Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-05-20T17:27:12.717285Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-05-20T17:27:12.717292Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-05-20T17:27:12.717299Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-05-20T17:27:12.717306Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-05-20T17:27:12.717313Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-05-20T17:27:12.717320Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-05-20T17:27:12.717328Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-05-20T17:27:12.717335Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-05-20T17:27:12.717342Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-05-20T17:27:12.717349Z 0 [Note] Shutting down plugin 'InnoDB' 2021-05-20T17:27:12.717412Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-05-20T17:27:12.717582Z 0 [Note] InnoDB: Starting shutdown... 2021-05-20T17:27:12.720726Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210521 1:27:12 2021-05-20T17:27:12.720773Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/usrdata/mysql-5.7/ib_buffer_pool 2021-05-20T17:27:12.721013Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210521 1:27:12 2021-05-20T17:27:14.127538Z 0 [Note] InnoDB: Shutdown completed; log sequence number 16292629832 2021-05-20T17:27:14.129706Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-05-20T17:27:14.129735Z 0 [Note] Shutting down plugin 'MEMORY' 2021-05-20T17:27:14.129750Z 0 [Note] Shutting down plugin 'CSV' 2021-05-20T17:27:14.129760Z 0 [Note] Shutting down plugin 'sha256_password' 2021-05-20T17:27:14.129766Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-05-20T17:27:14.129903Z 0 [Note] Shutting down plugin 'binlog' 2021-05-20T17:27:14.130092Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete 2021-05-21T06:34:53.025335Z 0 [Warning] The use of InnoDB is mandatory since MySQL 5.7. The former options like '--innodb=0/1/OFF/ON' or '--skip-innodb' are ignored. 2021-05-21T06:34:53.025518Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-05-21T06:34:53.025539Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2021-05-21T06:34:53.025600Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-05-21T06:34:53.025683Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.27-log) starting as process 9839 ... 2021-05-21T06:34:53.039239Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-05-21T06:34:53.039305Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-05-21T06:34:53.039319Z 0 [Note] InnoDB: Uses event mutexes 2021-05-21T06:34:53.039329Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-05-21T06:34:53.039340Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-05-21T06:34:53.039908Z 0 [Note] InnoDB: Number of pools: 1 2021-05-21T06:34:53.042976Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-05-21T06:34:53.045596Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-05-21T06:34:53.072717Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-05-21T06:34:53.082754Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-05-21T06:34:53.109516Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-05-21T06:34:53.174920Z 0 [Note] InnoDB: Transaction 26830900 was in the XA prepared state. 2021-05-21T06:34:53.179693Z 0 [Note] InnoDB: Transaction 26830839 was in the XA prepared state. 2021-05-21T06:34:53.181494Z 0 [Note] InnoDB: Transaction 26830843 was in the XA prepared state. 2021-05-21T06:34:53.181531Z 0 [Note] InnoDB: Transaction 26830885 was in the XA prepared state. 2021-05-21T06:34:53.181552Z 0 [Note] InnoDB: 4 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2021-05-21T06:34:53.181564Z 0 [Note] InnoDB: Trx id counter is 26851072 2021-05-21T06:34:53.274407Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-05-21T06:34:53.274521Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-05-21T06:34:53.283689Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2021-05-21T06:34:53.283744Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2021-05-21T06:34:53.379460Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-05-21T06:34:53.381424Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-05-21T06:34:53.381451Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-05-21T06:34:53.381850Z 0 [Note] InnoDB: Waiting for purge to start 2021-05-21T06:34:53.432157Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 16292629832 2021-05-21T06:34:53.433364Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/usrdata/mysql-5.7/ib_buffer_pool 2021-05-21T06:34:53.444559Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-05-21T06:34:53.451018Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210521 14:34:53 mysqld: File './mysql-bin.000015' not found (Errcode: 2 - No such file or directory) 2021-05-21T06:34:53.454118Z 0 [ERROR] Failed to open log (file './mysql-bin.000015', errno 2) 2021-05-21T06:34:53.454128Z 0 [ERROR] Could not open log file 2021-05-21T06:34:53.454138Z 0 [ERROR] Can't init tc log 2021-05-21T06:34:53.454148Z 0 [ERROR] Aborting 2021-05-21T06:34:53.454163Z 0 [Note] Binlog end 2021-05-21T06:34:53.454243Z 0 [Note] Shutting down plugin 'ngram' 2021-05-21T06:34:53.454257Z 0 [Note] Shutting down plugin 'partition' 2021-05-21T06:34:53.454265Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-05-21T06:34:53.454272Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-05-21T06:34:53.454278Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-05-21T06:34:53.454362Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-05-21T06:34:53.454377Z 0 [Note] Shutting down plugin 'MyISAM' 2021-05-21T06:34:53.454398Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-05-21T06:34:53.454405Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-05-21T06:34:53.454412Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-05-21T06:34:53.454418Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-05-21T06:34:53.454424Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-05-21T06:34:53.454430Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-05-21T06:34:53.454436Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-05-21T06:34:53.454442Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-05-21T06:34:53.454449Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-05-21T06:34:53.454455Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-05-21T06:34:53.454461Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-05-21T06:34:53.454467Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-05-21T06:34:53.454473Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-05-21T06:34:53.454479Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-05-21T06:34:53.454485Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-05-21T06:34:53.454491Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-05-21T06:34:53.454498Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-05-21T06:34:53.454504Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-05-21T06:34:53.454510Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-05-21T06:34:53.454516Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-05-21T06:34:53.454522Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-05-21T06:34:53.454528Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-05-21T06:34:53.454534Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-05-21T06:34:53.454540Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-05-21T06:34:53.454546Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-05-21T06:34:53.454553Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-05-21T06:34:53.454559Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-05-21T06:34:53.454565Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-05-21T06:34:53.454571Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-05-21T06:34:53.454577Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-05-21T06:34:53.454583Z 0 [Note] Shutting down plugin 'InnoDB' 2021-05-21T06:34:53.454646Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-05-21T06:34:53.454801Z 0 [Note] InnoDB: Starting shutdown... 2021-05-21T06:34:53.555848Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/usrdata/mysql-5.7/ib_buffer_pool 2021-05-21T06:34:53.556124Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210521 14:34:53 2021-05-21T06:34:54.912167Z 0 [Note] InnoDB: Shutdown completed; log sequence number 16292629851 2021-05-21T06:34:54.914576Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-05-21T06:34:54.914604Z 0 [Note] Shutting down plugin 'MEMORY' 2021-05-21T06:34:54.924745Z 0 [Note] Shutting down plugin 'CSV' 2021-05-21T06:34:54.924769Z 0 [Note] Shutting down plugin 'sha256_password' 2021-05-21T06:34:54.924776Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-05-21T06:34:54.924967Z 0 [Note] Shutting down plugin 'binlog' 2021-05-21T06:34:54.937650Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete [Error] mysql-5.7 start failed.
回复
2021-05-21 14:35:41 3
|
amysql |
报错是找不到mysql-bin.000015日志文件,如果是有手动删除过mysql-5.7日志文件,要删除干净。
rm -f /home/usrdata/mysql-5.7/mysql-bin.* amh mysql start
回复
2021-05-21 15:07:04 4
|