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

report "Error 1105: region 5972 is in flashback progress, FlashbackStartTS is 441360701681827852" after flashback command finished #43673

Closed
seiya-annie opened this issue May 10, 2023 · 5 comments · Fixed by #43690
Closed

report "Error 1105: region 5972 is in flashback progress, FlashbackStartTS is 441360701681827852" after flashback command finished #43673

seiya-annie opened this issue May 10, 2023 · 5 comments · Fixed by #43690
Assignees
@Defined2014
Labels
affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. component/tikv-client severity/moderate sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@seiya-annie
Copy link

seiya-annie commented May 10, 2023 •
edited
Loading

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

[2023/05/09 06:02:43.009 +08:00] [INFO] [flashback_cluster_test.go:239] ["flashback cluster to timestamp '2023-05-08 21:56:43'"]
[2023/05/09 06:02:44.412 +08:00] [INFO] [flashback_cluster_test.go:248] ["select count() from tpcc.customer"]
[2023/05/09 06:02:44.502 +08:00] [INFO] [flashback_cluster_test.go:251] [error] ["select count() from table fail"="Error 1105: region 300
0 is in flashback progress, FlashbackStartTS is 441341277140942853"]

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

sql can execute successfully after flashback

3. What did you see instead (Required)

report error

4. What is your TiDB version? (Required)

master
@seiya-annie seiya-annie added type/bug The issue is confirmed as a bug. sig/sql-infra SIG: SQL Infra severity/major labels May 10, 2023
@ti-chi-bot ti-chi-bot bot added 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.1 may-affects-6.5 may-affects-7.1 labels May 10, 2023
@seiya-annie seiya-annie removed 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.1 may-affects-6.5 may-affects-7.1 labels May 10, 2023
@Defined2014
Copy link
Contributor

Defined2014 commented May 10, 2023 •
edited
Loading

The root case is we use follower read to read data and the follower's region is still in flashback state(caused by #43149). This is not a serious bug, we could wait a second to read data.

@Defined2014 Defined2014 changed the title report "Error 1105: region 597 2 is in flashback progress, FlashbackStartTS is 441360701681827852" after flashback command finished report "Error 1105: region 5972 is in flashback progress, FlashbackStartTS is 441360701681827852" after flashback command finished May 10, 2023
This was referenced May 11, 2023
Merged
Merged
@you06 you06 added the affects-7.1 This bug affects the 7.1.x(LTS) versions. label May 11, 2023
ti-chi-bot bot pushed a commit that referenced this issue May 11, 2023
@you06
client-go: handle flashback error when replica read is used (#43690)
e6ec225 
close #43673
@ti-chi-bot ti-chi-bot mentioned this issue May 11, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue May 11, 2023
@ti-chi-bot
client-go: handle flashback error when replica read is used (#43690) (#…
3a99718 
…43727)

close #43673
@seiya-annie seiya-annie reopened this May 26, 2023
@cfzjywxk cfzjywxk mentioned this issue Jun 21, 2023
Merged
16 tasks
@Defined2014
Copy link
Contributor

Should fixed by tikv/tikv#14859, close it

@Defined2014
Copy link
Contributor

Seems still have follow read problem, reopen it.

@Defined2014 Defined2014 reopened this Jun 28, 2023
@Defined2014 Defined2014 mentioned this issue Jun 29, 2023
Closed
@jebter jebter added the sig/transaction SIG:Transaction label Jul 27, 2023
@ti-chi-bot ti-chi-bot added the affects-8.1 This bug affects the 8.1.x(LTS) versions. label Apr 9, 2024
@cfzjywxk cfzjywxk added sig/sql-infra SIG: SQL Infra and removed sig/transaction SIG:Transaction labels Apr 28, 2024
@cfzjywxk
Copy link
Contributor

cfzjywxk commented Apr 28, 2024 •
edited
Loading

@Defined2014
Friendly ping, Is there a related client-go issue and are you still following it?

@Defined2014
Copy link
Contributor

Defined2014 commented Apr 28, 2024 •
edited
Loading

No further news, maybe we could close this until it happened again. @cfzjywxk

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

@Defined2014 Defined2014

Labels
affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. component/tikv-client severity/moderate sig/sql-infra SIG: SQL Infra 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.

client-go: handle flashback error when replica read is used you06/tidb
6 participants
@cfzjywxk @jebter @you06 @Defined2014 @seiya-annie @ti-chi-bot