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.

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

The GC does not work if the configuration of GC is wrong #20655

Closed
Win-Man opened this issue Oct 27, 2020 · 2 comments · Fixed by #21988
Closed

The GC does not work if the configuration of GC is wrong #20655

Win-Man opened this issue Oct 27, 2020 · 2 comments · Fixed by #21988
Assignees
Labels

Comments

@Win-Man
Copy link
Contributor

Win-Man commented Oct 27, 2020

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

update mysql.tidb set VARIABLE_VALUE="10min" where VARIABLE_NAME="tikv_gc_life_time";
update mysql.tidb set VARIABLE_VALUE="10min" where VARIABLE_NAME="tikv_gc_run_interval";

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

The GC can work fine.
Another solution is returning an error if the util is wrong, so I suggest to update the config of GC using SET instead of update. The mysql.tidb should be a read-only table.

3. What did you see instead (Required)

The GC did not work.
image

4. What is your TiDB version? (Required)

MySQL [(none)]> select tidb_version()\G
*************************** 1. row ***************************
tidb_version(): Release Version: v4.0.7
Edition: Community
Git Commit Hash: ed939f3f11599b5a38352c5c160c917df3ebf3eb
Git Branch: heads/refs/tags/v4.0.7
UTC Build Time: 2020-09-29 06:56:48
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
1 row in set (0.00 sec)
@Win-Man Win-Man added the type/bug The issue is confirmed as a bug. label Oct 27, 2020
@SunRunAway
Copy link
Contributor

@cfzjywxk PTAL

@ti-srebot
Copy link
Contributor

ti-srebot commented Jan 7, 2021

Please edit this comment or add a new comment to complete the following information

Not a bug

  1. Remove the 'type/bug' label
  2. Add notes to indicate why it is not a bug

I am changing this to "Not a bug" for the purposes of the bug system. The logic is because the issue is caused by invalid configuration and it is really hard for the server to act correctly with invalid data.

That is not to say it is not an issue, it has been addressed by moving the configuration to sysvars which do validate. The problem is the "bug" element can not truly be closed, since it is still possible for users to modify data using the old table interface.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

7 participants