I can't replay any of my binlog files even the file have no user events.
Like this:
[lzk@redhat64-26 binlog]$ mysqlbinlog mysql-bin.000018|mysql
|
ERROR 1064 (42000) at line 8: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ';
|
|
|
|
|
|
|
|
DELIMITER ;
|
|
ROLLBACK ;
|
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_T' at line 1
|
[lzk@redhat64-26 binlog]$ mysqlbinlog mysql-bin.000018
|
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
|
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
|
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
|
DELIMITER /*!*/;
|
# at 4
|
#160902 16:25:40 server id 12324 end_log_pos 248 Start: binlog v 4, server v 10.0.12-MariaDB-debug-log created 160902 16:25:40
|
# Warning: this binlog is either in use or was not closed properly.
|
BINLOG '
|
hDfJVw8kMAAA9AAAAPgAAAABAAQAMTAuMC4xMi1NYXJpYURCLWRlYnVnLWxvZwAAAAAAAAAAAAAA
|
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAA3AAEGggAAAAICAgCAAAACgoKAAAAAAAA
|
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
|
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
|
AAAAAAAAAAAEEwQACr8VJg==
|
'/*!*/;
|
# at 248
|
#160902 16:25:40 server id 12324 end_log_pos 303 Gtid list [0-3282660265-4,
|
# 0-12324-354244]
|
# at 303
|
#160902 16:25:40 server id 12324 end_log_pos 342 Binlog checkpoint mysql-bin.000017
|
# at 342
|
#700101 8:00:00 server id 12324 end_log_pos 381 Binlog checkpoint mysql-bin.000018
|
DELIMITER ;
|
# End of log file
|
ROLLBACK /* added by mysqlbinlog */;
|
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
|
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
|