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_gtid_next_xa.result

call mtr.add_suppression("The transaction owned GTID is already in the gtid_executed table");
CALL mtr.add_suppression("Statement is unsafe because it is being used inside a XA transaction");
include/rpl_init.inc [topology=none]
include/rpl_default_connections.inc
call mtr.add_suppression("Found 1 prepared XA transactions");
include/rpl_set_gtid_mode.inc [ON_PERMISSIVE on servers 1]
CREATE TABLE t1 (a INT);
---- XID 1, COMMIT: AUTOMATIC + AUTOMATIC ----
[connection master]
SET GTID_NEXT= 'AUTOMATIC';
XA START '1';
INSERT INTO t1 VALUES(1);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '1';
XA PREPARE '1';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'AUTOMATIC';
XA COMMIT '1' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 2, COMMIT: AUTOMATIC + aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2 ----
[connection master]
SET GTID_NEXT= 'AUTOMATIC';
XA START '2';
INSERT INTO t1 VALUES(2);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '2';
XA PREPARE '2';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
XA COMMIT '2' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 3, COMMIT: AUTOMATIC + ANONYMOUS ----
[connection master]
SET GTID_NEXT= 'AUTOMATIC';
XA START '3';
INSERT INTO t1 VALUES(3);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '3';
XA PREPARE '3';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'ANONYMOUS';
XA COMMIT '3' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 4, COMMIT: AUTOMATIC + none ----
[connection master]
SET GTID_NEXT= 'AUTOMATIC';
XA START '4';
INSERT INTO t1 VALUES(4);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '4';
XA PREPARE '4';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
XA COMMIT '4' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 5, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5 + AUTOMATIC ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5';
XA START '5';
INSERT INTO t1 VALUES(5);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '5';
XA PREPARE '5';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'AUTOMATIC';
XA COMMIT '5' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 6, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:6 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:6 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:6';
XA START '6';
INSERT INTO t1 VALUES(6);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '6';
XA PREPARE '6';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:6';
XA COMMIT '6' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 7, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:7 + ANONYMOUS ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:7';
XA START '7';
INSERT INTO t1 VALUES(7);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '7';
XA PREPARE '7';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'ANONYMOUS';
XA COMMIT '7' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 8, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:8 + none ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:8';
XA START '8';
INSERT INTO t1 VALUES(8);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '8';
XA PREPARE '8';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=1837
XA COMMIT '8';
ERROR HY000: When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:8'.
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
SET GTID_NEXT = 'AUTOMATIC';
XA COMMIT '8' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 9, COMMIT: ANONYMOUS + AUTOMATIC ----
[connection master]
SET GTID_NEXT= 'ANONYMOUS';
XA START '9';
INSERT INTO t1 VALUES(9);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '9';
XA PREPARE '9';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'AUTOMATIC';
XA COMMIT '9' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 10, COMMIT: ANONYMOUS + aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10 ----
[connection master]
SET GTID_NEXT= 'ANONYMOUS';
XA START '10';
INSERT INTO t1 VALUES(10);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '10';
XA PREPARE '10';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10';
XA COMMIT '10' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 11, COMMIT: ANONYMOUS + ANONYMOUS ----
[connection master]
SET GTID_NEXT= 'ANONYMOUS';
XA START '11';
INSERT INTO t1 VALUES(11);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '11';
XA PREPARE '11';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'ANONYMOUS';
XA COMMIT '11' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 12, COMMIT: ANONYMOUS + none ----
[connection master]
SET GTID_NEXT= 'ANONYMOUS';
XA START '12';
INSERT INTO t1 VALUES(12);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '12';
XA PREPARE '12';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
XA COMMIT '12' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 13, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:13 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:13 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:13';
XA START '13';
INSERT INTO t1 VALUES(13);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '13';
XA COMMIT '13' one phase;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
SET @@SESSION.innodb_lock_wait_timeout = 1;
---- XID 14, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:14 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:14 ----
[connection master]
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:14';
XA START '14';
INSERT INTO t1 VALUES(14);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '14';
SET @@SESSION.debug = "+d,simulate_xa_rm_error";
XA COMMIT '14' one phase;
ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
SET @@SESSION.debug = "-d,simulate_xa_rm_error";
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
SET GTID_NEXT = 'AUTOMATIC';
SET @@SESSION.innodb_lock_wait_timeout = 1;
---- XID 15, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:15 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:15 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:15';
SET @@SESSION.debug = "+d,simulate_xa_failure_prepare";
XA START '15';
INSERT INTO t1 VALUES(15);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '15';
XA PREPARE '15';
ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
[connection master]
SHOW WARNINGS;
Level	Code	Message
Error	1402	XA_RBROLLBACK: Transaction branch was rolled back
SET @@SESSION.debug = "-d,simulate_xa_failure_prepare";
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:15';
XA COMMIT '15' ;
ERROR XAE04: XAER_NOTA: Unknown XID
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
SET GTID_NEXT = 'AUTOMATIC';
SET @@SESSION.innodb_lock_wait_timeout = 1;
---- XID 16, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:16 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:16 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:16';
XA START '16';
INSERT INTO t1 VALUES(16);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '16';
XA PREPARE '16';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:16';
SET @@SESSION.debug = "+d,simulate_xa_rm_error";
XA COMMIT '16' ;
ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
SET @@SESSION.debug = "-d,simulate_xa_rm_error";
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
SET GTID_NEXT = 'AUTOMATIC';
SET @@SESSION.innodb_lock_wait_timeout = 1;
---- XID 17, COMMIT: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:17 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:17 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:17';
XA START '17';
INSERT INTO t1 VALUES(17);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '17';
XA PREPARE '17';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
include/rpl_restart_server.inc [server_number=1]
include/rpl_set_gtid_mode.inc [ON_PERMISSIVE on servers 1]
[connection master]
SET @@SESSION.innodb_lock_wait_timeout = 1;
SELECT count(*) as one FROM mysql.gtid_executed WHERE source_uuid = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa' AND interval_start = 17 AND interval_end = 17;
one
0
SELECT count(*) FROM mysql.gtid_executed FOR UPDATE;
count(*)
7
Warnings:
Warning	3129	Please do not modify the gtid_executed table. This is a mysql internal system table to store GTIDs for committed transactions. Modifying it can lead to an inconsistent GTID state.
[connection master]
error=
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:17';
SET @@SESSION.debug = "+d,simulate_xa_rm_error";
XA COMMIT '17' ;
ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
SET @@SESSION.debug = "-d,simulate_xa_rm_error";
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 18, ROLLBACK: AUTOMATIC + AUTOMATIC ----
[connection master]
SET GTID_NEXT= 'AUTOMATIC';
XA START '18';
INSERT INTO t1 VALUES(18);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '18';
XA PREPARE '18';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'AUTOMATIC';
XA ROLLBACK '18' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 19, ROLLBACK: AUTOMATIC + aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:19 ----
[connection master]
SET GTID_NEXT= 'AUTOMATIC';
XA START '19';
INSERT INTO t1 VALUES(19);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '19';
XA PREPARE '19';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:19';
XA ROLLBACK '19' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 20, ROLLBACK: AUTOMATIC + ANONYMOUS ----
[connection master]
SET GTID_NEXT= 'AUTOMATIC';
XA START '20';
INSERT INTO t1 VALUES(20);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '20';
XA PREPARE '20';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'ANONYMOUS';
XA ROLLBACK '20' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 21, ROLLBACK: AUTOMATIC + none ----
[connection master]
SET GTID_NEXT= 'AUTOMATIC';
XA START '21';
INSERT INTO t1 VALUES(21);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '21';
XA PREPARE '21';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
XA ROLLBACK '21' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 22, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:22 + AUTOMATIC ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:22';
XA START '22';
INSERT INTO t1 VALUES(22);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '22';
XA PREPARE '22';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'AUTOMATIC';
XA ROLLBACK '22' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 23, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:23 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:23 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:23';
XA START '23';
INSERT INTO t1 VALUES(23);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '23';
XA PREPARE '23';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:23';
XA ROLLBACK '23' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 24, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:24 + ANONYMOUS ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:24';
XA START '24';
INSERT INTO t1 VALUES(24);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '24';
XA PREPARE '24';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'ANONYMOUS';
XA ROLLBACK '24' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 25, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:25 + none ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:25';
XA START '25';
INSERT INTO t1 VALUES(25);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '25';
XA PREPARE '25';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=1837
XA ROLLBACK '25';
ERROR HY000: When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:25'.
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
SET GTID_NEXT = 'AUTOMATIC';
XA ROLLBACK '25' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 26, ROLLBACK: ANONYMOUS + AUTOMATIC ----
[connection master]
SET GTID_NEXT= 'ANONYMOUS';
XA START '26';
INSERT INTO t1 VALUES(26);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '26';
XA PREPARE '26';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'AUTOMATIC';
XA ROLLBACK '26' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 27, ROLLBACK: ANONYMOUS + aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:27 ----
[connection master]
SET GTID_NEXT= 'ANONYMOUS';
XA START '27';
INSERT INTO t1 VALUES(27);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '27';
XA PREPARE '27';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:27';
XA ROLLBACK '27' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 28, ROLLBACK: ANONYMOUS + ANONYMOUS ----
[connection master]
SET GTID_NEXT= 'ANONYMOUS';
XA START '28';
INSERT INTO t1 VALUES(28);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '28';
XA PREPARE '28';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
SET GTID_NEXT= 'ANONYMOUS';
XA ROLLBACK '28' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 29, ROLLBACK: ANONYMOUS + none ----
[connection master]
SET GTID_NEXT= 'ANONYMOUS';
XA START '29';
INSERT INTO t1 VALUES(29);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '29';
XA PREPARE '29';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=0
XA ROLLBACK '29' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
---- XID 30, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:30 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:30 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:30';
XA START '30';
INSERT INTO t1 VALUES(30);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '30';
XA ROLLBACK '30' ;
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';
SET @@SESSION.innodb_lock_wait_timeout = 1;
---- XID 31, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:31 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:31 ----
[connection master]
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:31';
XA START '31';
INSERT INTO t1 VALUES(31);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '31';
SET @@SESSION.debug = "+d,simulate_xa_rm_error";
XA ROLLBACK '31' ;
ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
SET @@SESSION.debug = "-d,simulate_xa_rm_error";
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
SET GTID_NEXT = 'AUTOMATIC';
SET @@SESSION.innodb_lock_wait_timeout = 1;
---- XID 32, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:32 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:32 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:32';
SET @@SESSION.debug = "+d,simulate_xa_failure_prepare";
XA START '32';
INSERT INTO t1 VALUES(32);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '32';
XA PREPARE '32';
ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
[connection master]
SHOW WARNINGS;
Level	Code	Message
Error	1402	XA_RBROLLBACK: Transaction branch was rolled back
SET @@SESSION.debug = "-d,simulate_xa_failure_prepare";
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:32';
XA ROLLBACK '32' ;
ERROR XAE04: XAER_NOTA: Unknown XID
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
SET GTID_NEXT = 'AUTOMATIC';
SET @@SESSION.innodb_lock_wait_timeout = 1;
---- XID 33, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:33 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:33 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:33';
XA START '33';
INSERT INTO t1 VALUES(33);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '33';
XA PREPARE '33';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
[connection master]
error=
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:33';
SET @@SESSION.debug = "+d,simulate_xa_rm_error";
XA ROLLBACK '33' ;
ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
SET @@SESSION.debug = "-d,simulate_xa_rm_error";
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
SET GTID_NEXT = 'AUTOMATIC';
SET @@SESSION.innodb_lock_wait_timeout = 1;
---- XID 34, ROLLBACK: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:34 + bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:34 ----
[connection master]
SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:34';
XA START '34';
INSERT INTO t1 VALUES(34);
Warnings:
Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on slaves when replicated using statements.
XA END '34';
XA PREPARE '34';
include/assert.inc [Thread should not own any GTID.]
[connection master1]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
include/rpl_restart_server.inc [server_number=1]
include/rpl_set_gtid_mode.inc [ON_PERMISSIVE on servers 1]
[connection master]
SET @@SESSION.innodb_lock_wait_timeout = 1;
SELECT count(*) as one FROM mysql.gtid_executed WHERE source_uuid = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa' AND interval_start = 34 AND interval_end = 34;
one
0
SELECT count(*) FROM mysql.gtid_executed FOR UPDATE;
count(*)
17
Warnings:
Warning	3129	Please do not modify the gtid_executed table. This is a mysql internal system table to store GTIDs for committed transactions. Modifying it can lead to an inconsistent GTID state.
[connection master]
error=
SET GTID_NEXT= 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:34';
SET @@SESSION.debug = "+d,simulate_xa_rm_error";
XA ROLLBACK '34' ;
ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
SET @@SESSION.debug = "-d,simulate_xa_rm_error";
include/assert.inc [Thread should not own any GTID.]
include/assert.inc [No thread should own any GTID.]
include/assert.inc [No thread should hold anonymous ownership.]
ROLLBACK;
SET @@SESSION.innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
SET GTID_NEXT = 'AUTOMATIC';
DROP TABLE t1;
include/rpl_set_gtid_mode.inc [OFF on servers 1]
include/rpl_end.inc

${this.title}

Code Editor : binlog_gtid_next_xa.result