pingcap / pingcap/tidb

when turning off tidb_rc_read_check_ts, the isolation of current transaction is not reset

Open
#37,732 1 comment 0 reactions 0 assignees View on GitHub
affects-6.3 affects-6.4 affects-6.5 may-affects-6.0 may-affects-6.1 may-affects-6.2 severity/moderate sig/transaction type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

ensure tidb is running at RC lsolation and pessimistic transaction mode.

tidb_rc_read_check_ts = ON;
begin;
select * from t1 where id1 = 1;
tidb_rc_read_check_ts = OFF;
select * from t1 where id1 = 1;

as below, the isolation of current snapshot is not reset
![image](https://user-images.githubusercontent.com/87681388/189259699-4c3da090-5c00-4806-a898-97a446a614a2.png)

### 2. What did you expect to see? (Required)
The isolation of current snapshot is SI.

### 3. What did you see instead (Required)
The isolation of current snapshot is RCCheckTS.

### 4. What is your TiDB version? (Required)
| Release Version: v6.2.0
Edition: Community
Git Commit Hash: daf2b17cdfe30c02ce282361009fb5bdb05f2b0e
Git Branch: heads/refs/tags/v6.2.0
UTC Build Time: 2022-08-22 13:47:05

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.