1.1061
报错信息:
Error 'Duplicate key name 'member_id'' on query. Default database: 'th_card'. Query: 'ALTER TABLE `th_card`.`member_card` ADD INDEX `member_id` USING BTREE (`member_id`) comment '''
库:`th_card`.`member_card`
表:`th_card`.`member_card`
索引:member_id
解决步骤
1.1.查看
mysql> show index from `th_card`.`member_card`;
1.2.删除索引
mysql> ALTER TABLE `cpn_wolf` DROP INDEX `member_id`;
1.3.重启从库
mysql> stop slave;
mysql> start slave;
mysql> show slave status\G;
解决错误!!
2.1060
2.1 报错信息
Error 'Duplicate column name 'add_balance'' on query. Default database: 'th_card'. Query: 'ALTER TABLE `th_card`.`card_number` ADD COLUMN `add_balance` varchar(255) AFTER `times`'
原因:
slave 上字段重复
解决步骤
2.2 解决
alter table `th_card`.`card_number` drop column add_balance ;
重启主从
解决错误 !!!
3. 1062
3.1报错信息
Error 'Duplicate entry '105' for key 'PRIMARY'' on query. Default database: 'crm'. Query: 'insert into sys_login_log (ip, login_at, login_type, open_id, remark, session_id, user_id) values ('223.104.1.99', '2019-03-25 14:56:40.85', 1, 'oYT4L0TQltFdrsGvZ4T6PhHfmVgE', null, 'c67b7273-b690-4e2a-9071-dd4ba2458ae5', 7)'
3.2 解决方法
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> set global sql_slave_skip_counter=1;
Query OK, 0 rows affected (0.00 sec)
mysql> start slave ;
Query OK, 0 rows affected (0.00 sec)
解决错误
4.1164
4.1 报错信息
Error 'Table 'crm.metadata' doesn't exist' on query. Default database: 'crm'. Query: 'ALTER TABLE `crm`.`metadata` CHANGE COLUMN `name` `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL'
4.2 解决方法
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show create table metadata; #主库
#在从库建表
mysql> start slave ;
Query OK, 0 rows affected (0.00 sec)
解决!!!