Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5.36, 10.0(EOL)
-
None
Description
Hi,
mysqlbinlog detects a "Corrupted Binlog" event when manipulating datetime fields with microsecond precision.
SET binlog_format = ROW; |
FLUSH LOGS;
|
CREATE TABLE t1_timestamp (a serial, b timestamp); |
CREATE TABLE t1_timestamp6 (a serial, b timestamp(6)); |
INSERT INTO t1_timestamp VALUES (NULL,NOW(6)); |
INSERT INTO t1_timestamp6 VALUES (NULL,NOW(6)); |
INSERT INTO t1_timestamp VALUES(NULL,NOW(6)); |
And we can now look in the content of the binary log:
mysqlbinlog -vvvv --base64-output=DECODE-ROWS mariadb-bin.000006
# at 832 |
#141216 17:07:06 server id 3 end_log_pos 870 GTID 0-3-271
|
/*!100001 SET @@session.gtid_seq_no=271*//*!*/; |
BEGIN
|
/*!*/; |
# at 870 |
# at 925 |
#141216 17:07:06 server id 3 end_log_pos 925 Table_map: `mariadb`.`t1_timestamp` mapped to number 88 |
#141216 17:07:06 server id 3 end_log_pos 967 Write_rows: table id 88 flags: STMT_END_F |
### INSERT INTO `mariadb`.`t1_timestamp` |
### SET |
### @1=3 /* LONGINT meta=0 nullable=0 is_null=0 */ |
### @2=1418767626 /* TIMESTAMP meta=0 nullable=0 is_null=0 */ |
# at 967 |
#141216 17:07:06 server id 3 end_log_pos 994 Xid = 1465
|
COMMIT/*!*/; |
# at 994 |
#141216 17:07:22 server id 3 end_log_pos 1032 GTID 0-3-272
|
/*!100001 SET @@session.gtid_seq_no=272*//*!*/; |
BEGIN
|
/*!*/; |
# at 1032 |
# at 1088 |
#141216 17:07:22 server id 3 end_log_pos 1088 Table_map: `mariadb`.`t1_timestamp6` mapped to number 89 |
#141216 17:07:22 server id 3 end_log_pos 1133 Write_rows: table id 89 flags: STMT_END_F |
### INSERT INTO `mariadb`.`t1_timestamp6` |
### SET |
### @1=3 /* LONGINT meta=0 nullable=0 is_null=0 */ |
### @2=447582292 /* TIMESTAMP meta=0 nullable=0 is_null=0 */ |
### INSERT INTO `mariadb`.`t1_timestamp6` |
### SET |
### @1=***Corrupted replication event was detected. Not printing the value*** |
# at 1133 |
#141216 17:07:22 server id 3 end_log_pos 1160 Xid = 1466
|
COMMIT/*!*/; |
# at 1160 |
#141216 17:11:24 server id 3 end_log_pos 1198 GTID 0-3-273
|
/*!100001 SET @@session.gtid_seq_no=273*//*!*/; |
BEGIN
|
/*!*/; |
# at 1198 |
# at 1253 |
#141216 17:11:24 server id 3 end_log_pos 1253 Table_map: `mariadb`.`t1_timestamp` mapped to number 88 |
#141216 17:11:24 server id 3 end_log_pos 1295 Write_rows: table id 88 flags: STMT_END_F |
### INSERT INTO `mariadb`.`t1_timestamp` |
### SET |
### @1=4 /* LONGINT meta=0 nullable=0 is_null=0 */ |
### @2=1418767884 /* TIMESTAMP meta=0 nullable=0 is_null=0 */ |
# at 1295 |
#141216 17:11:24 server id 3 end_log_pos 1322 Xid = 1467
|
COMMIT/*!*/; |
DELIMITER ;
|
# End of log file |
 |
Data is replicating and in sync between master/slaves.
Joffrey