故障报告

1. 问题（故障）描述

增量订阅lob字段，报错：

[LV1] SQL-> SELECT objectid,value FROM bus_client_product_object_properties  WHERE customerid=37081 and variable_name='column_map' order by objectid
[INF] LOAD THD[4] error data output to file /busdata/zl/zcbus/2.0.1/log/dmp20210809/37081_4_20210809201420.log, please check!
error at file[msg_load_db.c] line[1201], ZCBUS-120: row too long, table[public.SM_FILESTOREVIEW]
error at file[msg_load_db.c] line[1332], ZCBUS-120: row too long, table[public.SM_FILESTOREVIEW]
error at file[msg_load_db.c] line[2722], ZCBUS-120: row too long, table[public.SM_FILESTOREVIEW]
[LV1] SQL-> rollback
[ERR] LOAD THD[4]: ZCBUS-120: row too long, table[public.SM_FILESTOREVIEW]
[ERR] LOAD THD[4] msg_load, ZCBUS-120: row too long, table[public.SM_FILESTOREVIEW], retry 1...

2. 问题（故障）原因

单条记录超过50M，超过程序限制

3. 解决

zcbus-7.6-9-20210809.tar.gz版本已将限制修改成100M，如再有超过100M的，可以向研发提出需求，修改限制。

4. 参考