Gecko [ www.jdcpatala.org ]

Name	Size	Permission
binlog.test	10.5 KB	-rw-r--r--
binlog_cache_stat.test	13.09 KB	-rw-r--r--
binlog_gtid_mode_permissive_se...	1.07 KB	-rw-r--r--
binlog_gtid_mode_set_gtid_next...	1.92 KB	-rw-r--r--
binlog_gtid_next_xa.inc	5.73 KB	-rw-r--r--
binlog_implicit_commit.inc	1.6 KB	-rw-r--r--
binlog_innodb.inc	3.9 KB	-rw-r--r--
binlog_mysqlbinlog_fill.inc	1.76 KB	-rw-r--r--
binlog_mysqlbinlog_row.inc	12.67 KB	-rw-r--r--
binlog_mysqlbinlog_start_stop....	1.81 KB	-rw-r--r--
binlog_row_kill_create_select....	1.82 KB	-rw-r--r--
binlog_truncate.test	1.6 KB	-rw-r--r--
binlog_xa_prepare_connection.i...	903 B	-rw-r--r--
binlog_xa_prepare_disconnect.i...	1.11 KB	-rw-r--r--
binlog_xa_prepared.test	6.05 KB	-rw-r--r--
binlog_xa_prepared_do_and_rest...	9.59 KB	-rw-r--r--
blackhole.test	5.67 KB	-rw-r--r--
ctype_cp932.test	27.77 KB	-rw-r--r--
ctype_cp932_binlog.test	1.25 KB	-rw-r--r--
ctype_ucs_binlog.test	684 B	-rw-r--r--
database.test	2.78 KB	-rw-r--r--
drop_table.test	619 B	-rw-r--r--
drop_temp_table.test	7.9 KB	-rw-r--r--
enforce_gtid_consistency.test	5.4 KB	-rw-r--r--
enforce_gtid_consistency_creat...	2.96 KB	-rw-r--r--
enforce_gtid_consistency_creat...	3.53 KB	-rw-r--r--
enforce_gtid_consistency_state...	9.6 KB	-rw-r--r--
enforce_gtid_consistency_tmp_c...	3.77 KB	-rw-r--r--
enforce_gtid_consistency_tmp_v...	3.35 KB	-rw-r--r--
enforce_gtid_consistency_trx_n...	5.46 KB	-rw-r--r--
enforce_gtid_consistency_trx_n...	3.39 KB	-rw-r--r--
gtid_next_begin_caused_trx.tes...	3.11 KB	-rw-r--r--
gtid_next_single_stmt_trx_roll...	11.01 KB	-rw-r--r--
gtid_next_single_stmt_trx_roll...	10.92 KB	-rw-r--r--
gtid_next_xa.test	3.65 KB	-rw-r--r--
gtid_next_xa_error_simul.test	8.37 KB	-rw-r--r--
implicit.test	567 B	-rw-r--r--
insert_select-binlog.test	1.03 KB	-rw-r--r--
logical_timestamping.inc	5.4 KB	-rw-r--r--
mix_innodb_myisam_binlog.test	15.98 KB	-rw-r--r--
mix_innodb_myisam_side_effects...	6.47 KB	-rw-r--r--
mysqlbinlog_rewrite_db.test	3.47 KB	-rw-r--r--
mysqlbinlog_row_engine.inc	43.86 KB	-rw-r--r--
mysqlbinlog_start_stop_1.inc	1.71 KB	-rw-r--r--
mysqlbinlog_start_stop_2.inc	1.19 KB	-rw-r--r--

Code Editor : binlog_xa_prepared.test

#
# The test verifies prepared XA transaction behaviour.
#
# The prepared XA transactions can be disconnected from the client,
# discovered from another connection and commited or rolled back
# later. They also survive the server restart.  The test runs two
# loops each consisting of prepared XA:s generation, their
# manipulation and a server restart followed with survived XA:s
# completion.
#

#
# Prepared XA can't get available to an external connection
# until connection that either leaves actively or is killed
# has completed a necessary part of its cleanup.
# Selecting from P_S.threads provides a method to learn that.
#
--source include/have_perfschema.inc
--source include/gtid_utils.inc

# Total number of connection each performing one insert into table
--let $conn_number=20
# Number of rollbacks and commits from either side of the server restart
--let $rollback_number=5
--let $commit_number=5
# Number of transaction that are terminated before server restarts
--let $term_number=`SELECT $rollback_number + $commit_number`
# Instead of disconnect make some connections killed when their
# transactions got prepared.
--let $killed_number=5
# make some connections disconnected by shutdown rather than actively
--let $server_disconn_number=5
--let $prepared_at_server_restart = `SELECT $conn_number - $term_number`
# number a "warmup" connection after server restart, they all commit
--let $post_restart_conn_number=10

# Counter to be used in GTID consistency check.
# It's incremented per each non-XA transaction commit, including DDL calls and
# also by any DML  quieries like CALL mtr.add_suppression() that are added to
# the top level file of this test.
--let $not_xa_trans_committed = 0
# Local to this file variable to control one-phase commit loop
--let $one_phase_number = 5

--connection default

# Remove possibly preceeding binlogs and clear initialization time
# GTID executed info. In the following all transactions are counted
# to conduct verification at the end of the test.
if (`SELECT @@global.log_bin`)
{
  RESET MASTER;
}

