mysql数据库表删了重建error_数据库内核月报 － 2015 / 09-MySQL · 捉虫动态 · 建表过程中crash造成重建表失败-阿里云开发者社区...

问题描述

主库的create table语句传到备库，备库SQL线程执行过程中报错：

Error 'Can't create table 'XXX.XX' (errno: -1)' on query. Default database: 'XXX'. Query: 'CREATE TABLE XX ( column_a char(32) NOT NULL, column_b int(10) DEFAULT NULL, column_c int(10) DEFAULT NULL, PRIMARY KEY (column_a), KEY expiry (column_b)) ENGINE=HEAP DEFAULT CHARSET=gbk'

备库 error log：

InnoDB: Error number 17 means 'File exists'.

InnoDB: Some operating system error numbers are described at

InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html

InnoDB: The file already exists though the corresponding table did not

InnoDB: exist in the InnoDB data dictionary. Have you moved InnoDB

InnoDB: .ibd files around without using the SQL commands

InnoDB: DISCARD TABLESPACE and IMPORT TABLESPACE, or did

InnoDB: mysqld cra