Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

unstable test analyze_test.go:561: testSuite1.TestAnalyzeIndex #25188

Closed
Tracked by #25899
zhouqiang-cl opened this issue Jun 6, 2021 · 2 comments · Fixed by #26875
Closed
Tracked by #25899

unstable test analyze_test.go:561: testSuite1.TestAnalyzeIndex #25188

zhouqiang-cl opened this issue Jun 6, 2021 · 2 comments · Fixed by #26875
Assignees
@winoros
Labels
component/test help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@zhouqiang-cl
Copy link
Contributor

Bug Report

06-06T13:36:31.350Z] ----------------------------------------------------------------------
[2021-06-06T13:36:31.350Z] FAIL: analyze_test.go:561: testSuite1.TestAnalyzeIndex
[2021-06-06T13:36:31.350Z] 
[2021-06-06T13:36:31.350Z] analyze_test.go:572:
[2021-06-06T13:36:31.350Z]     c.Assert(len(tk.MustQuery("show stats_topn where table_name = 't1' and column_name = 'k' and is_index = 1").Rows()), Greater, 0)
[2021-06-06T13:36:31.350Z] ... compare_one int = 0
[2021-06-06T13:36:31.350Z] ... compare_two int = 0
[2021-06-06T13:36:31.350Z] 
[2021-06-06T13:36:31.350Z] [2021/06/06 21:36:31.118 +08:00] [INFO] [session.go:2780] ["CRUCIAL OPERATION"] [conn=253] [schemaVersion=152] [cur_db=test] [sql="create table t1(a varchar(20), b int, c int)"] [user=]
[2021-06-06T13:36:31.350Z] [2021/06/06 21:36:31.119 +08:00] [WARN] [2pc.go:1444] ["schemaLeaseChecker is not set for this transaction"] [sessionID=229] [startTS=425456196941512711] [commitTS=425456196942299138]
[2021-06-06T13:36:31.350Z] 
[2021-06-06T13:36:31.350Z] ----------------------------------------------------------------------

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

in ci https://ci.pingcap.net/blue/rest/organizations/jenkins/pipelines/tidb-unit-test-nightly/runs/195/nodes/125/steps/527/log/?start=0

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

master 47f0f15
@zhouqiang-cl zhouqiang-cl added type/bug The issue is confirmed as a bug. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. severity/major labels Jun 6, 2021
bb7133 added a commit to bb7133/tidb that referenced this issue Jun 7, 2021
@bb7133
executor: temporarily skip some unstable test cases.
aa86bbb 
- testResourceTagSuite.TestResourceGroupTag (pingcap#25189)
- testSuiteJoin1.TestIndexLookupJoin (pingcap#25191)
- testSuite1.TestAnalyzeIndex (pingcap#25188)
- testSuite1.TestAnalyzeIncremental (pingcap#25187)
- testVectorizeSuite2.TestVectorizedBuiltinTimeEvalOneVec (pingcap#25169)
This was referenced Jun 7, 2021
Open
Merged
zhouqiang-cl pushed a commit that referenced this issue Jun 8, 2021
@bb7133
executor: temporarily skip some unstable test cases. (#25224)
eb91585 
- testResourceTagSuite.TestResourceGroupTag (#25189)
- testSuiteJoin1.TestIndexLookupJoin (#25191)
- testSuite1.TestAnalyzeIndex (#25188)
- testSuite1.TestAnalyzeIncremental (#25187)
- testVectorizeSuite2.TestVectorizedBuiltinTimeEvalOneVec (#25169)
@tisonkun tisonkun mentioned this issue Jul 2, 2021
Closed
@lysu lysu assigned winoros and unassigned lysu Jul 22, 2021
@lysu
Copy link
Contributor

lysu commented Jul 22, 2021 •
edited
Loading

original test case is stable, but it's failed at new added show stats_topn, ptal @winoros

@wjhuang2016 wjhuang2016 added the sig/planner SIG: Planner label Jul 23, 2021
@ichn-hu ichn-hu mentioned this issue Jul 23, 2021
Closed
@time-and-fate time-and-fate mentioned this issue Aug 4, 2021
Merged
12 tasks
@ti-srebot
Copy link
Contributor

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

Not a bug

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

Duplicate bug

  1. Add the 'type/duplicate' label
  2. 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

@ti-srebot ti-srebot mentioned this issue Aug 4, 2021
Merged
12 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@winoros winoros

Labels
component/test help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

executor: fix several analyze related unstable tests time-and-fate/tidb
6 participants
@lysu @jebter @winoros @wjhuang2016 @zhouqiang-cl @ti-srebot