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

test TestMppAggShouldAlignFinalMode unstable #53565

Closed
AilinKid opened this issue May 27, 2024 · 0 comments · Fixed by #53566
Closed

test TestMppAggShouldAlignFinalMode unstable #53565

AilinKid opened this issue May 27, 2024 · 0 comments · Fixed by #53566
Labels
severity/minor sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@AilinKid
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Fghpr_unit_test/detail/ghpr_unit_test/10127/tests/

image 
(*TestKit).MustQuery\n\tpkg/testkit/testkit.go:173\ngithub.com/pingcap/tidb/pkg/planner/core_test.TestMppAggShouldAlignFinalMode\n\tpkg/planner/core/enforce_mpp_test.go:59\ntesting.tRunner\n\tGOROOT/src/testing/testing.go:1595\nruntime.goexit\n\tsrc/runtime/asm_amd64.s:1650"] [SQL="explain format='brief' select 1 from (  select /*+ read_from_storage(tiflash[t]) */ sum(1)  from t where d BETWEEN '2023-07-01' and '2023-07-03' group by d) total;"]
    testkit.go:196: 
        	Error Trace:	pkg/testkit/testkit.go:196
        	            				pkg/testkit/testkit.go:173
        	            				pkg/planner/core/enforce_mpp_test.go:59
        	Error:      	Received unexpected error:
        	            	[planner:1815]Internal : No access path for table 't' is found with 'tidb_isolation_read_engines' = 'tiflash', valid values can be 'tikv'. Please check tiflash replica.
        	            	github.com/pingcap/errors.AddStack
        	            		external/com_github_pingcap_errors/errors.go:178
        	            	github.com/pingcap/errors.(*Error).GenWithStackByArgs
        	            		external/com_github_pingcap_errors/normalize.go:175
        	            	github.com/pingcap/tidb/pkg/planner/core.filterPathByIsolationRead
        	            		pkg/planner/core/planbuilder.go:1245
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildDataSource
        	            		pkg/planner/core/logical_plan_builder.go:4860
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildResultSetNode
        	            		pkg/planner/core/logical_plan_builder.go:447
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildJoin
        	            		pkg/planner/core/logical_plan_builder.go:932
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildResultSetNode
        	            		pkg/planner/core/logical_plan_builder.go:433
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildTableRefs
        	            		pkg/planner/core/logical_plan_builder.go:425
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildSelect
        	            		pkg/planner/core/logical_plan_builder.go:4104
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildResultSetNode
        	            		pkg/planner/core/logical_plan_builder.go:441
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildJoin
        	            		pkg/planner/core/logical_plan_builder.go:932
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildResultSetNode
        	            		pkg/planner/core/logical_plan_builder.go:433
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildTableRefs
        	            		pkg/planner/core/logical_plan_builder.go:425
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildSelect
        	            		pkg/planner/core/logical_plan_builder.go:4104
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).Build
        	            		pkg/planner/core/planbuilder.go:515
        	            	github.com/pingcap/tidb/pkg/planner.buildLogicalPlan
        	            		pkg/planner/optimize.go:549
        	            	github.com/pingcap/tidb/pkg/planner.optimize
        	            		pkg/planner/optimize.go:466
        	            	github.com/pingcap/tidb/pkg/planner.Optimize
        	            		pkg/planner/optimize.go:334
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).buildExplain
        	            		pkg/planner/core/planbuilder.go:4983
        	            	github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).Build
        	            		pkg/planner/core/planbuilder.go:488
        	            	github.com/pingcap/tidb/pkg/planner.buildLogicalPlan
        	            		pkg/planner/optimize.go:549
        	            	github.com/pingcap/tidb/pkg/planner.optimize
        	            		pkg/planner/optimize.go:466
        	            	github.com/pingcap/tidb/pkg/planner.Optimize
        	            		pkg/planner/optimize.go:334
        	            	github.com/pingcap/tidb/pkg/executor.(*Compiler).Compile
        	            		pkg/executor/compiler.go:99
        	            	github.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt
        	            		pkg/session/session.go:2094
        	            	github.com/pingcap/tidb/pkg/testkit.(*TestKit).ExecWithContext
        	            		pkg/testkit/testkit.go:384
        	            	github.com/pingcap/tidb/pkg/testkit.(*TestKit).MustQueryWithContext
        	            		pkg/testkit/testkit.go:195
        	            	github.com/pingcap/tidb/pkg/testkit.(*TestKit).MustQuery
        	            		pkg/testkit/testkit.go:173
        	            	github.com/pingcap/tidb/pkg/planner/core_test.TestMppAggShouldAlignFinalMode
        	            		pkg/planner/core/enforce_mpp_test.go:59
        	            	testing.tRunner
        	            		GOROOT/src/testing/testing.go:1595
        	            	runtime.goexit
        	            		src/runtime/asm_amd64.s:1650
        	Test:       	TestMppAggShouldAlignFinalMode
        	Messages:   	sql:explain format='brief' select 1 from (  select /*+ read_from_storage(tiflash[t]) */ sum(1)  from t where d BETWEEN '2023-07-01' and '2023-07-03' group by d) total;, args:[]

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

good

3. What did you see instead (Required)

unstable

4. What is your TiDB version? (Required)

master
@AilinKid AilinKid added the type/bug The issue is confirmed as a bug. label May 27, 2024
@AilinKid AilinKid changed the title test unstable test TestMppAggShouldAlignFinalMode unstable May 27, 2024
@AilinKid AilinKid mentioned this issue May 27, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue May 27, 2024
@AilinKid
planner: make TestMppAggShouldAlignFinalMode stable (#53566)
153eb96 
close #53565
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
severity/minor 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.

planner: make TestMppAggShouldAlignFinalMode stable AilinKid/tidb
1 participant
@AilinKid