Error: data file /data/ibdata/ibdata1 is of a different size

简介:

090625 22:42:38 mysqld started
InnoDB: Error: data file /data/ibdata/ibdata1 is of a different size
InnoDB: 65536 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 640 pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
090625 22:42:39 [ERROR] Default storage engine (InnoDB) is not available

解决:把innodb_data_file_path=ibdata1:1G;ibdata2:1G:autoextend设为正确的值

二、Error 'Duplicate entry '807370' for key

090625 22:56:33 [Note] Slave SQL thread initialized, starting replication in log 'fb-bin.000099' at position 152, relay log './fb-re
lay.000403' position: 179125349
090625 22:56:33 [Note] Slave I/O thread: connected to master 'fbrep@slone:3306', replication started in log 'FIRST' at position 4
090625 22:56:35 [ERROR] Slave: Error 'Duplicate entry '807370' for key 1' on query. Default database: 'fb'. Query: 'insert into doin
g (userid, content, dtime) values (700018757, '曛1m~Y′曛1m~\~W', now())', Error_code: 1062
090625 23:00:58 [Note] Slave I/O thread exiting, read up to log 'fb-bin.000007', position 890371603
090625 23:04:23 [Note] Slave SQL thread initialized, starting replication in log 'fb-bin.000099' at position 179125745, relay log '.
/fb-relay.000001' position: 4


本文转自holy2009 51CTO博客,原文链接:http://blog.51cto.com/holy2010/367869


相关文章
|
4月前
|
关系型数据库 MySQL
MySQL 报错 [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file
MySQL 报错 [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file
332 0
|
18天前
|
C#
C# File.Copy介绍
C# File.Copy介绍
|
9月前
|
存储 SQL 缓存
【MySQL】change buffer,buffer pool,redo log,bin log,undo log的作用
【MySQL】change buffer,buffer pool,redo log,bin log,undo log的作用
94 0
E297: Write error in swap file
当我使用vim编辑一个常用的配置文件的时候出现一个错误: E297: Write error in swap file 然后上网查找原因,说是磁盘空间不足,于是我就查看一下机器磁盘空间使用情况: sht-sgmhadoopdn-02:postgres:/usr/loca...
2421 0
|
开发工具
|
开发工具
|
关系型数据库