Bug #76887 | mysqlbinlog generates 'ROLLBACK' after FD event causing 1782 error | ||
---|---|---|---|
Submitted: | 29 Apr 2015 13:28 | Modified: | 15 Sep 2015 10:34 |
Reporter: | Venkatesh Duggirala | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
Version: | 5.7 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[29 Apr 2015 13:28]
Venkatesh Duggirala
[15 Sep 2015 10:34]
Jon Stephens
Documented fix in the 5.7.9 changelog as follows: mysqlbinlog printed a ROLLBACK at the end of the binary log file, which when played back caused the error -@@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.- This occurred when the binary log file did not include any data related events, or when the relay log file included a Format_description_log_event from the master that had been generated at server startup. The fix for this issue causes a relay log's Format_description_log_event to do nothing if it is applied by a BINLOG statement, and stops a ROLLBACK from setting gtid_next to ANONYMOUS when gtid_next has not yet been determined by a subsequent event. Closed.
[16 Mar 2017 10:58]
kfpanda kf
I found that this bug in 5.7.17 version still exist. This occurred when the binary log file did not include any data related events. # mysqlbinlog mysql-bin.000044|mysql -uroot -p'123456' mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1782 (HY000) at line 19: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON. [Ruby@rds-0314-MySQL-1-1 data]# mysqlbinlog mysql-bin.000044 /*!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 #170316 6:37:43 server id 1 end_log_pos 123 CRC32 0x05a6a067 Start: binlog v 4, server v 5.7.17-log created 170316 6:37:43 BINLOG ' tzLKWA8BAAAAdwAAAHsAAAAAAAQANS43LjE3LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA AWegpgU= '/*!*/; # at 123 #170316 6:37:43 server id 1 end_log_pos 154 CRC32 0xcf1e1690 Previous-GTIDs # [empty] # at 154 #170316 6:42:41 server id 1 end_log_pos 201 CRC32 0x3e145a4c Rotate to mysql-bin.000045 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*/;