New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Enhancement]: 断连接场景case 补充[obproxy配置项检查request_buffer_length ] #575

Open

Teingi opened this issue Nov 26, 2024 · 0 comments

Contributor

Teingi commented Nov 26, 2024

Description

request_buffer_length 是 OBProxy 实例级配置项，用于控制 OBProxy 能解析的最大请求长度，取值[1KB, 16MB]，默认为 4KB。

某业务日志报错失去服务连接，observer日志中：multi stmt is not supported to be executed on txn temporary node，-6279

根因：obproxy不支持客户端大请求的重试。对sql长度超过4k，odp重试会失败，所以报错了。重试失败的update语句，基本都有6～7k长度。

处理方式：
修改obproxy参数：request_buffer_length 为10KB 后观察正常。

建议：obproxy对于超出request_buffer_length长度的sql不会到observer，所以sql audit中查不到不会记录，排查比较费时，希望工具侧能够支持巡检或者根因分析

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment