tidb在从5亿条的数据表查询中报错:maybe read truncated/dropped table data

SELECT id, user_id, aweme_id AS video_id, description, create_time, goods_id, is_delete, digg_count, comment_count, share_count, play_count, duration FROM xxxxxx WHERE (create_time > 1622476800) AND (create_time < 1622563200) AND (id < ‘461457944’) ORDER BY id DESC LIMIT 100;

在执行这个sql的时候 tidb报错:other error: default not found: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?

具体的sql记录的报错日志:SQLSTATE[HY000]: General error: 1105 other error: default not found: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?\n

查询时间是否超过了GC时间?

并没有,程序查询超时时间设置为了10s,在10s内报的错

我的意思是查询的时候,正好是gc的时间。
是稳定重现么?

对,稳定重现

  1. 请问您是哪个版本?
  2. 有 tiflash 节点吗?

tidb_version(): Release Version: v4.0.11
Edition: Community
Git Commit Hash: 058e52ad7c1b477147dcb933b3f1b3b2be31e998
Git Branch: heads/refs/tags/v4.0.11
UTC Build Time: 2021-02-25 04:33:58
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

没有tiflash节点

@Hacker_yI2ff81G

  1. 请问这个集群有升级过吗?
  2. 这些信息是业务写入的,还是有使用过 lightning 或者 BR 导入或者恢复过?

从3升级到4的,这些数据都是业务写入的,没有使用过lightning 或者 BR 导入或者恢复

你们是同一个集群吗?

如果是同一个集群。
看起来这个 key 是 8 天前写入的,查询的时候用时 555s,不到 10 分钟。帮忙确认下升级时间是什么时候,是否只有这个 key 有问题,可否提供 8 天前(5 月 26 日 22 时)至 3 天前(5 月 31 日 15 时)的日志

是同一个集群。
以下是tikv的报错日志
这是5月26日开始报错的日志,重复报错,我截取的都是重复的一段:
tikv.log.2021-05-26-16:58:31.313754213:[2021/05/26 14:49:12.808 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“Key is locked
(will clean up) primary_lock: 7480000000000000D45F72800000001A43E080 lock_version: 425200648197242893 key: 7480000000000000D45F7280000
0001A43E080 lock_ttl: 22512 txn_size: 1 lock_for_update_ts: 425200648787067456”]
tikv.log.2021-05-26-16:58:31.313754213:[2021/05/26 14:49:12.914 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“Key is locked
(will clean up) primary_lock: 7480000000000000D45F72800000001A43E080 lock_version: 425200648197242893 key: 7480000000000000D45F7280000
0001A43E080 lock_ttl: 22512 txn_size: 1 lock_for_update_ts: 425200648787067456”]
tikv.log.2021-05-26-16:58:31.313754213:[2021/05/26 14:49:13.654 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“Key is locked
(will clean up) primary_lock: 7480000000000000D45F72800000001A43E080 lock_version: 425200645759303977 key: 7480000000000000D45F7280000
0001A43E080 lock_ttl: 32758 txn_size: 1 lock_for_update_ts: 425200649101640331”]
tikv.log.2021-05-26-16:58:31.313754213:[2021/05/26 14:49:13.713 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“Key is locked
(will clean up) primary_lock: 7480000000000000D45F72800000001A43E080 lock_version: 425200645759303977 key: 7480000000000000D45F7280000
0001A43E080 lock_ttl: 32758 txn_size: 1 lock_for_update_ts: 425200649101640331”]
tikv.log.2021-05-26-16:58:31.313754213:[2021/05/26 14:49:13.716 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“Key is locked
(will clean up) primary_lock: 7480000000000000D45F72800000001A43E080 lock_version: 425200645759303977 key: 7480000000000000D45F7280000
0001A43E080 lock_ttl: 32758 txn_size: 1 lock_for_update_ts: 425200649101640331”]

