TiKV 报错：TiKV max timestamp is not synced

🪐 TiDB 技术问题
1

【 TiDB 使用环境】测试环境，单机部署
【 TiDB 版本】7.1

【遇到的问题：问题现象及影响】 简单的小表查询非常慢
【资源配置】

image
image1339×549 21.3 KB

【附件：截图/日志/监控】
2023-11-14 15:16:27 (UTC+08:00)

TiDB 192.168.1.50:4000

[backoff.go:158] [“maxTsNotSynced backoffer.maxSleep 80000ms is exceeded, errors:\nmax timestamp not synced, ctx: region ID: 596255, meta: id:596255 start_key:"t\200\000\000\000\000\000\000\025" end_key:"t\200\000\000\000\000\000\000\025_i\200\000\000\000\000\000\000\002\003\200\000\000\000\000\007\227O" region_epoch:<conf_ver:1 version:12 > peers:<id:596256 store_id:1 > , peer: id:596256 store_id:1 , addr: 192.168.1.50:20160, idx: 0, reqStoreType: TiKvOnly, runStoreType: tikv at 2023-11-14T15:16:25.902875865+08:00\nmax timestamp not synced, ctx: region ID: 596255, meta: id:596255 start_key:"t\200\000\000\000\000\000\000\025" end_key:"t\200\000\000\000\000\000\000\025_i\200\000\000\000\000\000\000\002\003\200\000\000\000\000\007\227O" region_epoch:<conf_ver:1 version:12 > peers:<id:596256 store_id:1 > , peer: id:596256 store_id:1 , addr: 192.168.1.50:20160, idx: 0, reqStoreType: TiKvOnly, runStoreType: tikv at 2023-11-14T15:16:26.403465329+08:00\nmax timestamp not synced, ctx: region ID: 596255, meta: id:596255 start_key:"t\200\000\000\000\000\000\000\025" end_key:"t\200\000\000\000\000\000\000\025_i\200\000\000\000\000\000\000\002\003\200\000\000\000\000\007\227O" region_epoch:<conf_ver:1 version:12 > peers:<id:596256 store_id:1 > , peer: id:596256 store_id:1 , addr: 192.168.1.50:20160, idx: 0, reqStoreType: TiKvOnly, runStoreType: tikv at 2023-11-14T15:16:26.904038348+08:00\nlongest sleep type: maxTsNotSynced, time: 76010ms”]

2023-11-14 15:16:27 (UTC+08:00)

TiDB 192.168.1.50:4000

[session.go:967] [“can not retry txn”] [label=internal] [error=“[tikv:9011]TiKV max timestamp is not synced”] [IsBatchInsert=false] [IsPessimistic=true] [InRestrictedSQL=true] [tidb_retry_limit=10] [tidb_disable_txn_auto_retry=true]

2023-11-14 15:16:27 (UTC+08:00)

TiDB 192.168.1.50:4000

[session.go:983] [“commit failed”] [“finished txn”=“Txn{state=invalid}”] [error=“[tikv:9011]TiKV max timestamp is not synced”]

2023-11-14 15:16:27 (UTC+08:00)

TiDB 192.168.1.50:4000

[session.go:2239] [“run statement failed”] [schemaVersion=457732] [error=“previous statement: delete from mysql.analyze_options where table_id = 888009: [tikv:9011]TiKV max timestamp is not synced”] [session=“{\n "currDBName": "",\n "id": 0,\n "status": 2,\n "strictMode": true,\n "user": null\n}”]

2

追加资源配置：

image
image1297×277 4.97 KB

3

用的虚拟机吗？检查下虚拟机的时间

4

试试重启大法吧，你这个单机的，看看系统时间，看日志应该是集群时间问题，但是你是单机版本，所以试试重启吧

5

嗯，是的。虚拟机的时间我检查过，没问题

image
image1449×663 284 KB

6

重启虚拟机？

7

我也遇到了同样的问题

8

很难想象时间怎么会出这样的问题

9

重启解决了吗？

10

重启破万法

11

重启了一下服务器解决了

12

此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。