开发者社区> 问答> 正文

回滚以前正常运行的系统,还是不成功,咋整啊?求救啊

昨天下午网站挂掉了,不知什么原因
今天重新回滚到前几天的快照,还是不成功,但是实际上前几天网站还是运行很正常的啊,这怎么回事啊。
我的网站才运行了不到一个月,这么快都挂成这样了,我还怎么搞下去啊。
150430 12:38:08 mysqld_safe Starting mysqld daemon with databases from /alidata/server/mysql/data
2015-04-30 12:38:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-04-30 12:38:09 1286 [Note] Plugin 'FEDERATED' is disabled.
2015-04-30 12:38:09 1286 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-30 12:38:09 1286 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-30 12:38:09 1286 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-04-30 12:38:09 1286 [Note] InnoDB: Memory barrier is not used
2015-04-30 12:38:09 1286 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-30 12:38:09 1286 [Note] InnoDB: Using Linux native AIO
2015-04-30 12:38:09 1286 [Note] InnoDB: Using CPU crc32 instructions
2015-04-30 12:38:09 1286 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-04-30 12:38:09 1286 [Note] InnoDB: Completed initialization of buffer pool
2015-04-30 12:38:09 1286 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2015-04-30 12:38:09 1286 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2015-04-30 12:38:09 1286 [Note] InnoDB: Database physically writes the file full: wait...
2015-04-30 12:38:09 1286 [ERROR] InnoDB: Cannot create ./ib_logfile101
2015-04-30 12:38:09 1286 [ERROR] Plugin 'InnoDB' init function returned error.
2015-04-30 12:38:09 1286 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-04-30 12:38:09 1286 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-04-30 12:38:09 1286 [ERROR] Aborting

2015-04-30 12:38:09 1286 [Note] Binlog end
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'partition'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'BLACKHOLE'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_METRICS'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-04-30 12:38:09 1286 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

展开
收起
建站新手 2015-04-30 12:57:40 9044 0
3 条回答
写回答
取消 提交回答
  • 旺旺:nectar2。
    楼主您好,

    好象回滚后,数据库服务找不到这个东东了:

    The first specified data file ./ibdata1 did not exist: a new database to be created!

    祝您早日解决问题。

    -------------------------

    回 4楼(建站新手) 的帖子
    您好,

    得需要看具体的情况,测试喔。

    -------------------------

    回 6楼(建站新手) 的帖子
    您好,

    请参考这里:https://dev.mysql.com/doc/refman/5.0/en/innodb-init.html
    2015-04-30 16:03:43
    赞同 展开评论 打赏
  • Re回滚以前正常运行的系统,还是不成功,咋整啊?求救啊
    也提交了兄弟,哎,我都稍等了好久了。我心是拔凉拔凉的,这以后怎么把网站做大呀。

    -------------------------

    回3楼dongshan8的帖子
    你有方法解决这个问题吗

    -------------------------

    Re回滚以前正常运行的系统,还是不成功,咋整啊?求救啊
    InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!


    即使回滚后,ibdata1不知道什么原因被重新生成了,那肯定里面的数据也没了。但是为什么会被创建呢,太郁闷了
    2015-04-30 15:03:04
    赞同 展开评论 打赏
  • 阿里云ping https://ping.gaomeluo.com/aliyun/
    兄台,提交工单,由官方人员协助一下!
    2015-04-30 13:33:18
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
代码未写,漏洞已出——谈谈设计不当导致的安全问题 立即下载
微信SQLite数据库损坏恢复实践 立即下载
美团 crash 监控分析系统优化之路:crash 率从千分位到万分位 立即下载