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


相关文章
|
存储 SQL 人工智能
01-PostgreSQL 存储过程的基本介绍以及入门(基本结构、声明和赋值、控制结构)(下)
01-PostgreSQL 存储过程的基本介绍以及入门(基本结构、声明和赋值、控制结构)
|
数据可视化 Java 数据库
28个案例问题分析---20---内存长期占用导致系统慢--jvm调优
28个案例问题分析---20---内存长期占用导致系统慢--jvm调优
633 0
|
关系型数据库 MySQL 数据库
MySQL 启动日志报错: File /mysql-bin.index not found (Errcode: 13 - Permission denied)
MySQL 启动日志报错: File /mysql-bin.index not found (Errcode: 13 - Permission denied)
1138 2
|
存储 Ubuntu jenkins
CI/CD 工具比较:Jenkins、GitLab CI、Buildbot、Drone 和 Concourse
CI/CD 工具比较:Jenkins、GitLab CI、Buildbot、Drone 和 Concourse
1212 0
|
XML Java 数据库连接
IDEA插件-MyBatisX
MybatisX 是一款用于 IntelliJ IDEA 的插件,旨在帮助开发者更便捷地进行 MyBatis XML 配置文件的编写和调试。它提供了许多功能和工具,以简化 MyBatis 开发流程。
2519 0
IDEA插件-MyBatisX
|
存储 SQL 关系型数据库
01-PostgreSQL 存储过程的基本介绍以及入门(基本结构、声明和赋值、控制结构)(上)
01-PostgreSQL 存储过程的基本介绍以及入门(基本结构、声明和赋值、控制结构)
|
SQL JSON NoSQL
阿里云DTS踩坑经验分享系列|链路内ETL使用手册
DTS是一个数据迁移和同步服务,通常用于数据搬迁或实时数据传输。DTS在数据同步链路基础上,提供流式数据ETL数据处理功能,支持使用DSL(Domain Specific Language)脚本语言灵活地定义数据处理逻辑。
95150 3
|
存储 Java 测试技术
四十五图,一万五千字!一文让你走出迷雾玩转Maven!
Maven应该是大家的老熟客了,身为Java程序员,几乎每天都会跟他打交道。
444 0
|
存储 Prometheus Kubernetes
使用loki和grafana展示ingress-nginx的日志
使用loki和grafana展示ingress-nginx的日志
使用loki和grafana展示ingress-nginx的日志