Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
5.5.40, 10.0(EOL)
-
Ubuntu 12.04 64 bit,
3.13.0-40-generic #69~precise1-Ubuntu SMP Fri Nov 14 10:29:31 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
Description
Slave: MariaDB, 5.5.40-tokudb-7.5.3-MariaDB-log MariaDB Server
Master: MySQL, Server version: 5.5.30-ndb-7.2.12-log Source distribution
When the replication is started, it stops with the error:
Last_SQL_Errno: 1594
|
Last_SQL_Error: Relay log read failure: Could not parse relay log event entry....
|
Looking at the binlog file copied from the master, the MariaDB mysqlbinlog says:
mysqlbinlog -vv -H log-bin.000001
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 61, event_type: 30
|
ERROR: Could not read entry at offset 3554: Error in log format or read error.
|
Therefore, mariadb's mysqlbinlog stops before 3554:
SET TIMESTAMP=1417540710/*!*/;
|
BEGIN
|
/*!*/;
|
# at 3248
|
# at 3365
|
# at 3429
|
# at 3492
|
DELIMITER ;
|
# End of log file
|
ROLLBACK /* added by mysqlbinlog */;
|
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
|
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
|
<EOF>
|
Looking at the same file on the master with the MySQL version of mysqlbinlog, I can see the contents with no problem:
SET TIMESTAMP=1417540710/*!*/;
|
BEGIN
|
/*!*/;
|
# at 3248
|
# at 3365
|
# at 3429
|
# at 3492
|
# at 3554
|
# at 3615
|
# at 3944
|
# at 4108
|
# at 4274
|
# at 4339
|
# at 4379
|
# at 4440
|
# at 4480
|
# at 4541
|
# at 4581
|
# at 4777
|
#141202 18:18:30 server id 11901 end_log_pos 3365
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
# cb0 66 f4 7d 54 13 7d 2e 00 00 75 00 00 00 25 0d 00 00 80 00
|
# cc3 f5 00 00 00 00 00 01 00 0e 63 75 64 62 5f 75 73 |.........cudb.us|
|
# cd3 65 72 5f 64 61 74 61 00 07 43 55 44 42 5f 44 4e |er.data..CUDB.DN|
|
# ce3 00 18 0f 0f 0f 0f 0f 0f 0f 0f 0f 0f 0f 0f 0f 0f |................|
|
# cf3 08 0f 01 01 01 07 07 0f 0f 0f 24 f0 00 f0 00 f0 |................|
|
# d03 00 f0 00 f0 00 f0 00 f0 00 f0 00 f0 00 f0 00 f0 |................|
|
# d13 00 f0 00 90 01 58 02 00 06 2d 00 2d 00 2d 00 00 |.....X..........|
|
# d23 20 f8 |..|
|
# Table_map: `cudb_user_data`.`CUDB_DN` mapped to number 245
|
#141202 18:18:30 server id 11901 end_log_pos 3429
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
# d25 66 f4 7d 54 13 7d 2e 00 00 40 00 00 00 65 0d 00 00 80 00
|
# d38 3b 01 00 00 00 00 01 00 0e 63 75 64 62 5f 75 73 |.........cudb.us|
|
# d48 65 72 5f 64 61 74 61 00 0c 43 55 44 42 64 63 4f |er.data..CUDBdcO|
|
# d58 62 6a 65 63 74 00 02 08 0f 02 ff 00 00 |bject........|
|
# Table_map: `cudb_user_data`.`CUDBdcObject` mapped to number 315
|
#141202 18:18:30 server id 11901 end_log_pos 3492
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
# d65 66 f4 7d 54 13 7d 2e 00 00 3f 00 00 00 a4 0d 00 00 80 00
|
# d78 b9 01 00 00 00 00 01 00 0e 63 75 64 62 5f 75 73 |.........cudb.us|
|
# d88 65 72 5f 64 61 74 61 00 0b 43 55 44 42 53 65 72 |er.data..CUDBSer|
|
# d98 76 69 63 65 00 02 08 0f 02 20 00 00 |vice........|
|
# Table_map: `cudb_user_data`.`CUDBService` mapped to number 441
|
#141202 18:18:30 server id 11901 end_log_pos 3554
|