apache / apache/jmeter

jdbc request always set autocommit=1

Open
#6,090 5 comments 0 reactions 0 assignees View on GitHub
defect to-triage
Dominant language
Java
Stars
9.5k
Forks
2.3k
Avg merge
1d 22h
Merged PRs (30d)
5

Description

### Expected behavior

fix bug

### Actual behavior

jdbc request always set autocommit=1

### Steps to reproduce the problem

i wanna test transaction on mysql 8.0.20 .
however, after opening a transaction, the next jdbc request always sets autocommit=1
image

image

image

image

mysql general_log:

2023-10-20T08:02:11.701987Z 23 Query SET autocommit=0

after 5 sec ,i found next jdbc request[select_1] send [ set autocommit=1] before select statement

2023-10-20T08:02:16.721626Z 23 Query SET autocommit=1
2023-10-20T08:02:16.741564Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:16.744943Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:16.750466Z 23 Query select * from t1 limit 10
2023-10-20T08:02:21.770572Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:21.779301Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:21.782025Z 23 Query select * from t1 limit 10
2023-10-20T08:02:26.800593Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:26.811092Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:26.829268Z 23 Quit

### JMeter Version

5.6.2

### Java Version

openjdk 17.0.2 2022-01-18

### OS Version

macos

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.