救急~mysql无法启动，显示[ERROR] Aborting无其他原因。

jiebijian7581 2018-01-18 05:25:33
搞了一个下午，百度查不到，求帮助！！

/usr/local/mysql56/bin/mysqld_safe --defaults-file=/mysqldata/node1/my.cnf






2018-01-18 16:56:09 10619 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-01-18 16:56:09 10619 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-18 16:56:09 10619 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-18 16:56:09 10619 [Note] InnoDB: Memory barrier is not used
2018-01-18 16:56:09 10619 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-01-18 16:56:09 10619 [Note] InnoDB: Using Linux native AIO
2018-01-18 16:56:09 10619 [Note] InnoDB: Using CPU crc32 instructions
2018-01-18 16:56:09 10619 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-01-18 16:56:09 10619 [Note] InnoDB: Completed initialization of buffer pool
2018-01-18 16:56:09 10619 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-18 16:56:09 10619 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-18 16:56:09 10619 [Note] InnoDB: Waiting for purge to start
2018-01-18 16:56:09 10619 [Note] InnoDB: 5.6.39 started; log sequence number 1626037
2018-01-18 16:56:09 10619 [ERROR] Aborting

2018-01-18 16:56:09 10619 [Note] Binlog end
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'partition'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'BLACKHOLE'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_METRICS'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_CMP'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'INNODB_TRX'
2018-01-18 16:56:09 10619 [Note] Shutting down plugin 'InnoDB'
2018-01-18 16:56:09 10619 [Note] InnoDB: FTS optimize thread exiting.
2018-01-18 16:56:09 10619 [Note] InnoDB: Starting shutdown...
2018-01-18 16:56:11 10619 [Note] InnoDB: Shutdown completed; log sequence number 1626047
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'ARCHIVE'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'FEDERATED'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'MRG_MYISAM'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'MEMORY'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'MyISAM'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'CSV'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'sha256_password'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'mysql_old_password'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'mysql_native_password'
2018-01-18 16:56:11 10619 [Note] Shutting down plugin 'binlog'
2018-01-18 16:56:11 10619 [Note]
...全文
7759 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
传说之心 2018-01-20
  • 打赏
  • 举报
 回复
查看windows应用日志，八成是你my.cnf里面有一些配置不是你配置的默认存储引擎的配置
kampoo 2018-01-19
  • 打赏
  • 举报
 回复
遇到这种情况，先排查my.cnf文件中的配置项是不是正确。可以通过逐个注释掉可疑选项，逐次重启进行验证。以前遇到过这种情况，修改错误的配置项后启动正常。
rucypli 2018-01-18
  • 打赏
  • 举报
 回复
bash -x /usr/local/mysql56/bin/mysqld_safe --defaults-file=/mysqldata/node1/my.cnf 调试状态执行
mysql5.7.21启动异常的修复方法
一同事反馈有一MySQL实例因为断电之后，启动不了。用了innodb_force_recovery=6也无效，于是前往查看。 排查过程： 最早的启动信息里面，没有任何报错，只有一行[ERROR] Aborting提示，如下： 接着同事用了innodb_force_recovery＝6的方式，才多出现了如下的错误提示，但仍无法启动成功，这个时候，我才决定去看个究竟。 过滤启动日志，grep ERROR /data/mysql/3306/mysql_run.err 可以看到，全部报错主要如下： MySQL大多数不能启动的原因，都是系统数据库的原因，看来这个也不例外。 尝试使用带–skip-g
[hadoop] ERROR: but there is no HDFS_NAMENODE_USER defined. Aborting operation. Starting datanodes
在启动hadoop后，查看jps时看不到应该启动起来的东西 其中一个问题是报but there is no HDFS_NAMENODE_USER defined. Aborting operation. Starting datanodes 直接解决 在Hadoop安装目录下找到sbin文件夹 在里面修改四个文件 1、对于start-dfs.sh和stop-dfs.sh文件，添加下列参数： #!/usr/bin/env bash HDFS_DATANODE_USER=root HADOOP_SECURE_DN_USER=hdfs HDFS_NAMENODE_USER=root HDFS_SEC
解决Mysql5.7.17在windows下安装启动时提示不成功问题
主要介绍了解决Mysql5.7.17在windows下安装启动时提示不成功问题,需要的朋友可以参考下
MYSQL无法启动提示： Default storage engine (InnoDB) is not available的解决方法
在my.ini(linux下/etc/my.cnf)加上skip-innodb，就可以了。 我这样设置后，在linux下都没问题，今天在我本机winXP启动MYSQL，提示启动不起来。看下mysql目录的错误日志： 引用 090613 10:15:27 [ERROR] Default storage engine (InnoDB) is not available 090613 10:15:27 [ERROR] Aborting 090613 10:15:27 [Note] C:\www\mysql\bin\mysqld-nt: Shutdown complete 估计是上次加了参数后，一直没
mysql 有关“InnoDB Error ib_logfile0 of different size”错误
1，查看Mysqld（/var/log/mysqld.log）日志，发现以下错误：InnoDB: Error: log file /usr/local/mysql/data/ib_logfile0 is of different size 05242880 bytesInnoDB: than specified in the .cnf file 0 104857600 bytes!030826 1:42:15 Can’t init databases030826 1:42:15 Aborting2，解决办法“If you want to change the number or the siz
MySQL

56,677

社区成员

56,708

社区内容

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章