unstable test `testPlanSerialSuite.TestPartitionWithVariedDatasources` #25642

zhouqiang-cl · 2021-06-22T02:11:38Z

Bug Report

6-21T20:37:59.445Z] FAIL: prepare_test.go:1342: testPlanSerialSuite.TestPartitionWithVariedDatasources

[2021-06-21T20:37:59.445Z] 

[2021-06-21T20:37:59.445Z] prepare_test.go:1418:

[2021-06-21T20:37:59.445Z]     tk.MustQuery(`select @@last_plan_from_cache`).Check(testkit.Rows("1"))

[2021-06-21T20:37:59.445Z] /home/jenkins/agent/workspace/tidb-unit-test-nightly/go/src/github.com/pingcap/tidb/util/testkit/testkit.go:63:

[2021-06-21T20:37:59.445Z]     res.c.Assert(resBuff.String(), check.Equals, needBuff.String(), res.comment)

[2021-06-21T20:37:59.445Z] ... obtained string = "[0]\n"

[2021-06-21T20:37:59.445Z] ... expected string = "[1]\n"

[2021-06-21T20:37:59.445Z] ... sql:select @@last_plan_from_cache, args:[]

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

in ci https://ci.pingcap.net/blue/organizations/jenkins/tidb-unit-test-nightly/detail/tidb-unit-test-nightly/1606/pipeline

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

master 3a1f65a

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

zimulala · 2021-07-22T03:43:57Z

PTAL @qw4990

qw4990 · 2021-07-26T11:01:07Z

Cannot locate the cause for this issue, and with it didn't appear again for a few weeks, I prefer to close this issue now.
If it appears again, please contact me.

ti-srebot · 2021-07-26T11:01:11Z

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

tiancaiamao · 2021-11-11T07:01:30Z

New reproduction found.

qw4990 · 2021-11-23T09:01:13Z

Close since no new error message and no more idea about it ...
Please post the error message here and let me know if it reproduces again in the future.

github-actions · 2021-11-23T09:01:32Z

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.

qw4990 · 2021-11-23T10:02:13Z

A new case: https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_check_2/detail/tidb_ghpr_check_2/47548/pipeline/


[2021-11-23T09:45:41.784Z] FAIL: prepare_test.go:2036: testPlanSerialSuite.TestPartitionWithVariedDatasources

[2021-11-23T09:45:41.784Z] 

[2021-11-23T09:45:41.784Z] prepare_test.go:2164:

[2021-11-23T09:45:41.784Z]     tk.MustQuery(`select @@last_plan_from_cache`).Check(testkit.Rows("1"))

[2021-11-23T09:45:41.784Z] /home/jenkins/agent/workspace/tidb_ghpr_check_2/go/src/github.com/pingcap/tidb/util/testkit/testkit.go:67:

[2021-11-23T09:45:41.784Z]     res.c.Assert(resBuff.String(), check.Equals, needBuff.String(), res.comment)

[2021-11-23T09:45:41.784Z] ... obtained string = "[0]\n"

[2021-11-23T09:45:41.784Z] ... expected string = "[1]\n"

[2021-11-23T09:45:41.784Z] ... sql:select @@last_plan_from_cache, args:[]

[2021-11-23T09:45:41.784Z] 

[2021-11-23T09:45:41.784Z] 

[2021-11-23T09:45:41.784Z] ----------------------------------------------------------------------

github-actions · 2021-11-25T03:12:08Z

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.

tiancaiamao · 2022-02-25T08:55:05Z

Found recently again @qw4990
https://ci.pingcap.net/job/tidb_ghpr_unit_test/37810/display/redirect

tiancaiamao · 2022-02-25T08:56:17Z

https://ci.pingcap.net/job/tidb_ghpr_unit_test/37759/display/redirect
https://ci.pingcap.net/job/tidb_ghpr_unit_test/37751/display/redirect

tiancaiamao · 2022-03-09T07:47:44Z

Again!
https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_unit_test/detail/tidb_ghpr_unit_test/39667/pipeline

