AskOverflow.Dev

AskOverflow.Dev Logo AskOverflow.Dev Logo

AskOverflow.Dev Navigation

  • 主页
  • 系统&网络
  • Ubuntu
  • Unix
  • DBA
  • Computer
  • Coding
  • LangChain

Mobile menu

Close
  • 主页
  • 系统&网络
    • 最新
    • 热门
    • 标签
  • Ubuntu
    • 最新
    • 热门
    • 标签
  • Unix
    • 最新
    • 标签
  • DBA
    • 最新
    • 标签
  • Computer
    • 最新
    • 标签
  • Coding
    • 最新
    • 标签
主页 / user-21362

thatidiotguy's questions

Martin Hope
thatidiotguy
Asked: 2013-03-16 12:25:25 +0800 CST

MySQL 5.6 失败

  • 3

RPM_UPGRADE_HISTORY我有以下内容/var/lib/mysql

MySQL RPM upgrade to version 5.6.10-1.linux_glibc2.5
'pre' step running at Fri Mar 15 15:41:26 EDT 2013

ERR file(s):
-rw-r----- 1 mysql root 1725 2013-03-15 13:45 /var/lib/mysql/mysql.err

我检查了错误文件以找到以下信息:

2013-03-15 15:43:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-03-15 15:43:22 11993 [Note] Plugin 'FEDERATED' is disabled.
2013-03-15 15:43:22 11993 [Note] InnoDB: The InnoDB memory heap is disabled
2013-03-15 15:43:22 11993 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-03-15 15:43:22 11993 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-03-15 15:43:22 11993 [Note] InnoDB: CPU does not support crc32 instructions
2013-03-15 15:43:22 11993 [Note] InnoDB: Using Linux native AIO
2013-03-15 15:43:22 11993 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-03-15 15:43:22 11993 [Note] InnoDB: Completed initialization of buffer pool
2013-03-15 15:43:22 11993 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2013-03-15 15:43:22 11993 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2013-03-15 15:43:22 11993 [ERROR] Plugin 'InnoDB' init function returned error.
2013-03-15 15:43:22 11993 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2013-03-15 15:43:22 11993 [ERROR] Unknown/unsupported storage engine: InnoDB
2013-03-15 15:43:22 11993 [ERROR] Aborting

2013-03-15 15:43:22 11993 [Note] Binlog end
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'partition'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'BLACKHOLE'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'ARCHIVE'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_FT_INSERTED'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_METRICS'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_CMP'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'INNODB_TRX'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'MRG_MYISAM'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'MEMORY'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'CSV'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'MyISAM'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'sha256_password'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'mysql_old_password'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'mysql_native_password'
2013-03-15 15:43:22 11993 [Note] Shutting down plugin 'binlog'
2013-03-15 15:43:22 11993 [Note] /usr/sbin/mysqld: Shutdown complete

130315 15:43:22 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended

我在 MySQL 网站上使用 rpm 包安装。什么地方出了错?

mysql mysql-5.6
  • 7 个回答
  • 35318 Views

Sidebar

Stats

  • 问题 205573
  • 回答 270741
  • 最佳答案 135370
  • 用户 68524
  • 热门
  • 回答
  • Marko Smith

    连接到 PostgreSQL 服务器:致命:主机没有 pg_hba.conf 条目

    • 12 个回答
  • Marko Smith

    如何让sqlplus的输出出现在一行中?

    • 3 个回答
  • Marko Smith

    选择具有最大日期或最晚日期的日期

    • 3 个回答
  • Marko Smith

    如何列出 PostgreSQL 中的所有模式?

    • 4 个回答
  • Marko Smith

    列出指定表的所有列

    • 5 个回答
  • Marko Smith

    如何在不修改我自己的 tnsnames.ora 的情况下使用 sqlplus 连接到位于另一台主机上的 Oracle 数据库

    • 4 个回答
  • Marko Smith

    你如何mysqldump特定的表?

    • 4 个回答
  • Marko Smith

    使用 psql 列出数据库权限

    • 10 个回答
  • Marko Smith

    如何从 PostgreSQL 中的选择查询中将值插入表中?

    • 4 个回答
  • Marko Smith

    如何使用 psql 列出所有数据库和表?

    • 7 个回答
  • Martin Hope
    Jin 连接到 PostgreSQL 服务器:致命:主机没有 pg_hba.conf 条目 2014-12-02 02:54:58 +0800 CST
  • Martin Hope
    Stéphane 如何列出 PostgreSQL 中的所有模式? 2013-04-16 11:19:16 +0800 CST
  • Martin Hope
    Mike Walsh 为什么事务日志不断增长或空间不足? 2012-12-05 18:11:22 +0800 CST
  • Martin Hope
    Stephane Rolland 列出指定表的所有列 2012-08-14 04:44:44 +0800 CST
  • Martin Hope
    haxney MySQL 能否合理地对数十亿行执行查询? 2012-07-03 11:36:13 +0800 CST
  • Martin Hope
    qazwsx 如何监控大型 .sql 文件的导入进度? 2012-05-03 08:54:41 +0800 CST
  • Martin Hope
    markdorison 你如何mysqldump特定的表? 2011-12-17 12:39:37 +0800 CST
  • Martin Hope
    Jonas 如何使用 psql 对 SQL 查询进行计时? 2011-06-04 02:22:54 +0800 CST
  • Martin Hope
    Jonas 如何从 PostgreSQL 中的选择查询中将值插入表中? 2011-05-28 00:33:05 +0800 CST
  • Martin Hope
    Jonas 如何使用 psql 列出所有数据库和表? 2011-02-18 00:45:49 +0800 CST

热门标签

sql-server mysql postgresql sql-server-2014 sql-server-2016 oracle sql-server-2008 database-design query-performance sql-server-2017

Explore

  • 主页
  • 问题
    • 最新
    • 热门
  • 标签
  • 帮助

Footer

AskOverflow.Dev

关于我们

  • 关于我们
  • 联系我们

Legal Stuff

  • Privacy Policy

Language

  • Pt
  • Server
  • Unix

© 2023 AskOverflow.DEV All Rights Reserve