故障报告

1. 问题（故障）描述

全量发布日志报错：

[LV1] SQL-> select nvl(MAX(LENGTH("T_IMAGE")),0) FROM ZFL.IMAGE_LOB1 A
ZFL.IMAGE_LOB1 col T_IMAGE, lob_len 55056112
get max lob length use 0 s
[LV1] SQL-> select "T_ID","T_IMAGE" from "ZFL"."IMAGE_LOB1" A
[INF] 2021-07-29 14:23:11: THD[3] send bsdata: topic[37305.zfl.image_lob1.s.2] tag[0-37305] len[10485760]
[ERR] Failed to produce data length[10485760] to topic 37305.zfl.image_lob1.s.2 partition -1 : Broker: Message size too large
error at file[kafka.c] line[548], 
error at file[bsdata_packet.c] line[41], 
error at file[oracle_exp.c] line[1645], 
error at file[db.c] line[1294], 
[ERR] THD[3] db_exp_data,

2. 问题（故障）原因

Kafka发送的消息超过broker限定大小

3. 解决

调整发布节点—>DB配置（或者后台bus_push_db_parameter表）中single_message_max_len参数大小：

4. 参考