Description: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.How to...
Error 1783: @@SESSION.GTID_NEXT_LIST cannot be set to a non-NULL value when @@GLOBAL.GTID_MODE = OFF.
50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; 将反向解析的 binlog 文件语句回放到数据库中。由于所测试的实例中已经开启 gtid 模式,而反向解析出来的 binlog 文件中没有定义SESSION.GTID_NEXT cannot be set to ANONYMOUS whenSESSION.GTID_NEXT='AUTOMATIC' ,这样就可以回放成功了。 [root@10-186-62-22 My...
Error 1782: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON → Comments Comments loading... Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions...