| Server IP : 172.67.216.182 / Your IP : 172.68.164.134 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/binlog/r/ |
Upload File : |
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;