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

flaky test TestCaptureWildcardFilter #40297

Closed
Tracked by #41316
hawkingrei opened this issue Jan 4, 2023 · 7 comments · Fixed by #45836 or #52946
Closed
Tracked by #41316

flaky test TestCaptureWildcardFilter #40297

hawkingrei opened this issue Jan 4, 2023 · 7 comments · Fixed by #45836 or #52946
Assignees
@fzzf678
Labels
affects-6.6 affects-7.0 affects-7.1 affects-8.1 component/test epic/sql-plan-management severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@hawkingrei
Copy link
Member

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

    capture_test.go:738: 

        	Error Trace:	/home/jenkins/.tidb/tmp/63a9840cd0739f2c243bb46478607469/sandbox/linux-sandbox/7422/execroot/__main__/bazel-out/k8-fastbuild/bin/bindinfo/bindinfo_test_/bindinfo_test.runfiles/__main__/bindinfo/capture_test.go:738

        	            				/home/jenkins/.tidb/tmp/63a9840cd0739f2c243bb46478607469/sandbox/linux-sandbox/7422/execroot/__main__/bazel-out/k8-fastbuild/bin/bindinfo/bindinfo_test_/bindinfo_test.runfiles/__main__/bindinfo/capture_test.go:771

        	Error:      	"[[select * from `db11` . `t12` where `a` > ? SELECT /*+ use_index(@`sel_1` `db11`.`t12` )*/ * FROM `db11`.`t12` WHERE `a` > 10  enabled 2023-01-04 11:41:35.323 2023-01-04 11:41:35.323 utf8mb4 utf8mb4_bin capture fb4a631f418c3232052089bd65126540fde8d89feb8bbe416528b09ce76d5c3d ] [select * from `db11` . `t2` where `a` > ? SELECT /*+ use_index(@`sel_1` `db11`.`t2` )*/ * FROM `db11`.`t2` WHERE `a` > 10  enabled 2023-01-04 11:41:35.907 2023-01-04 11:41:35.907 utf8mb4 utf8mb4_bin capture 423f334f02a089274ebd15582c9855c7e912bb272215ef14e4a603cdd226b87b ] [select * from `db12` . `t2` where `a` > ? SELECT /*+ use_index(@`sel_1` `db12`.`t2` )*/ * FROM `db12`.`t2` WHERE `a` > 10  enabled 2023-01-04 11:41:35.810 2023-01-04 11:41:35.810 utf8mb4 utf8mb4_bin capture 9bb308ee50cf11125e4d2e4ba1c98a8b620154343c400b63abcf0da321f30714 ] [select * from `db2` . `t11` where `a` > ? SELECT /*+ use_index(@`sel_1` `db2`.`t11` )*/ * FROM `db2`.`t11` WHERE `a` > 10  enabled 2023-01-04 11:41:35.687 2023-01-04 11:41:35.687 utf8mb4 utf8mb4_bin capture 35738f7acef49eb1323c2585b263c481ee498d08505a20e27c836a0e1ee6c75b ] [select * from `db2` . `t12` where `a` > ? SELECT /*+ use_index(@`sel_1` `db2`.`t12` )*/ * FROM `db2`.`t12` WHERE `a` > 10  enabled 2023-01-04 11:41:35.633 2023-01-04 11:41:35.633 utf8mb4 utf8mb4_bin capture 8a96c554ed761fec06947273583ac1ae7c931b93a65097f143f9caf008161373 ] [select * from `db2` . `t2` where `a` > ? SELECT /*+ use_index(@`sel_1` `db2`.`t2` )*/ * FROM `db2`.`t2` WHERE `a` > 10  enabled 2023-01-04 11:41:35.580 2023-01-04 11:41:35.580 utf8mb4 utf8mb4_bin capture 0a03b784be75684b376881657f4e671e032f98a2735e621add2f2696a49d635d ]]" should have 5 item(s), but has 6

        	Test:       	TestCaptureWildcardFilter

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)
@hawkingrei hawkingrei added the type/bug The issue is confirmed as a bug. label Jan 4, 2023
@ti-chi-bot ti-chi-bot added may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 may-affects-6.3 may-affects-6.4 labels Jan 4, 2023
@ChenPeng2013 ChenPeng2013 removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 may-affects-6.3 may-affects-6.4 labels Jan 4, 2023
@fzzf678
Copy link
Contributor

fzzf678 commented Jan 5, 2023

@hawkingrei I can't reproduce it on master at my local machine, can it be reproduced stably ?

@hawkingrei
Copy link
Member Author

@hawkingrei I can't reproduce it on master at my local machine, can it be reproduced stably ?

I have no idea. In general, some unit tests in the CI are flaky because CI has a high CPU usage environment and it can lead many problems.

@hawkingrei
Copy link
Member Author

@fzzf678 here is the latest log. https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Fghpr_unit_test/detail/ghpr_unit_test/13523/pipeline

@hawkingrei
Copy link
Member Author

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

@hawkingrei
Copy link
Member Author

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

