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
KBA , HAN-DB , SAP HANA Database , Problem
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.