SAP Knowledge Base Article - Preview

3295357 - Scriptserver cannot bind a port at system startup

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.