我在使用过程中遇到了这样的报错，导致数据写不进去
{ “TxnId”: 16418732, “Label”: “1648234a-6b54-4507-a0a0-3fb13439b955”, “Status”: “Fail”, “Message”: “Primary-key index exceeds the limit. tablet_id: 140561, consumption: 23031096580, limit: 17571729729. Memory stats of top five tablets: 133749(1960M)133745(1960M)133747(1960M)133751(1960M)121378(1304M)”, “NumberTotalRows”: 0, “NumberLoadedRows”: 0, “NumberFilteredRows”: 0, “NumberUnselectedRows”: 0, “LoadBytes”: 754, “LoadTimeMs”: 6, “BeginTxnTimeMs”: 0, “StreamLoadPutTimeMs”: 1, “ReadDataTimeMs”: 0, “WriteDataTimeMs”: 1, “CommitAndPublishTimeMs”: 0}
Primary-key index exceeds the limit. tablet_id: 140561, consumption: 23031096580, limit: 17571729729
这是主键模型写入数据，主键索引所占用内存超过限制了。建议
1.主键模型的表创建分区，避免写入数据的时候全表的主键索引加载到内存
2.开启持久化主键索引。
参考 https://docs.starrocks.io/zh-cn/latest/table_design/Data_model#主键模型