error: [CORRUPTION]Bad page: checksum mismatch #41188
Unanswered
MeiHsinChen
asked this question in
Q&A
Replies: 2 comments
-
建议英文提问,如使用中文提问,可以去ask.selectdb.com中文技术论坛。 |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Doris查詢表時,會出現checksum mismatch錯誤,確認該表的compaction狀態,發現增量壓縮有出現錯誤。
手動執行增量壓縮也失敗。
除了重新建表,請問是否還有其他解決方式? 還有為什麼會出現這樣的問題呢?
謝謝!
手動執行增量壓縮:
curl -X POST "http://benode:port/api/compaction/run?tablet_id=15683&compact_type=cumulative"
執行失敗:
fail to do cumulative compaction. res=[CORRUPTION]Bad page: checksum mismatch (actual=3887400334 vs expect=757263053), file=/home/maychen/apache-doris/be/storage/data/687/15683/545958608/020000000000242d35437c2d23f12d8d0c9439f44bc078a8_0.dat
查詢表出現的錯誤訊息:
ERROR 1105 (HY000) at line 1: RuntimeException, msg: java.lang.RuntimeException: Failed to analyze following columns:[ss_addr_sk,ss_ticket_number,ss_wholesale_cost,ss_item_sk,ss_sold_date_sk,ss_ext_list_price,ss_store_sk] Reasons: org.apache.doris.common.UserException: errCode = 2, detailMessage = (127.0.0.1)[CANCELLED]Bad page: checksum mismatch (actual=3887400334 vs expect=757263053), file=/home/maychen/apache-doris/be/storage/data/687/15683/545958608/020000000000242d35437c2d23f12d8d0c9439f44bc078a8_0.dat,java.lang.RuntimeException:
failed to read next block when merging rowsets of tablet 15683, error: [CORRUPTION]Bad page: checksum mismatch (actual=3887400334 vs expect=757263053), file=/home/maychen/apache-doris/be/storage/data/687/15683/545958608/020000000000242d35437c2d23f12d8d0c9439f44bc078a8_0.dat
Beta Was this translation helpful? Give feedback.
All reactions