救急~mysql无法启动,显示[ERROR] Aborting无其他原因。
16lz
2021-01-22
搞了一个下午,百度查不到,求帮助!!
/usr/local/mysql56/bin/mysqld_safe--defaults-file=/mysqldata/node1/my.cnf
2018-01-1816:56:0910619[Note]InnoDB:Usingatomicstorefcountbufferpoolpages
2018-01-1816:56:0910619[Note]InnoDB:TheInnoDBmemoryheapisdisabled
2018-01-1816:56:0910619[Note]InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins
2018-01-1816:56:0910619[Note]InnoDB:Memorybarrierisnotused
2018-01-1816:56:0910619[Note]InnoDB:Compressedtablesusezlib1.2.3
2018-01-1816:56:0910619[Note]InnoDB:UsingLinuxnativeAIO
2018-01-1816:56:0910619[Note]InnoDB:UsingCPUcrc32instructions
2018-01-1816:56:0910619[Note]InnoDB:Initializingbufferpool,size=128.0M
2018-01-1816:56:0910619[Note]InnoDB:Completedinitializationofbufferpool
2018-01-1816:56:0910619[Note]InnoDB:HighestsupportedfileformatisBarracuda.
2018-01-1816:56:0910619[Note]InnoDB:128rollbacksegment(s)areactive.
2018-01-1816:56:0910619[Note]InnoDB:Waitingforpurgetostart
2018-01-1816:56:0910619[Note]InnoDB:5.6.39started;logsequencenumber1626037
2018-01-1816:56:0910619[ERROR]Aborting
2018-01-1816:56:0910619[Note]Binlogend
2018-01-1816:56:0910619[Note]Shuttingdownplugin'partition'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'BLACKHOLE'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_DATAFILES'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_TABLESPACES'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN_COLS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_FIELDS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_COLUMNS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_INDEXES'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_TABLESTATS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_TABLES'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_INDEX_TABLE'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_INDEX_CACHE'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_CONFIG'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_BEING_DELETED'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_DELETED'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_DEFAULT_STOPWORD'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_METRICS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_BUFFER_POOL_STATS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE_LRU'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX_RESET'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMPMEM_RESET'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMPMEM'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMP_RESET'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMP'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_LOCK_WAITS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_LOCKS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_TRX'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'InnoDB'
2018-01-1816:56:0910619[Note]InnoDB:FTSoptimizethreadexiting.
2018-01-1816:56:0910619[Note]InnoDB:Startingshutdown...
2018-01-1816:56:1110619[Note]InnoDB:Shutdowncompleted;logsequencenumber1626047
2018-01-1816:56:1110619[Note]Shuttingdownplugin'ARCHIVE'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'PERFORMANCE_SCHEMA'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'FEDERATED'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'MRG_MYISAM'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'MEMORY'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'MyISAM'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'CSV'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'sha256_password'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'mysql_old_password'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'mysql_native_password'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'binlog'
2018-01-1816:56:1110619[Note]
bash-x/usr/local/mysql56/bin/mysqld_safe--defaults-file=/mysqldata/node1/my.cnf
调试状态执行
/usr/local/mysql56/bin/mysqld_safe--defaults-file=/mysqldata/node1/my.cnf
2018-01-1816:56:0910619[Note]InnoDB:Usingatomicstorefcountbufferpoolpages
2018-01-1816:56:0910619[Note]InnoDB:TheInnoDBmemoryheapisdisabled
2018-01-1816:56:0910619[Note]InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins
2018-01-1816:56:0910619[Note]InnoDB:Memorybarrierisnotused
2018-01-1816:56:0910619[Note]InnoDB:Compressedtablesusezlib1.2.3
2018-01-1816:56:0910619[Note]InnoDB:UsingLinuxnativeAIO
2018-01-1816:56:0910619[Note]InnoDB:UsingCPUcrc32instructions
2018-01-1816:56:0910619[Note]InnoDB:Initializingbufferpool,size=128.0M
2018-01-1816:56:0910619[Note]InnoDB:Completedinitializationofbufferpool
2018-01-1816:56:0910619[Note]InnoDB:HighestsupportedfileformatisBarracuda.
2018-01-1816:56:0910619[Note]InnoDB:128rollbacksegment(s)areactive.
2018-01-1816:56:0910619[Note]InnoDB:Waitingforpurgetostart
2018-01-1816:56:0910619[Note]InnoDB:5.6.39started;logsequencenumber1626037
2018-01-1816:56:0910619[ERROR]Aborting
2018-01-1816:56:0910619[Note]Binlogend
2018-01-1816:56:0910619[Note]Shuttingdownplugin'partition'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'BLACKHOLE'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_DATAFILES'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_TABLESPACES'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN_COLS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_FIELDS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_COLUMNS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_INDEXES'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_TABLESTATS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_SYS_TABLES'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_INDEX_TABLE'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_INDEX_CACHE'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_CONFIG'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_BEING_DELETED'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_DELETED'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_FT_DEFAULT_STOPWORD'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_METRICS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_BUFFER_POOL_STATS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE_LRU'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX_RESET'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMPMEM_RESET'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMPMEM'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMP_RESET'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_CMP'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_LOCK_WAITS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_LOCKS'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'INNODB_TRX'
2018-01-1816:56:0910619[Note]Shuttingdownplugin'InnoDB'
2018-01-1816:56:0910619[Note]InnoDB:FTSoptimizethreadexiting.
2018-01-1816:56:0910619[Note]InnoDB:Startingshutdown...
2018-01-1816:56:1110619[Note]InnoDB:Shutdowncompleted;logsequencenumber1626047
2018-01-1816:56:1110619[Note]Shuttingdownplugin'ARCHIVE'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'PERFORMANCE_SCHEMA'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'FEDERATED'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'MRG_MYISAM'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'MEMORY'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'MyISAM'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'CSV'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'sha256_password'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'mysql_old_password'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'mysql_native_password'
2018-01-1816:56:1110619[Note]Shuttingdownplugin'binlog'
2018-01-1816:56:1110619[Note]
3 个解决方案
#1
bash-x/usr/local/mysql56/bin/mysqld_safe--defaults-file=/mysqldata/node1/my.cnf
调试状态执行
更多相关文章
- mysql主从同步(4)-Slave延迟状态监控
- PHP MYSQL 出现中文乱码的解决方案
- Amoeba for MySQL---分布式数据库Proxy解决方案
- 如何从表中获取每个id的最新状态?
- MySQL数据库导入或者同步大量数据时数据丢失解决方案
- 关于mysql 和Oracle的一大堆麻烦问题的解决方案
- 为什么我们的查询卡在MySql中的“写入网络”状态?
- 关于mysql无法添加中文数据的问题以及解决方案
- 确定mysql中索引的状态