br icon indicating copy to clipboard operation
br copied to clipboard

[stats] error occurred when read table stats [types:1690]%s value is out of range in '%s'

Open overvenus opened this issue 5 years ago • 0 comments

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?

Backup in TiDB 5.0 using BR master Restore to TiDB 5.0 using BR master

Error occurs during restore.

[2020/12/28 12:36:30.250 +08:00] [ERROR] [handle.go:188] ["[stats] error occurred when read table stats"] [table=customer] [error="[types:1690]%s value is out of range in '%s'"] [errorVerbose="[types:1690]%s value is out of range in '%s'
github.com/pingcap/errors.AddStack
	github.com/pingcap/[email protected]/errors.go:174
github.com/pingcap/errors.Trace
	github.com/pingcap/[email protected]/juju_adaptor.go:15
github.com/pingcap/tidb/statistics/handle.(*Handle).columnStatsFromStorage
	github.com/pingcap/[email protected]/statistics/handle/handle.go:500
github.com/pingcap/tidb/statistics/handle.(*Handle).tableStatsFromStorage
	github.com/pingcap/[email protected]/statistics/handle/handle.go:597
github.com/pingcap/tidb/statistics/handle.(*Handle).Update
	github.com/pingcap/[email protected]/statistics/handle/handle.go:185
github.com/pingcap/tidb/domain.(*Domain).loadStatsWorker
	github.com/pingcap/[email protected]/domain/domain.go:1156
runtime.goexit
	runtime/asm_amd64.s:1357"] [stack="github.com/pingcap/tidb/statistics/handle.(*Handle).Update
	github.com/pingcap/[email protected]/statistics/handle/handle.go:188
github.com/pingcap/tidb/domain.(*Domain).loadStatsWorker
	github.com/pingcap/[email protected]/domain/domain.go:1156"]
  1. What did you expect to see?

No error.

  1. What did you see instead?

Error while restore succeeded.

overvenus avatar Dec 28 '20 05:12 overvenus