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*/; |
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Labels | need_feedback |
Attachment | mysql-bin.000018 [ 42397 ] | |
Attachment | mysql-bin.000019 [ 42398 ] | |
Attachment | mysql-bin.000020 [ 42399 ] |
Attachment | my.cnf [ 42400 ] |
Labels | need_feedback |
Labels | need_feedback |
Labels | need_feedback |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Component/s | Character Sets [ 10801 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Affects Version/s | 5.5 [ 15800 ] | |
Affects Version/s | 10.0 [ 16000 ] | |
Affects Version/s | 10.1 [ 16100 ] | |
Affects Version/s | 10.1.12 [ 21502 ] | |
Assignee | Alexander Barkov [ bar ] |
Assignee | Alexander Barkov [ bar ] |
Assignee | Vesa Pentti [ pentve ] |
Sprint | 10.1.29 [ 202 ] |
Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
Assignee | Vesa Pentti [ pentve ] | Alexander Barkov [ bar ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Assignee | Alexander Barkov [ bar ] | Vesa Pentti [ pentve ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Assignee | Vesa Pentti [ pentve ] | Alexander Barkov [ bar ] |
Status | Stalled [ 10000 ] | In Review [ 10002 ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Assignee | Alexander Barkov [ bar ] | Vesa Pentti [ pentve ] |
issue.field.resolutiondate | 2017-11-06 13:02:47.0 | 2017-11-06 13:02:47.719 |
Fix Version/s | 10.1.29 [ 22636 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 76891 ] | MariaDB v4 [ 150858 ] |
Zendesk Related Tickets | 105770 |