Unstable test `testTxnStateSerialSuite.TestBlocked` #27116

zhouqiang-cl · 2021-08-11T08:50:22Z

Bug Report

[2021-08-11T07:52:49.269Z] FAIL: session_test.go:4455: testTxnStateSerialSuite.TestBlocked

[2021-08-11T07:52:49.269Z] 

[2021-08-11T07:52:49.269Z] /home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/util/testkit/testkit.go:217:

[2021-08-11T07:52:49.269Z]     tk.c.Assert(err, check.IsNil, check.Commentf("sql:%s, %v, error stack %v", sql, args, errors.ErrorStack(err)))

[2021-08-11T07:52:49.269Z] ... value *errors.withMessage = previous statement: select * from t where a = 1 for update;: [domain:8028]Information schema is changed during the execution of the statement(for example, table definition may be updated by other DDL ran in parallel). If you see this error often, try increasing `tidb_max_delta_schema_count`. [try again later]

[2021-08-11T07:52:49.269Z] ... sql:commit;, [], error stack [domain:8028]Information schema is changed during the execution of the statement(for example, table definition may be updated by other DDL ran in parallel). If you see this error often, try increasing `tidb_max_delta_schema_count`. [try again later]

[2021-08-11T07:52:49.270Z] github.com/pingcap/errors.AddStack

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/pingcap/errors@v0.11.5-0.20210425183316-da1aaba5fb63/errors.go:174

[2021-08-11T07:52:49.270Z] github.com/pingcap/errors.Trace

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/pingcap/errors@v0.11.5-0.20210425183316-da1aaba5fb63/juju_adaptor.go:15

[2021-08-11T07:52:49.270Z] github.com/tikv/client-go/v2/txnkv/transaction.(*twoPhaseCommitter).checkSchemaValid

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/tikv/client-go/v2@v2.0.0-alpha.0.20210806085616-14892a598eab/txnkv/transaction/2pc.go:1620

[2021-08-11T07:52:49.270Z] github.com/tikv/client-go/v2/txnkv/transaction.(*twoPhaseCommitter).execute

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/tikv/client-go/v2@v2.0.0-alpha.0.20210806085616-14892a598eab/txnkv/transaction/2pc.go:1312

[2021-08-11T07:52:49.270Z] github.com/tikv/client-go/v2/txnkv/transaction.(*KVTxn).Commit

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/tikv/client-go/v2@v2.0.0-alpha.0.20210806085616-14892a598eab/txnkv/transaction/txn.go:379

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/store/driver/txn.(*tikvTxn).Commit

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/store/driver/txn/txn_driver.go:71

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*LazyTxn).Commit

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/txn.go:364

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*session).commitTxnWithTemporaryData

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/session.go:578

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*session).doCommit

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/session.go:571

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*session).doCommitWithRetry

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/session.go:702

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*session).CommitTxn

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/session.go:764

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.autoCommitAfterStmt

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/tidb.go:254

[2021-08-11T07:52:49.270Z] --

[2021-08-11T07:52:49.270Z] FAIL: session_test.go:4439: testTxnStateSerialSuite.TestRunning

[2021-08-11T07:52:49.270Z] 

[2021-08-11T07:52:49.270Z] /home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/util/testkit/testkit.go:217:

[2021-08-11T07:52:49.270Z]     tk.c.Assert(err, check.IsNil, check.Commentf("sql:%s, %v, error stack %v", sql, args, errors.ErrorStack(err)))

[2021-08-11T07:52:49.270Z] ... value *errors.withMessage = previous statement: select * from t for update;: [domain:8028]Information schema is changed during the execution of the statement(for example, table definition may be updated by other DDL ran in parallel). If you see this error often, try increasing `tidb_max_delta_schema_count`. [try again later]

[2021-08-11T07:52:49.270Z] ... sql:commit;, [], error stack [domain:8028]Information schema is changed during the execution of the statement(for example, table definition may be updated by other DDL ran in parallel). If you see this error often, try increasing `tidb_max_delta_schema_count`. [try again later]

[2021-08-11T07:52:49.270Z] github.com/pingcap/errors.AddStack

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/pingcap/errors@v0.11.5-0.20210425183316-da1aaba5fb63/errors.go:174

