oceanbase icon indicating copy to clipboard operation
oceanbase copied to clipboard

[Bug]: Fail to set net_write_timeout

Open xiaoxinniux opened this issue 3 years ago • 2 comments

Please check the issue list for the same bug

  • [X] I have checked issue list and this bug is encountered for the first time.

Environment

- OB Version&commit_id or other module version&commit_id (e.g. observer V3.1.2 8b23a93):
- Hardware parameter:OS type & Compliler & CPU etc. 
- Others
### 部署:1台obproxy 3个实例
### 版本:
obproxy (OceanBase 3.2.0 1)
observer 实例版本 3.1.1

### 硬件:
obproxy :  8core, 32G
observer : 16core ,64G

### OS
obproxy及obsever 都部署在以下版本系统中
Distributor ID: CentOS
Description:    CentOS Linux release 7.5.1804 (Core) 
Release:        7.5.1804



Fast Reproduce Steps(Required)

我是用流模式读取ob (1.3亿左右),跑了45分钟报的是这个错 com.alipay.oceanbase.jdbc.exceptions.jdbc4.CommunicationsException: App lication was streaming results when the connection failed. Consider raising value of 'net_write_timeout' on the server. net_write_timeout这个参数默认是60s;然后我在obproxy 通过set global net_write_timeout=28800; 但是跑任务依然报相同的错(其实jdbcurl也设置了netTimeoutForStreamingResults=28800),感觉没有生效,也就是说我在服务端及客户端的jdbcUrl都尝试调大参数net_write_timeout ,但任务依然45分钟左右失败,报net_write_timeout 超时,感觉没有生效。 ps:一下参数也是设置了的 "set ob_trx_idle_timeout=172800000000;" "set wait_timeout=300000;" "set ob_query_timeout=172800000000;" "set ob_trx_timeout=172800000000;"

Actual Behavior

com.alipay.oceanbase.jdbc.exceptions.jdbc4.CommunicationsException: App lication was streaming results when the connection failed. Consider raising value of 'net_write_timeout' on the server. a326b5ea9d42bcddcf73d9245c0a5f8


Expected Behavior

1

other information

1

xiaoxinniux avatar Jun 23 '22 02:06 xiaoxinniux

observer和obproxy的版本也提供一下

caifeizhi avatar Jun 23 '22 08:06 caifeizhi

observer和obproxy的版本也提供一下

obproxy (OceanBase 3.2.0 1) observer 实例版本 3.1.1

xiaoxinniux avatar Jun 24 '22 03:06 xiaoxinniux