Gecko [ www.jdcpatala.org ]

Name	Size	Permission
binlog_anonymous_ownership.res...	15.33 KB	-rw-r--r--
binlog_bug23533.result	486 B	-rw-r--r--
binlog_bug36391.result	143 B	-rw-r--r--
binlog_cache_write_failure.res...	2.4 KB	-rw-r--r--
binlog_check_flush_log_asserti...	595 B	-rw-r--r--
binlog_checksum.result	697 B	-rw-r--r--
binlog_crash_safe_master_check...	1.15 KB	-rw-r--r--
binlog_database.result	9.67 KB	-rw-r--r--
binlog_delete_and_flush_index....	1.73 KB	-rw-r--r--
binlog_dmls_on_tmp_tables_read...	1.88 KB	-rw-r--r--
binlog_drop_if_exists.result	5.35 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	1.09 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	1.76 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	210.68 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	230.58 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	2.26 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	2.69 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	248.24 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	227.62 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	231.98 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	155.86 KB	-rw-r--r--
binlog_error_action.result	7.88 KB	-rw-r--r--
binlog_flush_logs_error.result	477 B	-rw-r--r--
binlog_foreign_key_parent_tabl...	566 B	-rw-r--r--
binlog_format_switch_in_tmp_ta...	2.65 KB	-rw-r--r--
binlog_grant.result	1.51 KB	-rw-r--r--
binlog_grant_alter_user.result	76.65 KB	-rw-r--r--
binlog_group_commit_flush_cras...	912 B	-rw-r--r--
binlog_group_commit_gtid_order...	1.3 KB	-rw-r--r--
binlog_group_commit_indefinite...	499 B	-rw-r--r--
binlog_group_commit_sync_delay...	599 B	-rw-r--r--
binlog_group_commit_sync_delay...	285 B	-rw-r--r--
binlog_group_commit_sync_no_de...	2.16 KB	-rw-r--r--
binlog_gtid_automatic_using_ro...	496 B	-rw-r--r--
binlog_gtid_cache.result	5 B	-rw-r--r--
binlog_gtid_errors.result	9.86 KB	-rw-r--r--
binlog_gtid_exhausted.result	1.26 KB	-rw-r--r--
binlog_gtid_implicit_commit.re...	12.4 KB	-rw-r--r--
binlog_gtid_innodb.result	6.31 KB	-rw-r--r--
binlog_gtid_mix_ok_packet_all_...	1.7 KB	-rw-r--r--
binlog_gtid_mix_response_packe...	3.69 KB	-rw-r--r--
binlog_gtid_mode_set_gtid_next...	10.7 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_row.re...	208.56 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_row_in...	244.07 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_row_my...	245.21 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_start_...	45.14 KB	-rw-r--r--
binlog_gtid_mysqldump.result	657 B	-rw-r--r--
binlog_gtid_next_begin_caused_...	1.4 KB	-rw-r--r--
binlog_gtid_next_partially_fai...	1.31 KB	-rw-r--r--
binlog_gtid_next_partially_fai...	6.7 KB	-rw-r--r--
binlog_gtid_next_single_stmt_t...	9.6 KB	-rw-r--r--
binlog_gtid_next_temporary_tab...	1.1 KB	-rw-r--r--
binlog_gtid_next_xa.result	36.07 KB	-rw-r--r--
binlog_gtid_ps_reprepare.resul...	3.06 KB	-rw-r--r--
binlog_gtid_purge_binlog_at_st...	597 B	-rw-r--r--
binlog_gtid_rbr_only_flag.resu...	1.63 KB	-rw-r--r--
binlog_gtid_reset_consistency_...	586 B	-rw-r--r--
binlog_gtid_row_ctype_ucs.resu...	1.43 KB	-rw-r--r--
binlog_gtid_simple_recovery.re...	1.82 KB	-rw-r--r--
binlog_gtid_state_update_deadl...	625 B	-rw-r--r--
binlog_gtid_stm_ctype_ucs.resu...	1.53 KB	-rw-r--r--
binlog_gtid_unknown_xid.result	1.21 KB	-rw-r--r--
binlog_gtid_utils.result	13.28 KB	-rw-r--r--
binlog_gtids_table_gcov.result	1.72 KB	-rw-r--r--
binlog_implicit_commit.result	12.4 KB	-rw-r--r--
binlog_incident.result	497 B	-rw-r--r--
binlog_incident_ignore.result	497 B	-rw-r--r--
binlog_index.result	11.61 KB	-rw-r--r--
binlog_innodb.result	6.31 KB	-rw-r--r--
binlog_innodb_row.result	3.12 KB	-rw-r--r--
binlog_killed.result	3.74 KB	-rw-r--r--
binlog_killed_simulate.result	1.19 KB	-rw-r--r--
binlog_max_extension.result	424 B	-rw-r--r--
binlog_max_flush_queue_time_wa...	189 B	-rw-r--r--
binlog_mixed_cache_stat.result	3.2 KB	-rw-r--r--
binlog_mixed_load_data.result	420 B	-rw-r--r--
binlog_mts_logical_clock.resul...	2.92 KB	-rw-r--r--
binlog_mts_logical_clock_gtid....	1.72 KB	-rw-r--r--
binlog_mysqlbinlog-cp932.resul...	358 B	-rw-r--r--
binlog_mysqlbinlog_base64.resu...	1.71 KB	-rw-r--r--
binlog_mysqlbinlog_concat.resu...	488 B	-rw-r--r--
binlog_mysqlbinlog_filter.resu...	1.48 KB	-rw-r--r--
binlog_mysqlbinlog_intvar.resu...	752 B	-rw-r--r--
binlog_mysqlbinlog_raw.result	832 B	-rw-r--r--
binlog_mysqlbinlog_rewrite_db....	1.8 KB	-rw-r--r--
binlog_mysqlbinlog_row.result	211.92 KB	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	244.36 KB	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	245.49 KB	-rw-r--r--
binlog_mysqlbinlog_row_trans.r...	17.45 KB	-rw-r--r--
binlog_mysqlbinlog_start_stop....	45.18 KB	-rw-r--r--
binlog_mysqlbinlog_start_stop_...	4.07 KB	-rw-r--r--
binlog_nogtid_mix_response_pac...	1.14 KB	-rw-r--r--
binlog_noop_dml_with_readonly....	1.35 KB	-rw-r--r--
binlog_old_versions.result	1.03 KB	-rw-r--r--
binlog_purge_binary_logs_stall...	236 B	-rw-r--r--
binlog_purge_binary_logs_to.re...	309 B	-rw-r--r--
binlog_query_filter_rules.resu...	187 B	-rw-r--r--
binlog_rbr_only_savepoint.resu...	202 B	-rw-r--r--
binlog_reset_connection_not_re...	611 B	-rw-r--r--
binlog_reset_master.result	14 B	-rw-r--r--
binlog_rewrite.result	10.15 KB	-rw-r--r--
binlog_rewrite_db_noleak.resul...	932 B	-rw-r--r--
binlog_rewrite_order.result	4.35 KB	-rw-r--r--
binlog_rewrite_suppress_use.re...	828 B	-rw-r--r--
binlog_rotate_bgc_sync.result	1.54 KB	-rw-r--r--
binlog_rotate_deadlock.result	852 B	-rw-r--r--
binlog_row_binlog.result	39.5 KB	-rw-r--r--
binlog_row_cache_stat.result	3.2 KB	-rw-r--r--
binlog_row_create_select_crash...	446 B	-rw-r--r--
binlog_row_ctype_cp932.result	87.58 KB	-rw-r--r--
binlog_row_ctype_ucs.result	1.43 KB	-rw-r--r--
binlog_row_delete_all_rows.res...	869 B	-rw-r--r--
binlog_row_drop_tbl.result	567 B	-rw-r--r--
binlog_row_drop_tmp_tbl.result	4.86 KB	-rw-r--r--
binlog_row_insert_select.resul...	809 B	-rw-r--r--
binlog_row_kill_create_select....	1.21 KB	-rw-r--r--
binlog_row_mix_innodb_myisam.r...	30.51 KB	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	1.5 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	2.84 KB	-rw-r--r--
binlog_row_query_log_events.re...	442 B	-rw-r--r--
binlog_server_id.result	459 B	-rw-r--r--
binlog_server_start_options.re...	49 B	-rw-r--r--
binlog_set_gtid_mode_ongoing_t...	8.01 KB	-rw-r--r--
binlog_set_trans_dependency_de...	1.29 KB	-rw-r--r--
binlog_sf.result	1.67 KB	-rw-r--r--
binlog_shutdown_hang.result	406 B	-rw-r--r--
binlog_simulate_crash_and_erro...	2.44 KB	-rw-r--r--
binlog_spurious_ddl_errors.res...	2.97 KB	-rw-r--r--
binlog_sql_mode.result	3.69 KB	-rw-r--r--
binlog_start_comment.result	371 B	-rw-r--r--
binlog_start_slave_heartbeat.r...	259 B	-rw-r--r--
binlog_stm_binlog.result	37.96 KB	-rw-r--r--
binlog_stm_blackhole.result	7.78 KB	-rw-r--r--
binlog_stm_cache_stat.result	3.2 KB	-rw-r--r--
binlog_stm_ctype_cp932.result	87.58 KB	-rw-r--r--
binlog_stm_ctype_ucs.result	1.53 KB	-rw-r--r--
binlog_stm_delete_all_rows.res...	873 B	-rw-r--r--
binlog_stm_do_db.result	2.82 KB	-rw-r--r--
binlog_stm_drop_tbl.result	513 B	-rw-r--r--
binlog_stm_drop_tmp_tbl.result	7.11 KB	-rw-r--r--
binlog_stm_insert_select.resul...	762 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.r...	36.05 KB	-rw-r--r--
binlog_stm_ps.result	1.16 KB	-rw-r--r--
binlog_stm_row.result	3.07 KB	-rw-r--r--
binlog_stm_unsafe_warning.resu...	4.8 KB	-rw-r--r--
binlog_stm_user_variables.resu...	5.38 KB	-rw-r--r--
binlog_switch_inside_trans.res...	7.97 KB	-rw-r--r--
binlog_temporary_tables_user_v...	124 B	-rw-r--r--
binlog_tmp_table.result	905 B	-rw-r--r--
binlog_transaction_dependency_...	3.2 KB	-rw-r--r--
binlog_transaction_dependency_...	1.56 KB	-rw-r--r--
binlog_transaction_write_set_s...	1.08 KB	-rw-r--r--
binlog_transaction_write_set_s...	448 B	-rw-r--r--
binlog_transaction_write_set_s...	351 B	-rw-r--r--
binlog_transaction_write_set_s...	1.51 KB	-rw-r--r--
binlog_truncate_kill.result	1.23 KB	-rw-r--r--
binlog_truncate_myisam.result	2.97 KB	-rw-r--r--
binlog_trx_empty_assertions.re...	884 B	-rw-r--r--
binlog_unsafe.result	190.13 KB	-rw-r--r--
binlog_unsafe_stmt_capable_eng...	215.37 KB	-rw-r--r--
binlog_use_gtid_skip.result	311 B	-rw-r--r--
binlog_user_if_exists.result	14.76 KB	-rw-r--r--
binlog_variables_log_bin.resul...	319 B	-rw-r--r--
binlog_variables_log_bin_index...	313 B	-rw-r--r--
binlog_variables_log_statement...	1.03 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	245 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	2.2 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	237 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	590 B	-rw-r--r--
binlog_write_error.result	2.8 KB	-rw-r--r--
binlog_writeset_history_protec...	671 B	-rw-r--r--
binlog_wrong_last_committed.re...	574 B	-rw-r--r--
binlog_xa_handling.result	1.49 KB	-rw-r--r--
binlog_xa_modify_gtid_executed...	2.35 KB	-rw-r--r--
binlog_xa_prepare_failure.resu...	1.05 KB	-rw-r--r--
binlog_xa_prepared_disconnect....	26.74 KB	-rw-r--r--
binlog_xa_rollback_failure.res...	588 B	-rw-r--r--
binlog_xa_select_gtid_executed...	863 B	-rw-r--r--
binlog_xa_trx_gtid_response_pa...	666 B	-rw-r--r--
binlog_xa_trx_split_across_bin...	1016 B	-rw-r--r--
log_builtin_as_identified_by_p...	7.11 KB	-rw-r--r--
show_binlog_events_no_lock.res...	324 B	-rw-r--r--

