Bug #91646 | xa command still operation when super_read_only is true | ||
---|---|---|---|
Submitted: | 16 Jul 2018 4:40 | Modified: | 16 Jul 2018 6:48 |
Reporter: | Zhenghu Wen (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: XA transactions | Severity: | S2 (Serious) |
Version: | 5.7.22, 8.0.11 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | xa |
[16 Jul 2018 4:40]
Zhenghu Wen
[16 Jul 2018 6:48]
MySQL Verification Team
Hello Zhenghu, Thank you for the report and feedback. Thanks, Umesh
[19 Mar 2019 7:48]
Song Libing
XA ROLLBACK has the same problem. read_only variable has the same problem too. It mainly effects replication slave. --source include/have_binlog_format_row.inc --source include/master-slave.inc --source include/rpl_connection_slave.inc CREATE USER user1; GRANT ALL ON test.* TO user1; SET global read_only = 1; --connect(slave2, 127.0.0.1, user1,, test, $SLAVE_MYPORT) --error 1290 # The MySQL server is running with the --read-only option CREATE TABLE t1(c1 INT); --source include/rpl_connection_master.inc CREATE TABLE t1(c1 INT) ENGINE=InnoDB; XA START "slb"; INSERT INTO t1 values(1); XA END "slb"; XA PREPARE "slb"; sleep 1; #--source include/sync_slave_sql_with_master.inc --source include/rpl_connection_slave.inc SELECT * FROM t1; # XA COMMIT should be refused with error 1290 XA COMMIT "slb"; # XA ROLLBACK "slb"; has same problem SELECT * FROM t1; SHOW BINLOG EVENTS; --source include/rpl_end.inc