产品服务AMH 免费服务器主机面板SSL证书 免费SSL证书申请 担保单 免费安全、零费率交易平台编程助手免费智能写代码、翻译AMYSQL 免费MySQL管理工具

AMH 社区首页

 AMH社区 - 开放自由有价值的社区

[综合话题] mysql-5.7 启动失败。

236014723
铁牌会员
7.00 价值分

236014723 发表于 2021-05-20 17:10:38
mysql-5.7 启动失败。


附件文件
1. 20210520170651.jpg  (90.69 KB)
2021-05-20 17:10:38 1

amysql
创始人
16530.81 价值分

复制页面提供完整些日志信息,不要截图,看到的信息太少。
  支持 (0分)  反对 (0分)
回复  2021-05-20 17:46:35 2

AMH面板 - 好用高效低占用、安全可靠极稳定

236014723
铁牌会员
7.00 价值分

=============================================================
[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.
  支持 (0分)  反对 (0分)
回复  2021-05-21 14:35:41 3

amysql
创始人
16530.81 价值分

报错是找不到mysql-bin.000015日志文件,如果是有手动删除过mysql-5.7日志文件,要删除干净。
rm -f /home/usrdata/mysql-5.7/mysql-bin.*
amh mysql start
  支持 (3.41分)  反对 (0分)
回复  2021-05-21 15:07:04 4
 1  (总1页)
AMH社区列表
用户服务中心