Error 1105: message:\“raft entry is too large

最新推荐文章于 2022-11-12 19:42:20 发布

老王笔记

最新推荐文章于 2022-11-12 19:42:20 发布

阅读量603

点赞数

分类专栏： TiDB 文章标签：数据库 mysql database

本文链接：https://blog.csdn.net/JSWANGCHANG/article/details/125160203

版权

TiDB 专栏收录该内容

46 篇文章 3 订阅

订阅专栏

从MySQL通过DM迁移数据到TiDB的时候，报错"raft entry is too large

详细错误信息如下

"isCanceled": false,
                        "errors": [
                            {
                                "ErrCode": 10006,
                                "ErrClass": "database",
                                "ErrScope": "downstream",
                                "ErrLevel": "high",
                                "Message": "file jcd.pipeline_atomicerrorrecord.0000000000005.sql: execute statement failed: commit",
                                "RawCause": "Error 1105: message:\"raft entry is too large, region 537420, entry size 8759304\" raft_entry_too_large:\u003cregion_id:537420 entry_size:8759304 \u003e ",
                                "Workaround": ""
                            }
                        ],
                        "detail": null
                    },
                    "unresolvedDDLLockID": "",
                    "load": {
                        "finishedBytes": "95843228913",
                        "totalBytes": "95904331149",
                        "progress": "99.94 %",
                        "metaBinlog": "(mysql-bin.001141, 242650193)",

查看 "metaBinlog": "(mysql-bin.001141, 242650193)",显示一条INSERT，也没异常

BEGIN
/*!*/;
# at 242649708
#220606 15:30:02 server id 43902  end_log_pos 242649965 CRC32 0x8325bfcd        Rows_query
# INSERT INTO `changeset_searchset` (`author_id`, `requested_on`, `query_params`, `viewset`, `client`, `count`) VALUES (NULL, '2022-06-06 07:30:02.902717', 'fields=build_st
atus%2Cbuild_status_id', 'OpenedPipelineBuildViewSet', 'pc', 0)
# at 242649965
#220606 15:30:02 server id 43902  end_log_pos 242650038 CRC32 0x76f0483c        Table_map: `jcd`.`changeset_searchset` mapped to number 23288
# at 242650038
#220606 15:30:02 server id 43902  end_log_pos 242650162 CRC32 0x8d3f2c28        Write_rows: table id 23288 flags: STMT_END_F
### INSERT INTO `jcd`.`changeset_searchset`
### SET
###   @1=615828740 /* INT meta=0 nullable=0 is_null=0 */
###   @2='2022-06-06 07:30:02.902717' /* DATETIME(6) meta=6 nullable=0 is_null=0 */
###   @3='fields=build_status%2Cbuild_status_id' /* LONGBLOB/LONGTEXT meta=4 nullable=0 is_null=0 */
###   @4='OpenedPipelineBuildViewSet' /* VARSTRING(600) meta=600 nullable=0 is_null=0 */
###   @5='pc' /* VARSTRING(150) meta=150 nullable=0 is_null=0 */
###   @6=0 /* INT meta=0 nullable=0 is_null=0 */
###   @7=NULL /* INT meta=0 nullable=1 is_null=1 */
# at 242650162
#220606 15:30:02 server id 43902  end_log_pos 242650193 CRC32 0xf1e82c8f        Xid = 1433163919
COMMIT/*!*/;
# at 242650193

报错：region 537420, entry size 8759304\" raft_entry_too_large表名，raft条目太大导致

RaftEntry 过大会返回用户错误不会重试，和 Region Cache 无关；