1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
/* Copyright (c) 2022, 2025, Oracle and/or its affiliates.
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License, version 2.0,
as published by the Free Software Foundation.
This program is designed to work with certain software (including
but not limited to OpenSSL) that is licensed under separate terms,
as designated in a particular file or component or in included license
documentation. The authors of MySQL hereby grant you an additional
permission to link the program and your derivative works with the
separately licensed software that they have either included with
the program or referenced in the documentation.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License, version 2.0, for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
#include "sql/xa/sql_xa_rollback.h" // Sql_cmd_xa_rollback
#include "mysqld_error.h" // Error codes
#include "sql/clone_handler.h" // Clone_handler::XA_Operation
#include "sql/debug_sync.h" // DEBUG_SYNC
#include "sql/handler.h" // commit_owned_gtids
#include "sql/raii/sentry.h" // raii::Sentry<>
#include "sql/rpl_gtid.h" // gtid_state_commit_or_rollback
#include "sql/sql_class.h" // THD
#include "sql/tc_log.h" // tc_log
#include "sql/transaction.h" // trans_reset_one_shot_chistics, trans_track_end_trx
#include "sql/transaction_info.h" // Transaction_ctx
Sql_cmd_xa_rollback::Sql_cmd_xa_rollback(xid_t *xid_arg)
: Sql_cmd_xa_second_phase{xid_arg} {}
enum_sql_command Sql_cmd_xa_rollback::sql_command_code() const {
return SQLCOM_XA_ROLLBACK;
}
bool Sql_cmd_xa_rollback::execute(THD *thd) {
bool st = trans_xa_rollback(thd);
if (!st) {
thd->mdl_context.release_transactional_locks();
/*
We've just done a rollback, reset transaction
isolation level and access mode to the session default.
*/
trans_reset_one_shot_chistics(thd);
my_ok(thd);
}
DBUG_EXECUTE_IF("crash_after_xa_rollback", DBUG_SUICIDE(););
return st;
}
bool Sql_cmd_xa_rollback::trans_xa_rollback(THD *thd) {
auto xid_state = thd->get_transaction()->xid_state();
/* Inform clone handler of XA operation. */
Clone_handler::XA_Operation xa_guard(thd);
if (!xid_state->has_same_xid(this->m_xid)) {
return this->process_detached_xa_rollback(thd);
}
return this->process_attached_xa_rollback(thd);
}
bool Sql_cmd_xa_rollback::process_attached_xa_rollback(THD *thd) const {
DBUG_TRACE;
auto xid_state = thd->get_transaction()->xid_state();
if (xid_state->has_state(XID_STATE::XA_NOTR) ||
xid_state->has_state(XID_STATE::XA_ACTIVE)) {
my_error(ER_XAER_RMFAIL, MYF(0), xid_state->state_name());
return true;
}
/*
Acquire metadata lock which will ensure that XA ROLLBACK is blocked
by active FLUSH TABLES WITH READ LOCK (and vice versa ROLLBACK in
progress blocks FTWRL). This is to avoid binlog and redo entries
while a backup is in progress.
*/
MDL_request mdl_request;
MDL_REQUEST_INIT(&mdl_request, MDL_key::COMMIT, "", "",
MDL_INTENTION_EXCLUSIVE, MDL_STATEMENT);
if (thd->mdl_context.acquire_lock(&mdl_request,
thd->variables.lock_wait_timeout)) {
/*
We can't rollback an XA transaction on lock failure due to
Innodb redo log and bin log update is involved in rollback.
Return error to user for a retry.
*/
my_error(ER_XAER_RMERR, MYF(0));
return true;
}
bool gtid_error = false;
bool need_clear_owned_gtid = false;
std::tie(gtid_error, need_clear_owned_gtid) = commit_owned_gtids(thd, true);
CONDITIONAL_SYNC_POINT_FOR_TIMESTAMP("before_rollback_xa_trx");
bool res = xa_trans_force_rollback(thd) || gtid_error;
gtid_state_commit_or_rollback(thd, need_clear_owned_gtid, !gtid_error);
// todo: report a bug in that the raised rm_error in this branch
// is masked unlike the detached rollback branch above.
DBUG_EXECUTE_IF("simulate_xa_rm_error", {
my_error(ER_XA_RBROLLBACK, MYF(0));
res = true;
});
cleanup_trans_state(thd);
xid_state->set_state(XID_STATE::XA_NOTR);
xid_state->unset_binlogged();
trans_track_end_trx(thd);
/* The transaction should be marked as complete in P_S. */
assert(thd->m_transaction_psi == nullptr);
return res;
}
bool Sql_cmd_xa_rollback::process_detached_xa_rollback(THD *thd) {
DBUG_TRACE;
raii::Sentry<> dispose_guard{[this]() -> void { this->dispose(); }};
if (this->find_and_initialize_xa_context(thd)) return true;
if (this->acquire_locks(thd)) return true;
raii::Sentry<> acquired_locks_guard{
[this]() -> void { this->release_locks(); }};
this->setup_thd_context(thd);
if (this->enter_commit_order(thd)) return true;
CONDITIONAL_SYNC_POINT_FOR_TIMESTAMP("before_rollback_xa_trx");
this->assign_xid_to_thd(thd);
if (tc_log == nullptr) {
this->m_result =
trx_coordinator::rollback_detached_by_xid(thd) || this->m_result;
} else {
this->m_result = tc_log->rollback(thd, /* all */ true) || this->m_result;
}
this->exit_commit_order(thd);
// This is normally done in ha_rollback_trans, but since we do not call this
// for an external rollback we need to do it explicitly here.
this->m_detached_trx_context->push_unsafe_rollback_warnings(thd);
this->cleanup_context(thd);
return this->m_result;
}
|
