通过binlog恢复一批数据,之后检验发现少了3500条左右,总共大约20万条左右,一下是操作记录。
[root@qianyan-3 ~]# /usr/local/mariadb-10.1.29/bin/mysqlbinlog /data/mariadb_binlog_master_3306/master-bin.000200 --start-position=308284088 |/usr/local/mariadb-10.1.29/bin/mysql
ERROR 1062 (23000) at line 38: Duplicate entry '17511078' for key 'PRIMARY'
[root@qianyan-3 ~]# /usr/local/mariadb-10.1.29/bin/mysqlbinlog /data/mariadb_binlog_master_3306/master-bin.000200 --start-position=308284126 |/usr/local/mariadb-10.1.29/bin/mysql
ERROR 1062 (23000) at line 30: Duplicate entry '17511078' for key 'PRIMARY'
[root@qianyan-3 ~]# /usr/local/mariadb-10.1.29/bin/mysqlbinlog /data/mariadb_binlog_master_3306/master-bin.000200 --start-position=308284154 |/usr/local/mariadb-10.1.29/bin/mysql
[root@qianyan-3 ~]# /usr/local/mariadb-10.1.29/bin/mysqlbinlog /data/mariadb_binlog_master_3306/master-bin.000201 |/usr/local/mariadb-10.1.29/bin/mysql
ERROR 1364 (HY000) at line 5149481: Field 'apiTypeId' doesn't have a default value
[root@qianyan-3 ~]# /usr/local/mariadb-10.1.29/bin/mysqlbinlog /data/mariadb_binlog_master_3306/master-bin.000201 --start-position=399217621 |/usr/local/mariadb-10.1.29/bin/mysql
ERROR 1364 (HY000) at line 114143: Field 'apiTypeId' doesn't have a default value
You have new mail in /var/spool/mail/root
[root@qianyan-3 ~]# /usr/local/mariadb-10.1.29/bin/mysqlbinlog /data/mariadb_binlog_master_3306/master-bin.000201 --start-position=399217621 |/usr/local/mariadb-10.1.29/bin/mysql
ERROR 1062 (23000) at line 37: Duplicate entry '14' for key 'PRIMARY'
[root@qianyan-3 ~]# /usr/local/mariadb-10.1.29/bin/mysqlbinlog /data/mariadb_binlog_master_3306/master-bin.000201 --start-position=406788325 |/usr/local/mariadb-10.1.29/bin/mysql
ERROR 1062 (23000) at line 7157764: Duplicate entry '17642797' for key 'PRIMARY'
[root@qianyan-3 ~]# /usr/local/mariadb-10.1.29/bin/mysqlbinlog /data/mariadb_binlog_master_3306/master-bin.000201 --start-position= |/usr/local/mariadb-10.1.29/bin/mysql
可能出错的原因是什么?