How to Find TiKV Binlog Logs and Delete Incorrect Logs

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 如何找到tikv的binlog日志并删除错误的日志

| username: Steve阿辉

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]

[2023/07/15 04:20:45.223 +08:00] [ERROR] [pipe_builder.rs:354] [“Failed to open log file due to broken entry: Append:17014 offset=122139864”]

Last time I posted a note, some people suggested deleting the logs, but I searched everywhere and couldn’t find how to locate and delete the binlog logs of TiKV.

2
| username: hey-hoho | Original post link

Where does TiKV have binlog?

Please provide more details about the issue. It’s hard to troubleshoot with just one log.

3
| username: zhanggame1 | Original post link

TiKV uses RocksDB for storage at the underlying level and does not have binlog.
RocksDB logs are generally located in /tidb-data/tikv-20160/db, with .log files.
Raft logs are located in /tidb-data/tikv-20160/raft-engine.
Do not delete any of these directly; logs of this type in databases should not be deleted directly.

4
| username: redgame | Original post link

The error message indicates that TiDB encountered a corrupted record when opening the log file, which prevented it from opening the log file properly.

5
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.