[2021-08-11T07:52:49.270Z] github.com/pingcap/errors.Trace

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/pingcap/errors@v0.11.5-0.20210425183316-da1aaba5fb63/juju_adaptor.go:15

[2021-08-11T07:52:49.270Z] github.com/tikv/client-go/v2/txnkv/transaction.(*twoPhaseCommitter).checkSchemaValid

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/tikv/client-go/v2@v2.0.0-alpha.0.20210806085616-14892a598eab/txnkv/transaction/2pc.go:1620

[2021-08-11T07:52:49.270Z] github.com/tikv/client-go/v2/txnkv/transaction.(*twoPhaseCommitter).execute

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/tikv/client-go/v2@v2.0.0-alpha.0.20210806085616-14892a598eab/txnkv/transaction/2pc.go:1312

[2021-08-11T07:52:49.270Z] github.com/tikv/client-go/v2/txnkv/transaction.(*KVTxn).Commit

[2021-08-11T07:52:49.270Z] 	/nfs/cache/mod/github.com/tikv/client-go/v2@v2.0.0-alpha.0.20210806085616-14892a598eab/txnkv/transaction/txn.go:379

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/store/driver/txn.(*tikvTxn).Commit

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/store/driver/txn/txn_driver.go:71

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*LazyTxn).Commit

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/txn.go:364

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*session).commitTxnWithTemporaryData

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/session.go:578

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*session).doCommit

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/session.go:571

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*session).doCommitWithRetry

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/session.go:702

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.(*session).CommitTxn

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/session.go:764

[2021-08-11T07:52:49.270Z] github.com/pingcap/tidb/session.autoCommitAfterStmt

[2021-08-11T07:52:49.270Z] 	/home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/session/tidb.go:254

[2021-08-11T07:52:49.270Z] + false

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

in ci https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_check_2/detail/tidb_ghpr_check_2/24756/pipeline

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

The text was updated successfully, but these errors were encountered:

bb7133 · 2021-08-11T10:19:13Z

PTAL @longfangsong

tisonkun · 2021-08-23T12:10:52Z

another instance https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_check_2/detail/tidb_ghpr_check_2/28578/pipeline

ti-srebot · 2021-08-25T06:28:09Z

Please edit this comment or add a new comment to complete the following information

Not a bug

Remove the 'type/bug' label
Add notes to indicate why it is not a bug

Duplicate bug

Add the 'type/duplicate' label
Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions

zhouqiang-cl added the type/bug The issue is confirmed as a bug. label Aug 11, 2021

zhouqiang-cl mentioned this issue Aug 11, 2021

Tracking issue for unstable tests #25899

Closed

jingshanglu added severity/major sig/transaction SIG:Transaction labels Aug 11, 2021

ichn-hu mentioned this issue Aug 11, 2021

Welcome to contribute #20804

Closed

bb7133 assigned longfangsong Aug 11, 2021

longfangsong mentioned this issue Aug 16, 2021

txn, session, test: Try to stabilize testTxnStateSerialSuite.TestRunning and TestBlocked #27235

Merged

1 task

ti-chi-bot closed this as completed in #27235 Aug 25, 2021

ti-srebot added the need-more-info label Aug 25, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Unstable test `testTxnStateSerialSuite.TestBlocked` #27116

Unstable test `testTxnStateSerialSuite.TestBlocked` #27116

zhouqiang-cl commented Aug 11, 2021

bb7133 commented Aug 11, 2021

tisonkun commented Aug 23, 2021

ti-srebot commented Aug 25, 2021

Unstable test testTxnStateSerialSuite.TestBlocked #27116

Unstable test testTxnStateSerialSuite.TestBlocked #27116

Comments

zhouqiang-cl commented Aug 11, 2021

Bug Report

1. Minimal reproduce step (Required)

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

bb7133 commented Aug 11, 2021

tisonkun commented Aug 23, 2021

ti-srebot commented Aug 25, 2021

Please edit this comment or add a new comment to complete the following information

Not a bug

Duplicate bug

Bug

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions

Unstable test `testTxnStateSerialSuite.TestBlocked` #27116

Unstable test `testTxnStateSerialSuite.TestBlocked` #27116