[FAIL]  planner/core TestPartitionWithVariedDataSources1
[2022-03-09T07:40:46.850Z] err=exit status 1
[2022-03-09T07:40:46.850Z] [2022/03/09 15:40:36.553 +08:00] [WARN] [session.go:1879] ["run statement failed"] [schemaVersion=0] [error="[schema:1049]Unknown database 'mysql'"] [errorVerbose="[schema:1049]Unknown database 'mysql'\ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/[email protected]/errors.go:174\ngithub.com/pingcap/errors.(*Error).GenWithStackByArgs\n\t/go/pkg/mod/github.com/pingcap/[email protected]/normalize.go:164\ngithub.com/pingcap/tidb/executor.(*SimpleExec).executeUse\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/executor/simple.go:557\ngithub.com/pingcap/tidb/executor.(*SimpleExec).Next\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/executor/simple.go:127\ngithub.com/pingcap/tidb/executor.Next\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/executor/executor.go:302\ngithub.com/pingcap/tidb/executor.(*ExecStmt).handleNoDelayExecutor\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/executor/adapter.go:635\ngithub.com/pingcap/tidb/executor.(*ExecStmt).handleNoDelay\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/executor/adapter.go:490\ngithub.com/pingcap/tidb/executor.(*ExecStmt).Exec\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/executor/adapter.go:439\ngithub.com/pingcap/tidb/session.runStmt\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/session/session.go:1999\ngithub.com/pingcap/tidb/session.(*session).ExecuteStmt\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/session/session.go:1876\ngithub.com/pingcap/tidb/session.(*session).ExecuteInternal\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/session/session.go:1488\ngithub.com/pingcap/tidb/session.checkBootstrapped\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/session/bootstrap.go:681\ngithub.com/pingcap/tidb/session.bootstrap\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/session/bootstrap.go:406\ngithub.com/pingcap/tidb/session.runInBootstrapSession\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/session/session.go:2926\ngithub.com/pingcap/tidb/session.BootstrapSession\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/session/session.go:2768\ngithub.com/pingcap/tidb/testkit.bootstrap\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/testkit/mockstore.go:50\ngithub.com/pingcap/tidb/testkit.CreateMockStoreAndDomain\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/testkit/mockstore.go:43\ngithub.com/pingcap/tidb/testkit.CreateMockStore\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/testkit/mockstore.go:35\ngithub.com/pingcap/tidb/planner/core_test.TestPartitionWithVariedDataSources\n\t/home/jenkins/agent/workspace/tidb_ghpr_unit_test/go/src/github.com/pingcap/tidb/planner/core/prepare_test.go:2414\ntesting.tRunner\n\t/usr/local/go/src/testing/testing.go:1193\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1371"] [session="{\n  \"currDBName\": \"\",\n  \"id\": 0,\n  \"status\": 2,\n  \"strictMode\": true,\n  \"user\": null\n}"]
[2022-03-09T07:40:46.850Z] [2022/03/09 15:40:36.818 +08:00] [WARN] [sysvar_cache.go:54] ["sysvar cache is empty, triggering rebuild"]
[2022-03-09T07:40:46.850Z] --- FAIL: TestPartitionWithVariedDataSources (1.90s)
[2022-03-09T07:40:46.850Z]     result.go:50: 
[2022-03-09T07:40:46.850Z]         	Error Trace:	result.go:50
[2022-03-09T07:40:46.850Z]         	            				prepare_test.go:2520
[2022-03-09T07:40:46.850Z]         	Error:      	Not equal: 
[2022-03-09T07:40:46.850Z]         	            	expected: "[1]\n"
[2022-03-09T07:40:46.850Z]         	            	actual  : "[0]\n"
[2022-03-09T07:40:46.850Z]         	            	
[2022-03-09T07:40:46.850Z]         	            	Diff:
[2022-03-09T07:40:46.850Z]         	            	--- Expected
[2022-03-09T07:40:46.850Z]         	            	+++ Actual
[2022-03-09T07:40:46.851Z]         	            	@@ -1,2 +1,2 @@
[2022-03-09T07:40:46.851Z]         	            	-[1]
[2022-03-09T07:40:46.851Z]         	            	+[0]
[2022-03-09T07:40:46.851Z]         	            	 
[2022-03-09T07:40:46.851Z]         	Test:       	TestPartitionWithVariedDataSources
[2022-03-09T07:40:46.851Z]         	Messages:   	sql:select @@last_plan_from_cache, args:[]
[2022-03-09T07:40:46.851Z] FAIL

tiancaiamao · 2022-03-15T10:08:36Z

https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_unit_test/detail/tidb_ghpr_unit_test/40797/pipeline

hawkingrei · 2023-10-23T16:15:43Z

It is so old. I have not seen this flaky test for a long time.

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

ChenPeng2013 added severity/major sig/planner SIG: Planner labels Jun 22, 2021

