mysqlbinlog -v --base64-output=DECODE-ROWS /var/lib/mysql/h7-relay-bin.000023 end of previous with failed GTID #131014 12:27:46 server id 72 end_log_pos 629122078 CRC32 0xff594284 GTID [commit=yes] SET @@SESSION.GTID_NEXT= '1be2af64-ce18-11e2-bd6e-00151743f04a:5644022'/*!*/; # at 629122288 #131014 12:27:46 server id 72 end_log_pos 629122155 CRC32 0x31413ed3 Query thread_id=2670256 exec_time=0 error_code=0 SET TIMESTAMP=1381742866/*!*/; BEGIN /*!*/; # at 629122365 #131014 12:27:46 server id 72 end_log_pos 629122416 CRC32 0x3966ca34 Table_map: `wa_ua`.`wa_x_uzivatele` mapped to number 3112 # at 629122626 #131014 12:27:46 server id 72 end_log_pos 629130484 CRC32 0xe5c4a150 Delete_rows: table id 3112 # at 629130694 #131014 12:27:46 server id 72 end_log_pos 629138486 CRC32 0xed240178 Delete_rows: table id 3112 # at 629138696 #131014 12:27:46 server id 72 end_log_pos 629146414 CRC32 0xca0ce946 Delete_rows: table id 3112 # at 629146624 #130926 11:15:43 server id 78 end_log_pos 629146677 CRC32 0x01aa4436 Rotate to h7-relay-bin.000024 pos: 4 DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; #EOF mysqlbinlog -v --base64-output=DECODE-ROWS /var/lib/mysql/h7-relay-bin.000024 and next one /*!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 #130926 11:15:43 server id 78 end_log_pos 120 CRC32 0x8318b350 Start: binlog v 4, server v 5.6.14-log created 130926 11:15:43 # at 120 #130926 11:15:43 server id 78 end_log_pos 191 CRC32 0x20900f7d Previous-GTIDs # 1be2af64-ce18-11e2-bd6e-00151743f04a:263628-5644022 # at 191 #131012 19:55:24 server id 72 end_log_pos 0 CRC32 0xc2d46222 Start: binlog v 4, server v 5.6.14-log created 131012 19:55:24 # at 307 #131014 12:27:46 server id 72 end_log_pos 629154467 CRC32 0x16ef4f53 Delete_rows: table id 3112 # at 8360 #131014 12:27:46 server id 72 end_log_pos 629162336 CRC32 0x454bf57a Delete_rows: table id 3112 # at 16229 ... lot of similar rows ... #131014 12:27:46 server id 72 end_log_pos 631344810 CRC32 0xd1a81f7b Delete_rows: table id 3112 flags: STMT_END_F ### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown t able #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3 112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknow n table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unk nown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row eve nt for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112# ## Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown ta ble #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #31 12### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event f or unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### R ow event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unkn own table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row even t for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112## # Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112### Row event for unknown tab ... lot of similar rows ... t for unknown table #3112### Row event for unknown table #3112### Row event for unknown table #3112# at 2198703 #131014 12:27:46 server id 72 end_log_pos 631344888 CRC32 0x83895af0 Query thread_id=2670256 exec_time=1 error_code=0 SET TIMESTAMP=1381742866/*!*/; SET @@session.pseudo_thread_id=2670256/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1073741824/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8 *//*!*/; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; COMMIT /*!*/; # at 2198781 #131014 12:27:47 server id 72 end_log_pos 631344936 CRC32 0x69d001b5 GTID [commit=yes] SET @@SESSION.GTID_NEXT= '1be2af64-ce18-11e2-bd6e-00151743f04a:5644023'/*!*/; # at 2198829 #131014 12:27:47 server id 72 end_log_pos 631345023 CRC32 0xde25cd02 Query thread_id=2670261 exec_time=0 error_code=0 SET TIMESTAMP=1381742867/*!*/; SET @@session.time_zone='+03:00'/*!*/; BEGIN /*!*/; # at 2198916 #131014 12:27:47 server id 72 end_log_pos 631345083 CRC32 0xcf8c725b Table_map: `wa_ua`.`wa_stats` mapped to number 112 # at 2198976 #131014 12:27:47 server id 72 end_log_pos 631345138 CRC32 0x426fce72 Write_rows: table id 112 flags: STMT_END_F ### INSERT INTO `wa_ua`.`wa_stats` ... from this position log loks fine ...