@hawkingrei
Copy link
Member Author 

    capture_test.go:739: 

        	Error Trace:	/home/jenkins/.tidb/tmp/63a9840cd0739f2c243bb46478607469/sandbox/linux-sandbox/16073/execroot/__main__/bazel-out/k8-fastbuild/bin/bindinfo/bindinfo_test_/bindinfo_test.runfiles/__main__/bindinfo/capture_test.go:739

        	            				/home/jenkins/.tidb/tmp/63a9840cd0739f2c243bb46478607469/sandbox/linux-sandbox/16073/execroot/__main__/bazel-out/k8-fastbuild/bin/bindinfo/bindinfo_test_/bindinfo_test.runfiles/__main__/bindinfo/capture_test.go:772

        	Error:      	"[[select * from `db11` . `t12` where `a` > ? SELECT /*+ use_index(@`sel_1` `db11`.`t12` )*/ * FROM `db11`.`t12` WHERE `a` > 10  enabled 2023-02-22 16:00:12.676 2023-02-22 16:00:12.676 utf8mb4 utf8mb4_bin capture fb4a631f418c3232052089bd65126540fde8d89feb8bbe416528b09ce76d5c3d ] [select * from `db11` . `t2` where `a` > ? SELECT /*+ use_index(@`sel_1` `db11`.`t2` )*/ * FROM `db11`.`t2` WHERE `a` > 10  enabled 2023-02-22 16:00:13.140 2023-02-22 16:00:13.140 utf8mb4 utf8mb4_bin capture 423f334f02a089274ebd15582c9855c7e912bb272215ef14e4a603cdd226b87b ] [select * from `db12` . `t2` where `a` > ? SELECT /*+ use_index(@`sel_1` `db12`.`t2` )*/ * FROM `db12`.`t2` WHERE `a` > 10  enabled 2023-02-22 16:00:13.083 2023-02-22 16:00:13.083 utf8mb4 utf8mb4_bin capture 9bb308ee50cf11125e4d2e4ba1c98a8b620154343c400b63abcf0da321f30714 ] [select * from `db2` . `t11` where `a` > ? SELECT /*+ use_index(@`sel_1` `db2`.`t11` )*/ * FROM `db2`.`t11` WHERE `a` > 10  enabled 2023-02-22 16:00:13.014 2023-02-22 16:00:13.014 utf8mb4 utf8mb4_bin capture 35738f7acef49eb1323c2585b263c481ee498d08505a20e27c836a0e1ee6c75b ] [select * from `db2` . `t12` where `a` > ? SELECT /*+ use_index(@`sel_1` `db2`.`t12` )*/ * FROM `db2`.`t12` WHERE `a` > 10  enabled 2023-02-22 16:00:12.953 2023-02-22 16:00:12.953 utf8mb4 utf8mb4_bin capture 8a96c554ed761fec06947273583ac1ae7c931b93a65097f143f9caf008161373 ] [select * from `db2` . `t2` where `a` > ? SELECT /*+ use_index(@`sel_1` `db2`.`t2` )*/ * FROM `db2`.`t2` WHERE `a` > 10  enabled 2023-02-22 16:00:12.892 2023-02-22 16:00:12.892 utf8mb4 utf8mb4_bin capture 0a03b784be75684b376881657f4e671e032f98a2735e621add2f2696a49d635d ]]" should have 5 item(s), but has 6

        	Test:       	TestCaptureWildcardFilter

It is still in existed.

@hawkingrei hawkingrei mentioned this issue Mar 27, 2023
Open
@hawkingrei hawkingrei mentioned this issue Aug 5, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Aug 7, 2023
@hawkingrei
*: fix TestCaptureWildcardFilter (#45836)
58ac0e6 
close #40297
@ti-chi-bot ti-chi-bot mentioned this issue Aug 7, 2023
Closed
12 tasks
@D3Hunter D3Hunter reopened this Feb 23, 2024
@D3Hunter
Copy link
Contributor

met again
https://do.pingcap.net/jenkins/blue/rest/organizations/jenkins/pipelines/pingcap/pipelines/tidb/pipelines/ghpr_unit_test/runs/4227/nodes/63/steps/69/log/?start=0

Resource_group: default\nadmin capture bindings;"]
    capture_test.go:702: 
        	Error Trace:	pkg/bindinfo/capture_test.go:702
        	            				pkg/bindinfo/capture_test.go:752
        	Error:      	Condition never satisfied
        	Test:       	TestCaptureWildcardFilter

@qw4990 qw4990 mentioned this issue Apr 28, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Apr 29, 2024
@qw4990
planner: fix the unstable test TestCaptureWildcardFilter (#52946)
3fc5704 
close #40297
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@fzzf678 fzzf678

Labels
affects-6.6 affects-7.0 affects-7.1 affects-8.1 component/test epic/sql-plan-management severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
7 participants
@D3Hunter @hawkingrei @ChenPeng2013 @qw4990 @VelocityLight @ti-chi-bot @fzzf678