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

after restart one tidb，this tidb start after 30min #41318

Closed
Lily2025 opened this issue Feb 13, 2023 · 3 comments · Fixed by #41346
Closed

after restart one tidb，this tidb start after 30min #41318

Lily2025 opened this issue Feb 13, 2023 · 3 comments · Fixed by #41346
Assignees
@qw4990
Labels
affects-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. affects-5.3 This bug affects 5.3.x versions. affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.0 affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.2 affects-6.3 affects-6.4 affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-6.6 severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@Lily2025
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

https://tcms.pingcap.net/dashboard/executions/plan/1620339
ha-tidb-random-restart-with-forwarding
1、run tpcc
2、restart one tidb

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

tidb can start quickly

3. What did you see instead (Required)

after restart one tidb，this tidb start after 30min
clinic: https://clinic.pingcap.com.cn/portal/#/orgs/31/clusters/7198381856743085253?from=1676037816&to=1676039485
log: http://minio.pingcap.net:38888/buckets/test-infra-testground/browse/YXJjaGl2ZS9lbmRsZXNzLWhhLXRlc3Qtd2l0aC1zb21lLWZlYXR1cmUtdHBzLTE2MjAzMzktMS0yMzcvdGMtdGlkYi0x

image

4. What is your TiDB version? (Required)

[2023/02/10 22:03:36.193 +08:00] [INFO] [db.go:158] ["instance-info "] [type=tidb] [instance=tc-tidb-1] [version=6.6.0] [git_hash=3f897f8220112400db7702e20e7962ce885e8301]
[2023/02/10 22:03:36.193 +08:00] [INFO] [db.go:158] ["instance-info "] [type=tidb] [instance=tc-tidb-0] [version=6.6.0] [git_hash=3f897f8220112400db7702e20e7962ce885e8301]
[2023/02/10 22:03:36.193 +08:00] [INFO] [db.go:158] ["instance-info "] [type=pd] [instance=tc-pd-2] [version=6.6.0] [git_hash=2be26ff534692fb3de17b7ce69cff46a67359fc3]
[2023/02/10 22:03:36.193 +08:00] [INFO] [db.go:158] ["instance-info "] [type=pd] [instance=tc-pd-1] [version=6.6.0] [git_hash=2be26ff534692fb3de17b7ce69cff46a67359fc3]
[2023/02/10 22:03:36.193 +08:00] [INFO] [db.go:158] ["instance-info "] [type=pd] [instance=tc-pd-0] [version=6.6.0] [git_hash=2be26ff534692fb3de17b7ce69cff46a67359fc3]
[2023/02/10 22:03:36.193 +08:00] [INFO] [db.go:158] ["instance-info "] [type=tikv] [instance=tc-tikv-0] [version=6.6.0] [git_hash=ce7957763b5dc9e0913321dca4414e44676eef94]
[2023/02/10 22:03:36.193 +08:00] [INFO] [db.go:158] ["instance-info "] [type=tikv] [instance=tc-tikv-3] [version=6.6.0] [git_hash=ce7957763b5dc9e0913321dca4414e44676eef94]
[2023/02/10 22:03:36.193 +08:00] [INFO] [db.go:158] ["instance-info "] [type=tikv] [instance=tc-tikv-1] [version=6.6.0] [git_hash=ce7957763b5dc9e0913321dca4414e44676eef94]
[2023/02/10 22:03:36.193 +08:00] [INFO] [db.go:158] ["instance-info "] [type=tikv] [instance=tc-tikv-2] [version=6.6.0] [git_hash=ce7957763b5dc9e0913321dca4414e44676eef94]
@Lily2025 Lily2025 added the type/bug The issue is confirmed as a bug. label Feb 13, 2023
@Lily2025
Copy link
Author

/type bug
/severity major
/assign xuyifangreeneyes

@ti-chi-bot ti-chi-bot added severity/major 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 may-affects-6.5 may-affects-6.6 labels Feb 13, 2023
@Lily2025
Copy link
Author

/remove-label may-affects-4.0
/remove-label may-affects-5.0
/remove-label may-affects-5.1
/remove-label may-affects-5.2
/remove-label may-affects-5.3
/remove-label may-affects-5.4
/remove-label may-affects-6.0
/remove-label may-affects-6.1
/remove-label may-affects-6.2
/remove-label may-affects-6.3
/remove-label may-affects-6.4
/remove-label may-affects-6.5

@ti-chi-bot ti-chi-bot removed 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 may-affects-6.5 labels Feb 13, 2023
@xuyifangreeneyes
Copy link
Contributor

#40284 would kill auto analyze when shutting down but it doesn't stop autoAnalyzeWorker from launching a new auto analyze job. The new auto analyze job prevents the tidb server from shutting down smoothly.
log

@xuyifangreeneyes xuyifangreeneyes mentioned this issue Feb 13, 2023
Merged
12 tasks
@xuyifangreeneyes xuyifangreeneyes added affects-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. affects-5.3 This bug affects 5.3.x versions. affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.0 affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.2 affects-6.3 affects-6.4 affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-6.6 and removed may-affects-6.6 labels Feb 14, 2023
ti-chi-bot pushed a commit that referenced this issue Feb 14, 2023
@xuyifangreeneyes
domain, tidb-server: stop launching new auto analyze job when shuttin…
af7fe50 
…g down (#41346)

close #41318
This was referenced Feb 14, 2023
Closed
Closed
Closed
Merged
blacktear23 pushed a commit to blacktear23/tidb that referenced this issue Feb 15, 2023
@xuyifangreeneyes @blacktear23
domain, tidb-server: stop launching new auto analyze job when shuttin…
7317620 
…g down (pingcap#41346)

close pingcap#41318
ghazalfamilyusa pushed a commit to ghazalfamilyusa/tidb that referenced this issue Feb 15, 2023
@xuyifangreeneyes @ghazalfamilyusa
domain, tidb-server: stop launching new auto analyze job when shuttin…
d649179 
…g down (pingcap#41346)

close pingcap#41318
@jebter jebter added the sig/planner SIG: Planner label Jun 25, 2023
@qw4990 qw4990 assigned qw4990 and unassigned xuyifangreeneyes Aug 16, 2023
ti-chi-bot bot pushed a commit that referenced this issue Aug 17, 2023
@ti-chi-bot
domain, tidb-server: stop launching new auto analyze job when shuttin…
6e958a4 
…g down (#41346) (#41392)

close #41318
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@qw4990 qw4990

Labels
affects-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. affects-5.3 This bug affects 5.3.x versions. affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.0 affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.2 affects-6.3 affects-6.4 affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-6.6 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.

domain, tidb-server: stop launching new auto analyze job when shutting down xuyifangreeneyes/tidb
5 participants
@jebter @qw4990 @xuyifangreeneyes @ti-chi-bot @Lily2025