SAP ERROR Error during stream send: NetworkChannel(Between linux and windows)

현상

시스템이 갑자기 느리고 프로세스들이 처리 안된느 이슈가 발생하여 원인 분석 및 조치를 진행하였다.

 

ERROR 내용 

AP 를 재시작 하였지만 현상은 동일하였습니다. 

그래서 DB Index log를 확인해보니 Network 이슈가 발생하였습니다.

[46430]{345754}[-1/-1] 2023-01-04 09:21:05.143219 e SQLSession       sm_handler.cc(02729) : (sockfd:860, channel:0x00006c4ba10a6480, event:0x00007f09990b92c0, part:152) communication error: SSL exception  1: no.2110005  (Basis/IO/Stream/impl/NetworkChannel.cpp:1735) TID: 46430     Error during stream send: NetworkChannel::sendvRawImp - ::writev failed, rc=104: Connection reset by peer; $Context$=[b17ba79581f5708,xxx:30015,xxxx:59022,UNK,0]; $channel$={<NetworkChannelSSLFilter>={<NetworkChannelBase>={this=139877580425240, fd=INVALID, refCnt=1, local=xxxxx/30015_tcp, remote=xxxx/59022_tcp, state=Closed, pending=[----]}}}

 

시스템 구성 

DB (HANADB  on linux)

AP (windows) 

 

조치 방법 

아래와 같이 서버와 hana db 에 prameter 값을 설정해 준다. 

Linux: net.core.somaxconn >= 4096 net.ipv4.tcp_max_syn_backlog >= 8192 net.ipv4.tcp_tw_recycle = 1 net.ipv4.tcp_syn_retries = 8   HANA: global.ini -> [communication] -> tcp_backlog: >= 2048 indexserver.ini -> [communication] -> maxchannels: 20000 up to 40000   If AP server is Windows, Enable TCP timestamp feature on Windows # netsh int tcp set global timestamps=enabled Recommendation is to upgrade SUSE Linux to SLES 12 SP4 or higher. As of SLES 12 SP4 or RHEL 8.x, this problem is permanently solved on Linux side with parameter net.ipv4.tcp_tw_recycle.