# Disconected and follower threads need synchronization
--inc $not_xa_trans_committed
CREATE VIEW v_processlist  as SELECT * FROM performance_schema.threads where type = 'FOREGROUND';

--inc $not_xa_trans_committed
--eval call mtr.add_suppression("Found $prepared_at_server_restart prepared XA transactions")
# Caused by bug#79416 fixes, see below.
--inc $not_xa_trans_committed
call mtr.add_suppression("Found 1 prepared XA transactions");

--inc $not_xa_trans_committed
CREATE TABLE t (a INT) ENGINE=innodb;

# Counter is incremented at the end of post restart to
# reflect number of loops done in correctness computation.
--let $restart_number = 0
--let $how_to_restart=restart_mysqld.inc
--source extra/binlog_tests/binlog_xa_prepared_do_and_restart.inc

--let $how_to_restart=kill_and_restart_mysqld.inc
--source extra/binlog_tests/binlog_xa_prepared_do_and_restart.inc

--connection default

# Few xs that commit in one phase, not subject to the server restart
# nor reconnect.
# This piece of test is related to mysqlbinlog recovery examine below.
--let $k = 0
while ($k < $one_phase_number)
{
    --eval XA START   'one_phase_trx_$k'
    --eval INSERT INTO t SET a=$k
    --eval XA END     'one_phase_trx_$k'
    --eval XA COMMIT  'one_phase_trx_$k' ONE PHASE

--inc $k
}

--inc $not_xa_trans_committed
DROP TABLE t;
--inc $not_xa_trans_committed
DROP VIEW v_processlist;

if (`SELECT @@global.log_bin`)
{
  # Recording proper samples of binlogged prepared XA:s
  --source include/show_binlog_events.inc
}

# Multiplier 2 captures the XA two phase binlogging property
--let $gno = `SELECT $not_xa_trans_committed + 2*$restart_number*($conn_number + $post_restart_conn_number) + $one_phase_number`

# Check GTID consistency
# Tests that run wo/ log_bin on and source this file
# can't compute gtid_executed-based assert.
if (`SELECT @@global.gtid_mode = 'ON' and @@global.log_bin = 1`)
{
  --let $lhs = `SELECT GTID_COUNT(@@global.gtid_executed)`
  --let $rhs = $gno
  --let $assert_text = committed gno $gno
  --let $assert_cond = $lhs = $rhs
  --source include/assert.inc
}

if (`SELECT @@global.gtid_mode = 'OFF' or @@global.log_bin = 0`)
{
  # To make this test run regardless GTID mode
  --let $rhs = `SELECT '1-$gno'`
  --let $lhs = $rhs
  --let $assert_text = committed gno $gno
  --let $assert_cond = $lhs = $rhs
  --source include/assert.inc
}

if (`SELECT @@global.log_bin = 1`)
{
  --let $MYSQLD_DATADIR=`SELECT @@datadir`
  --exec $MYSQL_BINLOG -R --to-last-log master-bin.000001 > $MYSQLTEST_VARDIR/tmp/mysqlbinlog.sql
  RESET MASTER;

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/mysqlbinlog.sql

if (`SELECT @@global.gtid_mode = 'ON' and @@global.log_bin = 1`)
  {
    --let $lhs = `SELECT GTID_COUNT(@@global.gtid_executed)`
    --let $rhs = $gno
    --let $assert_text = committed gno $gno
    --let $assert_cond = $lhs = $rhs
    --source include/assert.inc
  }
  if (`SELECT @@global.gtid_mode = 'OFF' or @@global.log_bin = 0`)
  {
    --let $rhs = `SELECT '1-$gno'`
    --let $lhs = $rhs
    --let $assert_text = committed gno $gno
    --let $assert_cond = $lhs = $rhs
    --source include/assert.inc
}

--remove_file $MYSQLTEST_VARDIR/tmp/mysqlbinlog.sql
}
--echo All transactions must be completed, to empty-list the following:
XA RECOVER;

# bug#79416 INNODB: FAILING ASSERTION: TOTAL_TRX >= TRX_SYS->N_PREPARED_TRX
# Fixes' prove in that there must be no innodb assert at the server shutdown
--connect (conn_bug79146, 127.0.0.1,root,,test,$MASTER_MYPORT,)
CREATE TABLE t(a INT);
XA START 'xa1';
INSERT INTO t SET a = 1;
XA END 'xa1';
--error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
SET @@SESSION.pseudo_slave_mode=1;
XA PREPARE 'xa1';

--connection default
--source include/restart_mysqld.inc

XA ROLLBACK 'xa1';

# bug78695 ASSERTION `STATIC_CAST<SQL_CMD_XA_COMMIT*>(THD->LEX->M_SQL_CMD)-> GET_XA_OPT()
# Fixes' prove in that there must be no assert at the xa commit
XA START 'xa1';
INSERT INTO t SET a = 1;
XA END 'xa1';
XA PREPARE 'xa1';
--error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
SET @@SESSION.pseudo_slave_mode=1;
XA COMMIT 'xa1';

DROP TABLE t;

--source include/gtid_utils_end.inc

${this.title}

Code Editor : binlog_xa_prepared.test