我通过binlog恢复一批数据,之后检验发现少了3500条左右,可能有些什么样的原因?

通过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
可能出错的原因是什么?

参与8

1同行回答

liucj2004liucj2004  其它 , undefined
可能和这个报错有关“Field 'apiTypeId' doesn't have a default value”中间是否有变过表结构操作,或者sql_mode取消严格模式显示全部

可能和这个报错有关“Field 'apiTypeId' doesn't have a default value”
中间是否有变过表结构操作,或者sql_mode取消严格模式

收起
农业其它 · 2017-12-21
浏览1687

提问者

煎山药
系统运维工程师北京千眼数合

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2017-12-21
  • 关注会员:2 人
  • 问题浏览:1965
  • 最近回答:2017-12-21
  • X社区推广