MySQL主从报错

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)

解决！！！