Code Editor : binlog_xa_prepared_disconnect.result

CALL mtr.add_suppression("Statement is unsafe because it is being used inside a XA transaction");
include/gtid_utils.inc
RESET MASTER;
CREATE VIEW v_processlist  as SELECT * FROM performance_schema.threads where type = 'FOREGROUND';
call mtr.add_suppression("Found 10 prepared XA transactions");
call mtr.add_suppression("Found 1 prepared XA transactions");
CREATE TABLE t (a INT) ENGINE=innodb;
SET @@sql_log_bin = OFF;
CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
XA START   'trx1tmp';
INSERT INTO tmp1 SET a=1;
XA END     'trx1tmp';
XA PREPARE 'trx1tmp';
SET @@sql_log_bin = OFF;
CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
XA START   'trx2tmp';
INSERT INTO tmp1 SET a=1;
XA END     'trx2tmp';
XA PREPARE 'trx2tmp';
SET @@sql_log_bin = OFF;
CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
XA START   'trx3tmp';
INSERT INTO tmp1 SET a=1;
XA END     'trx3tmp';
XA PREPARE 'trx3tmp';
XA COMMIT 'trx1tmp';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx1tmp';
ERROR XAE04: XAER_NOTA: Unknown XID
XA START 'trx1tmp';
ERROR XAE08: XAER_DUPID: The XID already exists
*** 3 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA COMMIT 'trx1tmp';
KILL connection CONN_ID;
XA COMMIT 'trx3tmp';
XA START   'trx1ro1';
SELECT * from t ORDER BY a;
XA END     'trx1ro1';
XA PREPARE 'trx1ro1';
XA START   'trx2ro1';
SELECT * from t ORDER BY a;
XA END     'trx2ro1';
XA PREPARE 'trx2ro1';
XA START   'trx3ro1';
SELECT * from t ORDER BY a;
XA END     'trx3ro1';
XA PREPARE 'trx3ro1';
*** 4 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA COMMIT 'trx1ro1';
KILL connection CONN_ID;
XA COMMIT 'trx3ro1';
XA START   'trx1ro2';
SELECT * from t ORDER BY a;
XA END     'trx1ro2';
XA PREPARE 'trx1ro2';
XA START   'trx2ro2';
SELECT * from t ORDER BY a;
XA END     'trx2ro2';
XA PREPARE 'trx2ro2';
XA START   'trx3ro2';
SELECT * from t ORDER BY a;
XA END     'trx3ro2';
XA PREPARE 'trx3ro2';
*** 5 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA ROLLBACK 'trx1ro2';
KILL connection CONN_ID;
XA ROLLBACK 'trx3ro2';
XA START   'trx1empty1';
XA END     'trx1empty1';
XA PREPARE 'trx1empty1';
XA START   'trx2empty1';
XA END     'trx2empty1';
XA PREPARE 'trx2empty1';
XA START   'trx3empty1';
XA END     'trx3empty1';
XA PREPARE 'trx3empty1';
*** 6 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA COMMIT 'trx1empty1';
KILL connection CONN_ID;
XA COMMIT 'trx3empty1';
XA START   'trx1empty2';
XA END     'trx1empty2';
XA PREPARE 'trx1empty2';
XA START   'trx2empty2';
XA END     'trx2empty2';
XA PREPARE 'trx2empty2';
XA START   'trx3empty2';
XA END     'trx3empty2';
XA PREPARE 'trx3empty2';
*** 7 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA ROLLBACK 'trx1empty2';
KILL connection CONN_ID;
XA ROLLBACK 'trx3empty2';
XA START   'trx1unprepared';
INSERT INTO t set a=0;
XA END     'trx1unprepared';
INSERT INTO t set a=0;
ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state
XA START 'trx1unprepared';
ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state
XA START 'trx1unprepared';
ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state
XA COMMIT 'trx1unprepared';
ERROR XAE04: XAER_NOTA: Unknown XID
SET @@binlog_format = STATEMENT;
XA START   'trx_0';
INSERT INTO t SET a=0;
XA END     'trx_0';
XA PREPARE 'trx_0';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_1';
INSERT INTO t SET a=1;
XA END     'trx_1';
XA PREPARE 'trx_1';
SET @@binlog_format = STATEMENT;
XA START   'trx_2';
INSERT INTO t SET a=2;
XA END     'trx_2';
XA PREPARE 'trx_2';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_3';
INSERT INTO t SET a=3;
XA END     'trx_3';
XA PREPARE 'trx_3';
SET @@binlog_format = STATEMENT;
XA START   'trx_4';
INSERT INTO t SET a=4;
XA END     'trx_4';
XA PREPARE 'trx_4';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_5';
INSERT INTO t SET a=5;
XA END     'trx_5';
XA PREPARE 'trx_5';
SET @@binlog_format = STATEMENT;
XA START   'trx_6';
INSERT INTO t SET a=6;
XA END     'trx_6';
XA PREPARE 'trx_6';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_7';
INSERT INTO t SET a=7;
XA END     'trx_7';
XA PREPARE 'trx_7';
SET @@binlog_format = STATEMENT;
XA START   'trx_8';
INSERT INTO t SET a=8;
XA END     'trx_8';
XA PREPARE 'trx_8';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_9';
INSERT INTO t SET a=9;
XA END     'trx_9';
XA PREPARE 'trx_9';
SET @@binlog_format = STATEMENT;
XA START   'trx_10';
INSERT INTO t SET a=10;
XA END     'trx_10';
XA PREPARE 'trx_10';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_11';
INSERT INTO t SET a=11;
XA END     'trx_11';
XA PREPARE 'trx_11';
SET @@binlog_format = STATEMENT;
XA START   'trx_12';
INSERT INTO t SET a=12;
XA END     'trx_12';
XA PREPARE 'trx_12';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_13';
INSERT INTO t SET a=13;
XA END     'trx_13';
XA PREPARE 'trx_13';
SET @@binlog_format = STATEMENT;
XA START   'trx_14';
INSERT INTO t SET a=14;
XA END     'trx_14';
XA PREPARE 'trx_14';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_15';
INSERT INTO t SET a=15;
XA END     'trx_15';
XA PREPARE 'trx_15';
KILL CONNECTION CONN_ID;
SET @@binlog_format = STATEMENT;
XA START   'trx_16';
INSERT INTO t SET a=16;
XA END     'trx_16';
XA PREPARE 'trx_16';
KILL CONNECTION CONN_ID;
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_17';
INSERT INTO t SET a=17;
XA END     'trx_17';
XA PREPARE 'trx_17';
KILL CONNECTION CONN_ID;
SET @@binlog_format = STATEMENT;
XA START   'trx_18';
INSERT INTO t SET a=18;
XA END     'trx_18';
XA PREPARE 'trx_18';
KILL CONNECTION CONN_ID;
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_19';
INSERT INTO t SET a=19;
XA END     'trx_19';
XA PREPARE 'trx_19';
KILL CONNECTION CONN_ID;
XA ROLLBACK 'trx_0';
XA ROLLBACK 'trx_1';
XA ROLLBACK 'trx_2';
XA ROLLBACK 'trx_3';
XA ROLLBACK 'trx_4';
XA COMMIT 'trx_5';
XA COMMIT 'trx_6';
XA COMMIT 'trx_7';
XA COMMIT 'trx_8';
XA COMMIT 'trx_9';
# restart
XA START   'new_trx_0';
INSERT INTO t SET a=0;
XA END     'new_trx_0';
XA PREPARE 'new_trx_0';
XA START   'new_trx_1';
INSERT INTO t SET a=1;
XA END     'new_trx_1';
XA PREPARE 'new_trx_1';
XA START   'new_trx_2';
INSERT INTO t SET a=2;
XA END     'new_trx_2';
XA PREPARE 'new_trx_2';
XA START   'new_trx_3';
INSERT INTO t SET a=3;
XA END     'new_trx_3';
XA PREPARE 'new_trx_3';
XA START   'new_trx_4';
INSERT INTO t SET a=4;
XA END     'new_trx_4';
XA PREPARE 'new_trx_4';
XA START   'new_trx_5';
INSERT INTO t SET a=5;
XA END     'new_trx_5';
XA PREPARE 'new_trx_5';
XA START   'new_trx_6';
INSERT INTO t SET a=6;
XA END     'new_trx_6';
XA PREPARE 'new_trx_6';
XA START   'new_trx_7';
INSERT INTO t SET a=7;
XA END     'new_trx_7';
XA PREPARE 'new_trx_7';
XA START   'new_trx_8';
INSERT INTO t SET a=8;
XA END     'new_trx_8';
XA PREPARE 'new_trx_8';
XA START   'new_trx_9';
INSERT INTO t SET a=9;
XA END     'new_trx_9';
XA PREPARE 'new_trx_9';
XA COMMIT  'new_trx_0';
XA COMMIT  'new_trx_1';
XA COMMIT  'new_trx_2';
XA COMMIT  'new_trx_3';
XA COMMIT  'new_trx_4';
XA COMMIT  'new_trx_5';
XA COMMIT  'new_trx_6';
XA COMMIT  'new_trx_7';
XA COMMIT  'new_trx_8';
XA COMMIT  'new_trx_9';
XA START 'trx_10';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_10';
XA START 'trx_11';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_11';
XA START 'trx_12';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_12';
XA START 'trx_13';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_13';
XA START 'trx_14';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_14';
XA START 'trx_15';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_15';
XA START 'trx_16';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_16';
XA START 'trx_17';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_17';
XA START 'trx_18';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_18';
XA START 'trx_19';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_19';
SELECT * FROM t;
a
5
6
7
8
9
10
11
12
13
14
0
1
2
3
4
5
6
7
8
9
XA ROLLBACK 'trx_20';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_19';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_18';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_17';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_16';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_15';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_14';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_13';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_12';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_11';
ERROR XAE04: XAER_NOTA: Unknown XID
SET @@sql_log_bin = OFF;
CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
XA START   'trx1tmp';
INSERT INTO tmp1 SET a=1;
XA END     'trx1tmp';
XA PREPARE 'trx1tmp';
SET @@sql_log_bin = OFF;
CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
XA START   'trx2tmp';
INSERT INTO tmp1 SET a=1;
XA END     'trx2tmp';
XA PREPARE 'trx2tmp';
SET @@sql_log_bin = OFF;
CREATE TEMPORARY TABLE tmp1 (a int) ENGINE=innodb;
XA START   'trx3tmp';
INSERT INTO tmp1 SET a=1;
XA END     'trx3tmp';
XA PREPARE 'trx3tmp';
XA COMMIT 'trx1tmp';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx1tmp';
ERROR XAE04: XAER_NOTA: Unknown XID
XA START 'trx1tmp';
ERROR XAE08: XAER_DUPID: The XID already exists
*** 3 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA COMMIT 'trx1tmp';
KILL connection CONN_ID;
XA COMMIT 'trx3tmp';
XA START   'trx1ro1';
SELECT * from t ORDER BY a;
XA END     'trx1ro1';
XA PREPARE 'trx1ro1';
XA START   'trx2ro1';
SELECT * from t ORDER BY a;
XA END     'trx2ro1';
XA PREPARE 'trx2ro1';
XA START   'trx3ro1';
SELECT * from t ORDER BY a;
XA END     'trx3ro1';
XA PREPARE 'trx3ro1';
*** 4 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA COMMIT 'trx1ro1';
KILL connection CONN_ID;
XA COMMIT 'trx3ro1';
XA START   'trx1ro2';
SELECT * from t ORDER BY a;
XA END     'trx1ro2';
XA PREPARE 'trx1ro2';
XA START   'trx2ro2';
SELECT * from t ORDER BY a;
XA END     'trx2ro2';
XA PREPARE 'trx2ro2';
XA START   'trx3ro2';
SELECT * from t ORDER BY a;
XA END     'trx3ro2';
XA PREPARE 'trx3ro2';
*** 5 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA ROLLBACK 'trx1ro2';
KILL connection CONN_ID;
XA ROLLBACK 'trx3ro2';
XA START   'trx1empty1';
XA END     'trx1empty1';
XA PREPARE 'trx1empty1';
XA START   'trx2empty1';
XA END     'trx2empty1';
XA PREPARE 'trx2empty1';
XA START   'trx3empty1';
XA END     'trx3empty1';
XA PREPARE 'trx3empty1';
*** 6 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA COMMIT 'trx1empty1';
KILL connection CONN_ID;
XA COMMIT 'trx3empty1';
XA START   'trx1empty2';
XA END     'trx1empty2';
XA PREPARE 'trx1empty2';
XA START   'trx2empty2';
XA END     'trx2empty2';
XA PREPARE 'trx2empty2';
XA START   'trx3empty2';
XA END     'trx3empty2';
XA PREPARE 'trx3empty2';
*** 7 prepared transactions must be in the list ***
XA RECOVER;
formatID	gtrid_length	bqual_length	data
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
1	LEN1	LEN2	TRX_N
XA ROLLBACK 'trx1empty2';
KILL connection CONN_ID;
XA ROLLBACK 'trx3empty2';
XA START   'trx1unprepared';
INSERT INTO t set a=0;
XA END     'trx1unprepared';
INSERT INTO t set a=0;
ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state
XA START 'trx1unprepared';
ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state
XA START 'trx1unprepared';
ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state
XA COMMIT 'trx1unprepared';
ERROR XAE04: XAER_NOTA: Unknown XID
SET @@binlog_format = STATEMENT;
XA START   'trx_0';
INSERT INTO t SET a=0;
XA END     'trx_0';
XA PREPARE 'trx_0';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_1';
INSERT INTO t SET a=1;
XA END     'trx_1';
XA PREPARE 'trx_1';
SET @@binlog_format = STATEMENT;
XA START   'trx_2';
INSERT INTO t SET a=2;
XA END     'trx_2';
XA PREPARE 'trx_2';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_3';
INSERT INTO t SET a=3;
XA END     'trx_3';
XA PREPARE 'trx_3';
SET @@binlog_format = STATEMENT;
XA START   'trx_4';
INSERT INTO t SET a=4;
XA END     'trx_4';
XA PREPARE 'trx_4';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_5';
INSERT INTO t SET a=5;
XA END     'trx_5';
XA PREPARE 'trx_5';
SET @@binlog_format = STATEMENT;
XA START   'trx_6';
INSERT INTO t SET a=6;
XA END     'trx_6';
XA PREPARE 'trx_6';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_7';
INSERT INTO t SET a=7;
XA END     'trx_7';
XA PREPARE 'trx_7';
SET @@binlog_format = STATEMENT;
XA START   'trx_8';
INSERT INTO t SET a=8;
XA END     'trx_8';
XA PREPARE 'trx_8';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_9';
INSERT INTO t SET a=9;
XA END     'trx_9';
XA PREPARE 'trx_9';
SET @@binlog_format = STATEMENT;
XA START   'trx_10';
INSERT INTO t SET a=10;
XA END     'trx_10';
XA PREPARE 'trx_10';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_11';
INSERT INTO t SET a=11;
XA END     'trx_11';
XA PREPARE 'trx_11';
SET @@binlog_format = STATEMENT;
XA START   'trx_12';
INSERT INTO t SET a=12;
XA END     'trx_12';
XA PREPARE 'trx_12';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_13';
INSERT INTO t SET a=13;
XA END     'trx_13';
XA PREPARE 'trx_13';
SET @@binlog_format = STATEMENT;
XA START   'trx_14';
INSERT INTO t SET a=14;
XA END     'trx_14';
XA PREPARE 'trx_14';
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_15';
INSERT INTO t SET a=15;
XA END     'trx_15';
XA PREPARE 'trx_15';
KILL CONNECTION CONN_ID;
SET @@binlog_format = STATEMENT;
XA START   'trx_16';
INSERT INTO t SET a=16;
XA END     'trx_16';
XA PREPARE 'trx_16';
KILL CONNECTION CONN_ID;
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_17';
INSERT INTO t SET a=17;
XA END     'trx_17';
XA PREPARE 'trx_17';
KILL CONNECTION CONN_ID;
SET @@binlog_format = STATEMENT;
XA START   'trx_18';
INSERT INTO t SET a=18;
XA END     'trx_18';
XA PREPARE 'trx_18';
KILL CONNECTION CONN_ID;
SET @@binlog_format = STATEMENT;
SET @@binlog_format = ROW;
XA START   'trx_19';
INSERT INTO t SET a=19;
XA END     'trx_19';
XA PREPARE 'trx_19';
KILL CONNECTION CONN_ID;
XA ROLLBACK 'trx_0';
XA ROLLBACK 'trx_1';
XA ROLLBACK 'trx_2';
XA ROLLBACK 'trx_3';
XA ROLLBACK 'trx_4';
XA COMMIT 'trx_5';
XA COMMIT 'trx_6';
XA COMMIT 'trx_7';
XA COMMIT 'trx_8';
XA COMMIT 'trx_9';
# Kill and restart
XA START   'new_trx_0';
INSERT INTO t SET a=0;
XA END     'new_trx_0';
XA PREPARE 'new_trx_0';
XA START   'new_trx_1';
INSERT INTO t SET a=1;
XA END     'new_trx_1';
XA PREPARE 'new_trx_1';
XA START   'new_trx_2';
INSERT INTO t SET a=2;
XA END     'new_trx_2';
XA PREPARE 'new_trx_2';
XA START   'new_trx_3';
INSERT INTO t SET a=3;
XA END     'new_trx_3';
XA PREPARE 'new_trx_3';
XA START   'new_trx_4';
INSERT INTO t SET a=4;
XA END     'new_trx_4';
XA PREPARE 'new_trx_4';
XA START   'new_trx_5';
INSERT INTO t SET a=5;
XA END     'new_trx_5';
XA PREPARE 'new_trx_5';
XA START   'new_trx_6';
INSERT INTO t SET a=6;
XA END     'new_trx_6';
XA PREPARE 'new_trx_6';
XA START   'new_trx_7';
INSERT INTO t SET a=7;
XA END     'new_trx_7';
XA PREPARE 'new_trx_7';
XA START   'new_trx_8';
INSERT INTO t SET a=8;
XA END     'new_trx_8';
XA PREPARE 'new_trx_8';
XA START   'new_trx_9';
INSERT INTO t SET a=9;
XA END     'new_trx_9';
XA PREPARE 'new_trx_9';
XA COMMIT  'new_trx_0';
XA COMMIT  'new_trx_1';
XA COMMIT  'new_trx_2';
XA COMMIT  'new_trx_3';
XA COMMIT  'new_trx_4';
XA COMMIT  'new_trx_5';
XA COMMIT  'new_trx_6';
XA COMMIT  'new_trx_7';
XA COMMIT  'new_trx_8';
XA COMMIT  'new_trx_9';
XA START 'trx_10';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_10';
XA START 'trx_11';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_11';
XA START 'trx_12';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_12';
XA START 'trx_13';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_13';
XA START 'trx_14';
ERROR XAE08: XAER_DUPID: The XID already exists
XA COMMIT 'trx_14';
XA START 'trx_15';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_15';
XA START 'trx_16';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_16';
XA START 'trx_17';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_17';
XA START 'trx_18';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_18';
XA START 'trx_19';
ERROR XAE08: XAER_DUPID: The XID already exists
XA ROLLBACK 'trx_19';
SELECT * FROM t;
a
5
6
7
8
9
10
11
12
13
14
0
1
2
3
4
5
6
7
8
9
5
6
7
8
9
10
11
12
13
14
0
1
2
3
4
5
6
7
8
9
XA ROLLBACK 'trx_20';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_19';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_18';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_17';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_16';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_15';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_14';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_13';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_12';
ERROR XAE04: XAER_NOTA: Unknown XID
XA ROLLBACK 'trx_11';
ERROR XAE04: XAER_NOTA: Unknown XID
XA START   'one_phase_trx_0';
INSERT INTO t SET a=0;
XA END     'one_phase_trx_0';
XA COMMIT  'one_phase_trx_0' ONE PHASE;
XA START   'one_phase_trx_1';
INSERT INTO t SET a=1;
XA END     'one_phase_trx_1';
XA COMMIT  'one_phase_trx_1' ONE PHASE;
XA START   'one_phase_trx_2';
INSERT INTO t SET a=2;
XA END     'one_phase_trx_2';
XA COMMIT  'one_phase_trx_2' ONE PHASE;
XA START   'one_phase_trx_3';
INSERT INTO t SET a=3;
XA END     'one_phase_trx_3';
XA COMMIT  'one_phase_trx_3' ONE PHASE;
XA START   'one_phase_trx_4';
INSERT INTO t SET a=4;
XA END     'one_phase_trx_4';
XA COMMIT  'one_phase_trx_4' ONE PHASE;
DROP TABLE t;
DROP VIEW v_processlist;
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_processlist` AS SELECT * FROM performance_schema.threads where type = 'FOREGROUND'
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Query	#	#	use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Found 10 prepared XA transactions' COLLATE 'latin1_swedish_ci'))
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Query	#	#	use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Found 1 prepared XA transactions' COLLATE 'latin1_swedish_ci'))
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t (a INT) ENGINE=innodb
master-bin.000001	#	Query	#	#	XA START X'7472785f30',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=0
master-bin.000001	#	Query	#	#	XA END X'7472785f30',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f30',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f31',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f31',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f31',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f32',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=2
master-bin.000001	#	Query	#	#	XA END X'7472785f32',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f32',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f33',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f33',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f33',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f34',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=4
master-bin.000001	#	Query	#	#	XA END X'7472785f34',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f34',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f35',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f35',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f35',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f36',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=6
master-bin.000001	#	Query	#	#	XA END X'7472785f36',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f36',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f37',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f37',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f37',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f38',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=8
master-bin.000001	#	Query	#	#	XA END X'7472785f38',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f38',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f39',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f39',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f39',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3130',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=10
master-bin.000001	#	Query	#	#	XA END X'7472785f3130',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3130',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3131',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f3131',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3131',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3132',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=12
master-bin.000001	#	Query	#	#	XA END X'7472785f3132',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3132',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3133',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f3133',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3133',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3134',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=14
master-bin.000001	#	Query	#	#	XA END X'7472785f3134',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3134',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3135',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f3135',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3135',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3136',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=16
master-bin.000001	#	Query	#	#	XA END X'7472785f3136',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3136',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3137',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f3137',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3137',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3138',X'',1
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t SET a=18
master-bin.000001	#	Query	#	#	XA END X'7472785f3138',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3138',X'',1
master-bin.000001	#	Query	#	#	XA START X'7472785f3139',X'',1
master-bin.000001	#	Table_map	#	#	table_id: # (test.t)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	XA END X'7472785f3139',X'',1
master-bin.000001	#	XA_prepare	#	#	XA PREPARE X'7472785f3139',X'',1
master-bin.000001	#	Query	#	#	XA ROLLBACK X'7472785f30',X'',1
master-bin.000001	#	Query	#	#	XA ROLLBACK X'7472785f31',X'',1
master-bin.000001	#	Query	#	#	XA ROLLBACK X'7472785f32',X'',1
master-bin.000001	#	Query	#	#	XA ROLLBACK X'7472785f33',X'',1
master-bin.000001	#	Query	#	#	XA ROLLBACK X'7472785f34',X'',1
master-bin.000001	#	Query	#	#	XA COMMIT X'7472785f35',X'',1
master-bin.000001	#	Query	#	#	XA COMMIT X'7472785f36',X'',1
master-bin.000001	#	Query	#	#	XA COMMIT X'7472785f37',X'',1
master-bin.000001	#	Query	#	#	XA COMMIT X'7472785f38',X'',1
master-bin.000001	#	Query	#	#	XA COMMIT X'7472785f39',X'',1
master-bin.000001	#	Stop	#	#	
include/assert.inc [committed gno 131]
RESET MASTER;
include/assert.inc [committed gno 131]
All transactions must be completed, to empty-list the following:
XA RECOVER;
formatID	gtrid_length	bqual_length	data
CREATE TABLE t(a INT);
XA START 'xa1';
INSERT INTO t SET a = 1;
XA END 'xa1';
SET @@SESSION.pseudo_slave_mode=1;
ERROR HY000: The system variable pseudo_slave_mode cannot be set when there is an ongoing transaction.
XA PREPARE 'xa1';
# restart
XA ROLLBACK 'xa1';
XA START 'xa1';
INSERT INTO t SET a = 1;
XA END 'xa1';
XA PREPARE 'xa1';
SET @@SESSION.pseudo_slave_mode=1;
ERROR HY000: The system variable pseudo_slave_mode cannot be set when there is an ongoing transaction.
XA COMMIT 'xa1';
DROP TABLE t;
include/gtid_utils_end.inc

${this.title}

Code Editor : binlog_xa_prepared_disconnect.result