| Server IP : 104.21.38.3 / Your IP : 162.158.108.166 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/rpl/t/ |
Upload File : |
# ==== Purpose ==== # # Verify that on slave server, appropriate XA_STATE is reported in Performance # Schema tables for XA transactions. # # ==== Implementation ==== # # 1) On Master start one XA transaction named 'xatest' and set the state to # 'PREPARED'. # 2) On slave wait till the applier thread applies the 'XA PREPARE' statement. # 3) Verify that the XA_STATE is reported as 'PREPARED' in performance schema # table. # 4) On Master COMMIT the XA transaction. # 5) On slave verify that the XA_STATE is reported as 'COMMITTED' # # ==== References ==== # # Bug#25940184: P_S TRANSACTION INSTRUMENTATION DOES NOT WORK PROPERLY FOR # XA ON SLAVE --source include/have_slave_repository_type_file.inc --source include/have_perfschema.inc # Test script is independent of binlog format. --source include/have_binlog_format_mixed.inc # Separate test script exists for gtid enabled scenario named # rpl_gtid_perfschema_applier_xa_status.test --source include/not_gtid_enabled.inc --source include/master-slave.inc --echo #################################################################### --echo # Test Case 1: Simple MASTER-SLAVE setup. --echo # Verify that slave displays appropriate XA_STATE in performance --echo # schema table, post XA PREPARE AND XA COMMIT command execution. --echo #################################################################### --source extra/rpl_tests/rpl_perfschema_applier_xa_status.test --source include/rpl_reset.inc --echo #################################################################### --echo # Test Case 2: Enable Multithreaded Slave with slave_parallel_type as --echo # DATABASE. Verify that slave displays appropriate XA_STATE in --echo # performance schema table, post XA PREPARE AND XA COMMIT command --echo # execution. --echo #################################################################### --source include/rpl_connection_slave.inc # Save existing settings. SET @save_slave_parallel_workers=@@global.slave_parallel_workers; SET @slave_parallel_type=@@global.slave_parallel_type; # Enable MTS --source include/stop_slave.inc SET GLOBAL slave_parallel_workers=4; SET GLOBAL slave_parallel_type='DATABASE'; --source include/start_slave.inc # Verify --source extra/rpl_tests/rpl_perfschema_applier_xa_status.test # Cleanup --source include/rpl_reset.inc --echo #################################################################### --echo # Test Case 3: Enable Multithreaded Slave with slave_parallel_type as --echo # LOGICAL_CLOCK. Verify that slave displays appropriate XA_STATE in --echo # performance schema table, post XA PREPARE AND XA COMMIT command --echo # execution. --echo #################################################################### # Enable MTS --source include/stop_slave.inc SET GLOBAL slave_parallel_workers=4; SET GLOBAL slave_parallel_type='LOGICAL_CLOCK'; --source include/start_slave.inc # Verify --source extra/rpl_tests/rpl_perfschema_applier_xa_status.test --source include/rpl_connection_slave.inc # Cleanup --source include/stop_slave.inc set @@global.slave_parallel_workers= @save_slave_parallel_workers; set @@global.slave_parallel_type= @slave_parallel_type; --source include/start_slave.inc --source include/rpl_end.inc