| 1 |
--echo Conflict algorithm counter diff : |
| 2 |
--disable_query_log |
| 3 |
SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_epoch2 AS ndb_conflict_fn_epoch2 FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_FN_EPOCH2"; |
| 4 |
SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_epoch2_trans AS ndb_conflict_fn_epoch2_trans FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_FN_EPOCH2_TRANS"; |
| 5 |
SELECT VARIABLE_VALUE-@init_ndb_conflict_trans_Count AS ndb_conflict_trans_reject_count FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_TRANS_REJECT_COUNT"; |
| 6 |
SELECT VARIABLE_VALUE-@init_ndb_epoch_delete_delete AS ndb_conflict_epoch_delete_delete_count FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_EPOCH_DELETE_DELETE_COUNT"; |
| 7 |
SELECT VARIABLE_VALUE-@init_ndb_epoch_refresh_op_count AS ndb_conflict_refresh_op_count FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_REFRESH_OP_COUNT"; |
| 8 |
--disable_result_log |
| 9 |
SELECT @reflect_prep_count:=(VARIABLE_VALUE+0)-(@init_ndb_epoch_reflect_op_prep_count+0) FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_REFLECTED_OP_PREPARE_COUNT"; |
| 10 |
SELECT @reflect_rej_count:=(VARIABLE_VALUE+0)-(@init_ndb_epoch_refresh_op_discard_count+0) FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_REFLECTED_OP_DISCARD_COUNT"; |
| 11 |
--enable_result_log |
| 12 |
SELECT (@reflect_prep_count+0) > 0 AS reflected_op_prepare_count_greater_than_zero; |
| 13 |
SELECT ((@reflect_rej_count+0) < (@reflect_prep_count+0)) AS any_reflected_ops_applied; |
| 14 |
SELECT (@init_ndb_last_conflict_epoch+0) < (VARIABLE_VALUE+0) AS last_conflict_epoch_increased FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_LAST_CONFLICT_EPOCH"; |
| 15 |
--disable_result_log |
| 16 |
SELECT @ndb_last_conflict_epoch:= VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_LAST_CONFLICT_EPOCH"; |
| 17 |
SELECT @ndb_last_stable_epoch:=VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_LAST_STABLE_EPOCH"; |
| 18 |
SELECT @ndb_max_replicated_epoch:=VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_SLAVE_MAX_REPLICATED_EPOCH"; |
| 19 |
|
| 20 |
--enable_result_log |
| 21 |
|
| 22 |
# Handy for getting a log of the actual numbers for debugging without |
| 23 |
# affecting the output... |
| 24 |
#let $info = `SELECT CONCAT_WS(' ', |
| 25 |
# "max_replicated_epoch:", @ndb_max_replicated_epoch, |
| 26 |
# "last_conflict_epoch:", @ndb_last_conflict_epoch, |
| 27 |
# "init_last_conflict_epoch:", @init_ndb_last_conflict_epoch, |
| 28 |
# "max_rep_epoch lt last_conflict_epoch:", (@ndb_max_replicated_epoch < @ndb_last_conflict_epoch), |
| 29 |
# "Again with numbers", ((@ndb_max_replicated_epoch + 0) < (@ndb_last_conflict_epoch + 0)))`; |
| 30 |
# |
| 31 |
#--exec echo $info >> /tmp/data |
| 32 |
|
| 33 |
|
| 34 |
SELECT (@ndb_max_replicated_epoch+0) < (@ndb_last_conflict_epoch+0) AS conflict_handling_in_progess; |
| 35 |
|
| 36 |
SELECT (@ndb_last_stable_epoch+0) < (@ndb_max_replicated_epoch+0) AS stable_epoch_is_older_than_max_replicated; |
| 37 |
|
| 38 |
if ($EXPECT_STABILITY) |
| 39 |
{ |
| 40 |
let $UNSTABLE=query_get_value(SELECT (@ndb_last_stable_epoch+0) < (@ndb_max_replicated_epoch+0) AS u, u, 1); |
| 41 |
if ($UNSTABLE) |
| 42 |
{ |
| 43 |
# Debugging output |
| 44 |
--echo Expected stability but failed |
| 45 |
--echo Dumping info |
| 46 |
select @ndb_max_replicated_epoch as max_replicated_epoch, |
| 47 |
@ndb_last_conflict_epoch as last_conflict_epoch, |
| 48 |
@init_ndb_last_conflict_epoch as init_last_conflict_epoch; |
| 49 |
SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT%"; |
| 50 |
SHOW BINLOG EVENTS; |
| 51 |
} |
| 52 |
} |
| 53 |
--enable_query_log |