)]}'
{"trove/guestagent/datastore/mariadb/service.py":[{"author":{"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},"change_message_id":"37851e24554ed092793f84e2356118a442c9ed4c","unresolved":true,"context_lines":[{"line_number":59,"context_line":""},{"line_number":60,"context_line":"    def _get_gtid_slave_executed(self):"},{"line_number":61,"context_line":"        with mysql_util.SqlClient(self.get_engine()) as client:"},{"line_number":62,"context_line":"            return client.execute(\u0027SELECT @@global.gtid_slave_pos\u0027).first()[0]"},{"line_number":63,"context_line":""},{"line_number":64,"context_line":"    def get_last_txn(self):"},{"line_number":65,"context_line":"        master_UUID \u003d self._get_master_UUID()"}],"source_content_type":"text/x-python","patch_set":1,"id":"86607d86_99f46e1a","line":62,"updated":"2020-11-29 08:32:25.000000000","message":"I\u0027m not very clear, according to the doc[1], `This variable (gtid_binlog_pos) is the GTID of the last event group written to the binary log, for each replication domain.`, why it can\u0027t be used to determine the GTID position?\n\n[1]: https://mariadb.com/kb/en/gtid/#gtid_binlog_pos","commit_id":"df82af30f21b89097597bf471c2aa5a08d19386c"},{"author":{"_account_id":31662,"name":"Cong Nguyen Thanh","email":"ntcong1705@gmail.com","username":"congnt95"},"change_message_id":"bd42007ef8945c648be3e16a169e396438dbbf25","unresolved":true,"context_lines":[{"line_number":59,"context_line":""},{"line_number":60,"context_line":"    def _get_gtid_slave_executed(self):"},{"line_number":61,"context_line":"        with mysql_util.SqlClient(self.get_engine()) as client:"},{"line_number":62,"context_line":"            return client.execute(\u0027SELECT @@global.gtid_slave_pos\u0027).first()[0]"},{"line_number":63,"context_line":""},{"line_number":64,"context_line":"    def get_last_txn(self):"},{"line_number":65,"context_line":"        master_UUID \u003d self._get_master_UUID()"}],"source_content_type":"text/x-python","patch_set":1,"id":"cfb29929_317befc4","line":62,"in_reply_to":"86607d86_99f46e1a","updated":"2020-11-30 02:26:47.000000000","message":"Because gtid_binlog_pos contains all events of slave when execute like SET TIMESTAMP [1], so sometime gtid_binlog_pos is change and can\u0027t hit line 70 [2]. We are selecting the latest slave, we just need to compare gtid_slave_pos.\n\n[1]https://imgur.com/6g5y1l3\n[2]https://imgur.com/undefined","commit_id":"df82af30f21b89097597bf471c2aa5a08d19386c"}]}