⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
binlog
/
r
/
View File Name :
binlog_xa_modify_gtid_executed_explicitly.result
CREATE TABLE t1 (a INT); # # Verify that inserting gtid into mysql.gtid_executed table # explicitly by a XA transaction causes an error. # XA START '1'; INSERT INTO t1 VALUES(1); INSERT INTO mysql.gtid_executed VALUES("aaaaaaaa-aaaa-aaaa-aaaa-bug#21452916", 1, 1); ERROR HY000: Please do not modify the gtid_executed table with an XA transaction. This is an internal system table used to store GTIDs for committed transactions. Although modifying it can lead to an inconsistent GTID state, if neccessary you can modify it with a non-XA transaction. XA END '1'; XA PREPARE '1'; XA COMMIT '1'; FLUSH LOGS; # # Verify that users can not insert gtid into mysql.gtid_executed # table explicitly by a XA transaction. # include/assert.inc [Table mysql.gtid_executed must not contain row with source_uuid=aaaaaaaa-aaaa-aaaa-aaaa-bug#21452916] # # Verify that updating mysql.gtid_executed table # explicitly by a XA transaction causes an error. # XA START '1'; INSERT INTO t1 VALUES(2); UPDATE mysql.gtid_executed SET source_uuid = "aaaaaaaa-aaaa-aaaa-aaaa-bug#21452916" WHERE source_uuid = '$master_uuid'; ERROR HY000: Please do not modify the gtid_executed table with an XA transaction. This is an internal system table used to store GTIDs for committed transactions. Although modifying it can lead to an inconsistent GTID state, if neccessary you can modify it with a non-XA transaction. XA END '1'; XA PREPARE '1'; XA COMMIT '1'; # # Verify that users can not update mysql.gtid_executed # table explicitly by a XA transaction. # include/assert.inc [Table mysql.gtid_executed must not contain row with source_uuid=aaaaaaaa-aaaa-aaaa-aaaa-bug#21452916] # # Verify that deleting from mysql.gtid_executed table # explicitly by a XA transaction causes an error. # XA START '1'; INSERT INTO t1 VALUES(3); DELETE FROM mysql.gtid_executed WHERE source_uuid = '$master_uuid'; ERROR HY000: Please do not modify the gtid_executed table with an XA transaction. This is an internal system table used to store GTIDs for committed transactions. Although modifying it can lead to an inconsistent GTID state, if neccessary you can modify it with a non-XA transaction. XA END '1'; XA PREPARE '1'; XA COMMIT '1'; # # Verify that users can not delete from mysql.gtid_executed # table explicitly by a XA transaction. # include/assert.inc [Table mysql.gtid_executed must contain GTID(s) with source_uuid = master_uuid] DROP TABLE t1;