Symptom
- Scriptserver process is failing to start with the rest of the HANA Tenant DB services, even though it's internal communications port 30255 is assigned.
- The scriptserver is getting stuck when trying to bind with port 30256 in this example, but this port is being used by another process id on the operating system.
[16183]{-1}[1/-1] 2023-01-07 00:27:43.941751 i Service_Startup tcp_listener_callback.cc(00076) : start the SQL listening port: 30256 with backlog size 128
[16183]{-1}[1/-1] 2023-01-07 00:27:43.941959 e Stream NetworkAddress.cpp(01057) : socket info for 0.0.0.0/30256_tcp: [ 18: 0100007F:7630 00000000:0000 0A 00000000:00000000 00:00000000 00000000 0 0 25492 1 0000000000000000 100 0 0 10 0 ]
[16183]{-1}[1/-1] 2023-01-07 00:27:43.969010 e Stream NetworkChannel.cpp(00607) : [7505a3eb80200017,0.0.0.0:30256,-,SES,0] Cannot bind to a local address: tcp port 30256 on one of local interfaces => socket[25492], user ""root:0", port blocked due to state TCP_LISTEN
[16183]{-1}[1/-1] 2023-01-07 00:27:43.969177 e Service_Startup sm_manager.cc(01073) : unexpected error during startSessionService: (std exception) exception 1: no.2110008 (Basis/IO/Stream/impl/NetworkChannel.cpp:1157) TID: 16183
Error address in use: $msg$, rc=98: Address already in use; $[1]$=NetworkChannelBase::bindLocal. bind failed; $Context$=[7505a3eb80200017,0.0.0.0:30256,-,SES,0]; $channel$={<NetworkChannelBase>={this=140360194817736, fd=29, refCnt=1, local=0.0.0.0/30256_tcp, remote=(invalid), state=New, pending=[----]}}; $[2]$=tcp port 30256 on one of local interfaces => socket[25492], user ""root:0", port blocked due to state TCP_LISTEN
exception throw location:
......
exception type information:
- 0: public ltt::exception@0x00007fa8fa6918e8
[16183]{-1}[1/-1] 2023-01-07 00:27:43.998480 e assign DBProxyService.cpp(00184) : assign failed with ltt exception. stopping service... :
exception 1: no.2110008 (Basis/IO/Stream/impl/NetworkChannel.cpp:1157) TID: 16183
Error address in use: $msg$, rc=98: Address already in use; $[1]$=NetworkChannelBase::bindLocal. bind failed; $Context$=[7505a3eb80200017,0.0.0.0:30256,-,SES,0]; $channel$={<NetworkChannelBase>={this=140360194817736, fd=29, refCnt=1, local=0.0.0.0/30256_tcp, remote=(invalid), state=New, pending=[----]}}; $[2]$=tcp port 30256 on one of local interfaces => socket[25492], user ""root:0", port blocked due to state TCP_LISTEN
exception throw location:
- 30256 is the typical SQL listening port for the scriptserver in this example, as can be seen from historic restarts and port bindings in the scriptserver trace file history :
[19163]{-1}[1/-1] 2021-07-03 07:56:38.338586 i Service_Startup tcp_listener_callback.cc(00075) : start the SQL listening port: 30256 with backlog size 128
.......
[30601]{-1}[1/-1] 2022-10-22 02:09:07.759474 i Service_Startup tcp_listener_callback.cc(00076) : start the SQL listening port: 30256 with backlog size 128
[30601]{-1}[1/-1] 2022-10-22 02:09:07.760588 i Basis NetworkChannel.cpp(03269) : [87daaab660200017,0.0.0.0:30256,-,SES,0] Start listening for connections on 0.0.0.0:30256
Read more...
Environment
SAP HANA Platform Edition 2.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
Service_Startup, tcp_listener_callback.cc, start the SQL listening port, NetworkAddress.cpp, Cannot bind to a local address: tcp port, port blocked due to state TCP_LISTEN, sm_manager.cc, unexpected error during startSessionService,, KBA , HAN-DB , SAP HANA Database , Problem
Error address in use
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview