oceanbase / odc

OceanBase Developer Center(ODC), An open-source, enterprise-grade database tool for collaborative development
https://github.com/oceanbase/odc
Apache License 2.0
537 stars 55 forks source link

[Enhancement]: the tenant parameter max_allowed_packet of the metadata database must meet the specified size for odc to start successfully #3062

Open zijiacj opened 3 months ago

zijiacj commented 3 months ago

What would you like to be added?

During ODC startup, the tenant parameter max_allowed_packet of the metadata database needs to be checked. max_allowed_packet must meet the specified size

Why is this needed?

If the max_allowed_packet is too small, the flow module fails. In this case, customer need to set an appropriate size for max_allowed_packet and then restart the odc service.This affects the user experience

yhilmare commented 3 months ago

we will set the json value of the request object into the table act_ge_bytearray, the json will be much bigger if the user input a large sql content.

this enhancement will should be fixed by limiting the max content's length by user inputing

yhilmare commented 3 months ago

Already confirmed with QA @tonghan-gsh