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狀態,發現增量壓縮有出現錯誤。
![image](https://private-user-images.githubusercontent.com/53244701/370105723-4d20b19b-21eb-41e3-885a-80dec7baa8e2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkzMzM2NzcsIm5iZiI6MTczOTMzMzM3NywicGF0aCI6Ii81MzI0NDcwMS8zNzAxMDU3MjMtNGQyMGIxOWItMjFlYi00MWUzLTg4NWEtODBkZWM3YmFhOGUyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjEyVDA0MDkzN1omWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTQ2YTc5ZmI5MmMxZmQ2MTk0ZTJkNjFlODU4ZmZhNWU2NzhjOWYyMGUyNzBhYzE5MjBmMGQxZGIwOTg2YmUxNDcmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.7IK_UQ0M4CHiBoSS6cBKyGmaluxfepZE8Y9bIZF0F5s)
手動執行增量壓縮也失敗。
除了重新建表,請問是否還有其他解決方式? 還有為什麼會出現這樣的問題呢?
謝謝!
手動執行增量壓縮:
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