Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
None
-
10.1.29
Description
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*/; |