403Webshell
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/binlog/r/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;

Youez - 2016 - github.com/yon3zu
LinuXploit