ichn-hu mentioned this issue Jun 22, 2021

Welcome to contribute #20804

Closed

tisonkun mentioned this issue Jul 2, 2021

Tracking issue for unstable tests #25899

Closed

zimulala assigned qw4990 Jul 22, 2021

qw4990 closed this as completed Jul 26, 2021

ti-srebot added the need-more-info label Jul 26, 2021

tiancaiamao mentioned this issue Nov 11, 2021

table/tables: make CI stable for table/tables package #29688

Merged

12 tasks

tiancaiamao reopened this Nov 11, 2021

qw4990 closed this as completed Nov 23, 2021

github-actions bot added the needs-more-info label Nov 23, 2021

qw4990 reopened this Nov 23, 2021

qw4990 mentioned this issue Nov 25, 2021

planner: fix the unstable test TestPartitionWithVariedDatasources #30139

Merged

1 task

ti-chi-bot closed this as completed in #30139 Nov 25, 2021

tiancaiamao mentioned this issue Dec 9, 2021

*: use the real StateRemote interface implementation for cached table #30066

Merged

12 tasks

tiancaiamao reopened this Feb 25, 2022

tiancaiamao mentioned this issue Mar 9, 2022

Track the unstable tests after migration of new CI script #32303

Open

tiancaiamao added good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. labels Mar 11, 2022

VelocityLight added the affects-6.0 label Mar 17, 2022

morgo mentioned this issue Mar 21, 2022

TestPartitionWithVariedDataSources test failure #33297

Closed

chrysan added severity/minor severity/major and removed severity/major severity/minor labels May 10, 2022

VelocityLight added the affects-6.1 label May 20, 2022

VelocityLight added the affects-6.2 label Jul 20, 2022

VelocityLight added the affects-6.3 label Sep 20, 2022

VelocityLight added the affects-6.4 label Nov 4, 2022

VelocityLight added the affects-6.5 label Dec 2, 2022

VelocityLight added the affects-6.6 label Feb 9, 2023

VelocityLight added the affects-7.0 label Mar 20, 2023

VelocityLight added the affects-7.1 label Apr 20, 2023

ti-chi-bot added the affects-7.5 label Oct 23, 2023

hawkingrei closed this as completed Oct 23, 2023

ti-chi-bot removed affects-6.5 affects-7.5 affects-7.1 labels Dec 7, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

unstable test `testPlanSerialSuite.TestPartitionWithVariedDatasources` #25642

unstable test `testPlanSerialSuite.TestPartitionWithVariedDatasources` #25642

zhouqiang-cl commented Jun 22, 2021

zimulala commented Jul 22, 2021

qw4990 commented Jul 26, 2021 •

edited

Loading

ti-srebot commented Jul 26, 2021

tiancaiamao commented Nov 11, 2021

qw4990 commented Nov 23, 2021

github-actions bot commented Nov 23, 2021

qw4990 commented Nov 23, 2021 •

edited

Loading

github-actions bot commented Nov 25, 2021

tiancaiamao commented Feb 25, 2022

tiancaiamao commented Feb 25, 2022

tiancaiamao commented Mar 9, 2022 •

edited

Loading

tiancaiamao commented Mar 15, 2022

hawkingrei commented Oct 23, 2023

unstable test testPlanSerialSuite.TestPartitionWithVariedDatasources #25642

unstable test testPlanSerialSuite.TestPartitionWithVariedDatasources #25642

Comments

zhouqiang-cl commented Jun 22, 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)

zimulala commented Jul 22, 2021

qw4990 commented Jul 26, 2021 • edited Loading

ti-srebot commented Jul 26, 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

tiancaiamao commented Nov 11, 2021

qw4990 commented Nov 23, 2021

github-actions bot commented Nov 23, 2021

qw4990 commented Nov 23, 2021 • edited Loading

github-actions bot commented Nov 25, 2021

tiancaiamao commented Feb 25, 2022

tiancaiamao commented Feb 25, 2022

tiancaiamao commented Mar 9, 2022 • edited Loading

tiancaiamao commented Mar 15, 2022

hawkingrei commented Oct 23, 2023

unstable test `testPlanSerialSuite.TestPartitionWithVariedDatasources` #25642

unstable test `testPlanSerialSuite.TestPartitionWithVariedDatasources` #25642

qw4990 commented Jul 26, 2021 •

edited

Loading

qw4990 commented Nov 23, 2021 •

edited

Loading

tiancaiamao commented Mar 9, 2022 •

edited

Loading