mysql5.7.24的问题

Question

mysql> insert into t values(3,‘ee’,‘bbb’);
Query OK, 1 row affected (0.02 sec)

mysql> delete from t where id = 1;
Query OK, 1 row affected (0.31 sec)

[root@007 data]# mysqlbinlog -vv mysql_bin.000003
为何没有记录执行的操作？

Answer 1

sqlercn 2019-02-15 17:50:53

你这是执行mysqlbinlog报错了。你先flush log后再执行试一下

• 提问者 muke_007 #1

  已经flush logs了,还是不行啊，啥原因呢？

• 提问者 muke_007 #2

  [root@007 data]# mysqlbinlog -vv mysql-bin.000002 |more
  ERROR: /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
  DELIMITER /*!*/;
  # at 4
  Error in Log_event::read_log_event(): 'Sanity check failed', data_len: 31, event_type: 35
  #190215  4:58:01 server id 10  end_log_pos 123  Start: binlog v 4, server v 5.7.24-log 
  created 190215  4:58:01
  # Warning: this binlog is either in use or was not closed properly.
  BINLOG '
  WdZlXA8KAAAAdwAAAHsAAAABAAQANS43LjI0LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
  AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA
  AVeTDHg=
  '/*!*/;
  DELIMITER ;
  # End of log file
  ROLLBACK /* added by mysqlbinlog */;
  /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

• 提问者 muke_007 #3

  问题终于解决了，哎，伤心啊.....

点开查看后面1条评论