5月27日报错日志:重复报错,我截取的都是重复的一段:
tikv.log.2021-05-27-00:17:51.453765688:[2021/05/26 23:00:06.078 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=load_da
ta_from_default_cf] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-27-00:17:51.453765688:[2021/05/26 23:00:06.079 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-27-00:17:51.453765688:[2021/05/26 23:00:06.082 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=load_da
ta_from_default_cf] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-27-00:17:51.453765688:[2021/05/26 23:00:06.082 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-27-00:17:51.453765688:[2021/05/26 23:00:06.087 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-27-00:17:51.453765688:[2021/05/26 23:00:06.087 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-27-00:17:51.453765688:[2021/05/26 23:00:06.103 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=load_da
ta_from_default_cf] [key=7480000000000000D45F72800000001A43E080]

5月28日报错日志:重复报错,我截取的都是重复的一段:
tikv.log.2021-05-28-00:36:08.775967699:[2021/05/27 23:47:44.896 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=7] [perf_stats.internal_key_skipped_count=4082] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0] [perf_
stats.block_cache_hit_count=347] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D45F728000
00001A43E080)”] [scan.ranges=1] [scan.total=2179] [scan.processed=992] [scan.is_desc=true] [tag=select] [table_id=212] [txn_start_ts=4
25231768300290363] [total_suspend_time=635ms] [total_process_time=7ms] [handler_build_time=0ns] [wait_time.snapshot=230ms] [wait_time.
schedule=170ms] [wait_time=400ms] [total_lifetime=1.042s] [remote_host=ipv4:172.16.111.63:21562] [region_id=7290176]
tikv.log.2021-05-28-00:36:08.775967699:[2021/05/27 23:47:45.913 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=7] [perf_stats.internal_key_skipped_count=4082] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0] [perf_
stats.block_cache_hit_count=347] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D45F728000
00001A43E080)”] [scan.ranges=1] [scan.total=2179] [scan.processed=992] [scan.is_desc=true] [tag=select] [table_id=212] [txn_start_ts=4
25231768470945844] [total_suspend_time=943ms] [total_process_time=9ms] [handler_build_time=0ns] [wait_time.snapshot=475ms] [wait_time.
schedule=5ms] [wait_time=480ms] [total_lifetime=1.432s] [remote_host=ipv4:172.16.111.63:21568] [region_id=7290176]
tikv.log.2021-05-28-00:36:08.775967699:[2021/05/27 23:47:45.934 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=7] [perf_stats.internal_key_skipped_count=4082] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0] [perf_
stats.block_cache_hit_count=347] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D45F728000
00001A43E080)”] [scan.ranges=1] [scan.total=2179] [scan.processed=992] [scan.is_desc=true] [tag=select] [table_id=212] [txn_start_ts=4
25231768497160392] [total_suspend_time=1.1s] [total_process_time=9ms] [handler_build_time=0ns] [wait_time.snapshot=5ms] [wait_time.sch
edule=224ms] [wait_time=229ms] [total_lifetime=1.338s] [remote_host=ipv4:172.16.111.63:21572] [region_id=7290176]
tikv.log.2021-05-28-00:36:08.775967699:[2021/05/27 23:55:18.882 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-28-00:36:08.775967699:[2021/05/27 23:55:18.882 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-28-00:36:08.775967699:[2021/05/27 23:55:19.045 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-28-00:36:08.775967699:[2021/05/27 23:55:19.045 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-28-00:36:08.775967699:[2021/05/27 23:55:19.425 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
5月29日报错日志:重复报错,我截取的都是重复的一段:
tikv.log.2021-05-29-00:27:51.242902066:[2021/05/28 23:38:03.289 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-29-00:27:51.242902066:[2021/05/28 23:38:03.364 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-29-00:27:51.242902066:[2021/05/28 23:38:03.364 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-29-00:27:51.242902066:[2021/05/28 23:38:03.775 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=0] [perf_stats.internal_key_skipped_count=3571] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0] [perf_
stats.block_cache_hit_count=77] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D45F7280000
0001A43E080)”] [scan.ranges=1] [scan.total=1902] [scan.processed=992] [scan.is_desc=true] [tag=select] [table_id=212] [txn_start_ts=42
5254264987975916] [total_suspend_time=1.626s] [total_process_time=18ms] [handler_build_time=0ns] [wait_time.snapshot=240ms] [wait_time
.schedule=2ms] [wait_time=242ms] [total_lifetime=1.886s] [remote_host=ipv4:172.16.111.67:17274] [region_id=7290176]
tikv.log.2021-05-29-00:27:51.242902066:[2021/05/28 23:38:03.849 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-29-00:27:51.242902066:[2021/05/28 23:38:03.849 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-29-00:27:51.242902066:[2021/05/28 23:38:04.272 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
5月30日报错日志:重复报错,我截取的都是重复的一段:
tikv.log.2021-05-30-00:12:18.347459293:[2021/05/29 22:51:28.894 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=936] [perf_stats.internal_key_skipped_count=5629] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0] [per
f_stats.block_cache_hit_count=133] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D45F7280
0000001A43E080)”] [scan.ranges=1] [scan.total=1920] [scan.processed=992] [scan.is_desc=true] [tag=select] [table_id=212] [txn_start_ts
=425276181786132714] [total_suspend_time=1.042s] [total_process_time=12ms] [handler_build_time=0ns] [wait_time.snapshot=0ns] [wait_tim
e.schedule=2ms] [wait_time=2ms] [total_lifetime=1.056s] [remote_host=ipv4:172.16.111.65:53848] [region_id=7290176]
tikv.log.2021-05-30-00:12:18.347459293:[2021/05/29 22:51:29.227 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=39927] [perf_stats.internal_key_skipped_count=345775] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0]
[perf_stats.block_cache_hit_count=2136] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D45
F72800000001A43E080)”] [scan.ranges=1] [scan.total=133042] [scan.processed=86060] [scan.is_desc=true] [tag=select] [table_id=212] [txn
_start_ts=425276179020513329] [total_suspend_time=1.287s] [total_process_time=422ms] [handler_build_time=0ns] [wait_time.snapshot=0ns]
[wait_time.schedule=10ms] [wait_time=10ms] [total_lifetime=1.719s] [remote_host=ipv4:172.16.111.63:63636] [region_id=7290176]
tikv.log.2021-05-30-00:12:18.347459293:[2021/05/29 23:02:08.500 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-30-00:12:18.347459293:[2021/05/29 23:02:08.500 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-30-00:12:18.347459293:[2021/05/29 23:02:08.546 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
5月31日报错日志:重复报错,我截取的都是重复的一段:
tikv.log.2021-05-31-10:14:24.105259701:[2021/05/31 06:20:03.154 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=1926] [perf_stats.internal_key_skipped_count=6383] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0] [pe
rf_stats.block_cache_hit_count=243] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D45F728
00000001A43E080)”] [scan.ranges=1] [scan.total=1355] [scan.processed=992] [scan.is_desc=true] [tag=select] [table_id=212] [txn_start_t
s=425305886148526126] [total_suspend_time=2.172s] [total_process_time=8ms] [handler_build_time=0ns] [wait_time.snapshot=0ns] [wait_tim
e.schedule=1ms] [wait_time=1ms] [total_lifetime=2.181s] [remote_host=ipv4:172.16.111.67:17270] [region_id=7290176]
tikv.log.2021-05-31-10:14:24.105259701:[2021/05/31 06:20:04.331 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=118434] [perf_stats.internal_key_skipped_count=460460] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0]
[perf_stats.block_cache_hit_count=3372] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D4
5F72800000001A43E080)”] [scan.ranges=1] [scan.total=112299] [scan.processed=86060] [scan.is_desc=true] [tag=select] [table_id=212] [tx
n_start_ts=425305879490068871] [total_suspend_time=709ms] [total_process_time=426ms] [handler_build_time=0ns] [wait_time.snapshot=0ns]
[wait_time.schedule=9ms] [wait_time=9ms] [total_lifetime=1.144s] [remote_host=ipv4:172.16.111.67:17274] [region_id=7290176]
tikv.log.2021-05-31-10:14:24.105259701:[2021/05/31 06:20:04.345 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=118434] [perf_stats.internal_key_skipped_count=460460] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0]
[perf_stats.block_cache_hit_count=3372] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D4
5F72800000001A43E080)”] [scan.ranges=1] [scan.total=112299] [scan.processed=86060] [scan.is_desc=true] [tag=select] [table_id=212] [tx
n_start_ts=425305883697480129] [total_suspend_time=632ms] [total_process_time=489ms] [handler_build_time=0ns] [wait_time.snapshot=0ns]
[wait_time.schedule=9ms] [wait_time=9ms] [total_lifetime=1.13s] [remote_host=ipv4:172.16.111.67:17270] [region_id=7290176]
tikv.log.2021-05-31-10:14:24.105259701:[2021/05/31 06:20:04.763 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=118434] [perf_stats.internal_key_skipped_count=460460] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0]
[perf_stats.block_cache_hit_count=3372] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D4
5F72800000001A43E080)”] [scan.ranges=1] [scan.total=112299] [scan.processed=86060] [scan.is_desc=true] [tag=select] [table_id=212] [tx
n_start_ts=425305877694382420] [total_suspend_time=693ms] [total_process_time=481ms] [handler_build_time=0ns] [wait_time.snapshot=272m
s] [wait_time.schedule=5ms] [wait_time=277ms] [total_lifetime=1.451s] [remote_host=ipv4:172.16.111.67:17270] [region_id=7290176]
tikv.log.2021-05-31-10:14:24.105259701:[2021/05/31 06:24:24.039 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-31-10:14:24.105259701:[2021/05/31 06:24:24.039 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-31-10:14:24.105259701:[2021/05/31 06:24:24.092 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]
tikv.log.2021-05-31-10:14:24.105259701:[2021/05/31 06:24:24.092 +08:00] [WARN] [endpoint.rs:537] [error-response] [err=“default not fo
und: key:7480000000000000D45F72800000001A43E080, maybe read truncated/dropped table data?”]
tikv.log.2021-05-31-10:14:24.105259701:[2021/05/31 06:24:24.221 +08:00] [ERROR] [mod.rs:307] [“default value not found”] [hint=near_re
verse_load_data_by_write] [key=7480000000000000D45F72800000001A43E080]

tikv.log.2021-05-31-14:43:35.822201491:[2021/05/31 14:43:24.365 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=114554] [perf_stats.internal_key_skipped_count=414893] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0]
[perf_stats.block_cache_hit_count=1629] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D4
5F72800000001A43E080)”] [scan.ranges=1] [scan.total=93835] [scan.processed=86060] [scan.is_desc=true] [tag=select] [table_id=212] [txn
_start_ts=425313799594311782] [total_suspend_time=1.442s] [total_process_time=434ms] [handler_build_time=0ns] [wait_time.snapshot=0ns]
[wait_time.schedule=8ms] [wait_time=8ms] [total_lifetime=1.884s] [remote_host=ipv4:172.16.111.65:53856] [region_id=7290176]
tikv.log.2021-05-31-14:43:35.822201491:[2021/05/31 14:43:25.371 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=2166] [perf_stats.internal_key_skipped_count=6178] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0] [pe
rf_stats.block_cache_hit_count=51] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D45F7280
0000001A43E080)”] [scan.ranges=1] [scan.total=1061] [scan.processed=992] [scan.is_desc=true] [tag=select] [table_id=212] [txn_start_ts
=425313803683758370] [total_suspend_time=1.275s] [total_process_time=8ms] [handler_build_time=0ns] [wait_time.snapshot=0ns] [wait_time
.schedule=51ms] [wait_time=51ms] [total_lifetime=1.334s] [remote_host=ipv4:172.16.111.63:63636] [region_id=7290176]
tikv.log.2021-05-31-14:43:35.822201491:[2021/05/31 14:43:25.399 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=114554] [perf_stats.internal_key_skipped_count=414893] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0]
[perf_stats.block_cache_hit_count=1629] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D4
5F72800000001A43E080)”] [scan.ranges=1] [scan.total=93835] [scan.processed=86060] [scan.is_desc=true] [tag=select] [table_id=212] [txn
_start_ts=425313799594311756] [total_suspend_time=1.417s] [total_process_time=438ms] [handler_build_time=0ns] [wait_time.snapshot=0ns]
[wait_time.schedule=25ms] [wait_time=25ms] [total_lifetime=1.88s] [remote_host=ipv4:172.16.111.65:53856] [region_id=7290176]
tikv.log.2021-05-31-14:43:35.822201491:[2021/05/31 14:43:25.492 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=114554] [perf_stats.internal_key_skipped_count=414893] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0]
[perf_stats.block_cache_hit_count=1629] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D4
5F72800000001A43E080)”] [scan.ranges=1] [scan.total=93835] [scan.processed=86060] [scan.is_desc=true] [tag=select] [table_id=212] [txn
_start_ts=425313802032251416] [total_suspend_time=1.481s] [total_process_time=447ms] [handler_build_time=0ns] [wait_time.snapshot=0ns]
[wait_time.schedule=14ms] [wait_time=14ms] [total_lifetime=1.942s] [remote_host=ipv4:172.16.111.63:63636] [region_id=7290176]
tikv.log.2021-05-31-14:43:35.822201491:[2021/05/31 14:43:25.753 +08:00] [INFO] [tracker.rs:241] [slow-query] [perf_stats.internal_dele
te_skipped_count=114554] [perf_stats.internal_key_skipped_count=414893] [perf_stats.block_read_byte=0] [perf_stats.block_read_count=0]
[perf_stats.block_cache_hit_count=1629] [scan.range.first=“Some(start: 7480000000000000D45F72800000001A429054 end: 7480000000000000D4
5F72800000001A43E080)”] [scan.ranges=1] [scan.total=93835] [scan.processed=86060] [scan.is_desc=true] [tag=select] [table_id=212] [txn
_start_ts=425313799594311785] [total_suspend_time=1.479s] [total_process_time=464ms] [handler_build_time=0ns] [wait_time.snapshot=0ns]
[wait_time.schedule=6ms] [wait_time=6ms] [total_lifetime=1.949s] [remote_host=ipv4:172.16.111.63:63638] [region_id=7290176]

能否麻烦您帮忙把 5.26 号 包含从 Key is locked -> default value not found 这段时期的日志上传下?
或者tikv.log 不是很大的话,都上传下,多谢。

tikv日志特别大,我grep这个key 单天的都已经达到了400M了。

0526.log (1.2 MB)

我把tikv的这个key的报错日志 都放到了百度网盘上了,链接: https://pan.baidu.com/s/1I6jOd-yEwAztDXUnIzXfmw 提取码: nxjm

1赞

我这边下载很慢,能否麻烦您压缩下日志,再上传,谢谢。

5.27 的下载下来了,看日志报错,最早是5.26 23:00 报错。
看 5.26 的日志是到晚上 19:51
中间这段时间,麻烦帮忙看下日志,是否 tikv 有过异常? 或者这段时间的日志是否很多,不按照这个key,所有的日志都辛苦拿一下? 可以压缩一下,这样就不会太大了,多谢。

已更新到 链接: https://pan.baidu.com/s/1Xq4YLOErrJ-8UkHmFDtUiQ 提取码: hwwe ,我查看0526.tar.gz 和0527.tar.gz 这两天的全量日志,已压缩。

多谢多谢,再下载了。