Starrocks出现Lost connection to MySQL server during query

背景:在调度中出现这个报错,但是在后台执行的时候是成功的,每次在调度上执行6分钟即360S的时候出现了这个报错,排查后发现使用的nginx代理中设置的timeout设置的是360s,所以才会出现这个报错

ERROR 2013 (HY000) at line 3: Lost connection to MySQL server during query

解决方案:

nginx中的timeout的时间调整到7200s问题解决.

原来nginx的配置
# starRocks
server {
    listen 29030;
    proxy_connect_timeout 360;
    proxy_timeout 360;
    proxy_pass pp_starrocks;
}
upstream pp_starrocks {
    server 10.170.12.66:9030;
    server 10.170.12.67:9030;
    server 10.170.12.68:9030;
}
更新后的配置
# starRocks
server {
    listen 29030;
    proxy_connect_timeout 7200;
    proxy_timeout 7200;
    proxy_pass pp_starrocks;
}
upstream pp_starrocks {
    server 10.170.12.66:9030;
    server 10.170.12.67:9030;
    server 10.170.12.68:9030;
}