1、tikv_gc_life_time已经改了，但不知为何被改回为10m?
2、GC默认的回收时间要怎么修改？UPDATE mysql.tidb 好像是不行
【TiDB 版本】
V4.0.11
【BR 版本】
V4.0.0
【问题描述】
Step1:UPDATE mysql.tidb SET VARIABLE_VALUE = ‘96h’ WHERE VARIABLE_NAME = ‘tikv_gc_life_time’;
[SQL]UPDATE mysql.tidb SET VARIABLE_VALUE = ‘96h’ WHERE VARIABLE_NAME = ‘tikv_gc_life_time’;
受影响的行: 1
时间: 0.009s
[Err] 1055 - Expression #1 of ORDER BY is not in GROUP BY clause and contains nonaggregated column ‘’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Step2:select* from mysql.tidb WHERE VARIABLE_NAME like ‘%gc%’;
Step3:br备份一个库，全部备份
Step4:第二天增量，报错如下
[2021/05/20 07:19:51.394 +08:00] [INFO] [backup.go:261] [“change table AutoIncID”] [db=EnjoyCRM_DataCenter] [table=tb_customer_extend] [AutoIncID=0]
[2021/05/20 07:19:51.396 +08:00] [ERROR] [backup.go:286] [“Check gc safepoint for last backup ts failed”] [error=“GC safepoint 425057400650203136 exceed TS 425048723054657537: [BR:Backup:ErrBackupGCSafepointExceeded]backup GC safepoint exceeded”] [errorVerbose="[BR:Backup:ErrBackupGCSafepointExceeded]backup GC safepoint exceeded\
GC safepoint 425057400650203136 exceed TS 425048723054657537\ngithub.com/pingcap/br/pkg/utils.CheckGCSafePoint\
\tgithub.com/pingcap/br@/pkg/utils/safe_point.go:72\
github.com/pingcap/br/pkg/task.RunBackup\
\tgithub.com/pingcap/br@/pkg/task/backup.go:284\
github.com/pingcap/br/cmd.runBackupCommand\
\tgithub.com/pingcap/br@/cmd/backup.go:30\
github.com/pingcap/br/cmd.newDBBackupCommand.func1\
\tgithub.com/pingcap/br@/cmd/backup.go:105\
github.com/spf13/cobra.(*Command).execute\
\tgithub.com/spf13/cobra@v1.0.0/command.go:842\
github.com/spf13/cobra.(*Command).ExecuteC\
\tgithub.com/spf13/cobra@v1.0.0/command.go:950\
github.com/spf13/cobra.(*Command).Execute\
\tgithub.com/spf13/cobra@v1.0.0/command.go:887\
main.main\
\tgithub.com/pingcap/br@/main.go:58\
runtime.main\
\truntime/proc.go:203\
runtime.goexit\
\truntime/asm_amd64.s:1357"] [stack=“github.com/pingcap/br/pkg/task.RunBackup\
\tgithub.com/pingcap/br@/pkg/task/backup.go:286\
github.com/pingcap/br/cmd.runBackupCommand\
\tgithub.com/pingcap/br@/cmd/backup.go:30\
github.com/pingcap/br/cmd.newDBBackupCommand.func1\
\tgithub.com/pingcap/br@/cmd/backup.go:105\
github.com/spf13/cobra.(*Command).execute\
\tgithub.com/spf13/cobra@v1.0.0/command.go:842\
github.com/spf13/cobra.(*Command).ExecuteC\
\tgithub.com/spf13/cobra@v1.0.0/command.go:950\
github.com/spf13/cobra.(*Command).Execute\
\tgithub.com/spf13/cobra@v1.0.0/command.go:887\
main.main\
\tgithub.com/pingcap/br@/main.go:58\
runtime.main\
\truntime/proc.go:203”]
[2021/05/20 07:19:51.399 +08:00] [INFO] [ddl.go:394] ["[ddl] DDL closed"] [ID=45ad05a6-94b3-483c-bbc5-a287170ae60f] [“take time”=2.157678ms]