intermittent RTE:[89006] System call ‘connect’ failed, rc=111:Connection refused

Question

Dear fellow practitioner,

In My production CRM box (HANA DB – fa/hana1sp12), I see the following issue intermittently ( say biweekly) in the sap work process logs.

RTE:[89006] System call ‘connect’ failed, rc=111:Connection refused (<hostname>:\

32415))

SQLERRTEXT : Connection failed (RTE:[89006] System call ‘connect’ failed, rc=111:Connection refused (<hostname>:\ C 32415)) B DBREPO: report table: ‘REPOTEXT ‘ B DBREPO: program: ‘CL_ICF_SYSTEM_LOGIN===========CP ‘ B DBREPO: state: A, lang = E, mach = 0 B ***LOG BYM=> severe DB error -10709; work process in reconnect status [dbsh 1190] B ***LOG BY4=> sql error -10709 performing SEL on table REPOTEXT [dbrepo 3169] B ***LOG BY0=> Connection failed (RTE:[89006] System call ‘connect’ failed, rc=111:Connection refused (<hostname>:32415)) [dbrepo 3169]

The availability.log denotes the unavailability of around 6 minutes.

work processes did connected post 6 minutes.

——————-

C Try to connect via secure store (DEFAULT) on connection 0 … C Attach to HDB : 1.00.122.08.1490178281 (fa/hana1sp12) C fa/hana1sp12 : build_weekstone=0000.00.0 C fa/hana1sp12 : build_time=2017-03-22 11:32:17 C Database release is HDB 1.00.122.08.1490178281 C INFO : Database ‘SID/24’ instance is running on ‘hostname’ C INFO : Connect to DB as ‘SAPSID’, connection_id=200124 C INFO : DATA AGING feature is supported by HANA C INFO : FDA feature is supported by HANA C INFO : FAE with FDA feature is supported by HANA C INFO : CACHEDVIEWTS feature is supported by HANA C INFO : DEFERRED LOB WRITING is activated C DB max. input host variables : 32767 C DB max. statement length : 104857600 C DB max. array size : 100000 C use decimal precision as length C ABAPVARCHARMODE is used C use DBSL marker map C INFO : DBSL buffer size = 1048576 C Command info enabled C Now I’m connected to HDB

———————–

Now everything is fine. R3trans returns RC0.

I have already checked few notes.

———————————–

2316463 – * -10709: Connection failed (RTE:[89006] System call ‘connect’ failed, rc=111:Connection refused

2213725 – How-To: Troubleshooting of -10709 error

——————————

hdbuserstore list gives the correct hostname and port for default key.

Please suggest what could be checked to overcome this.

Dear fellow practitioner, In My production CRM box (HANA DB - fa/hana1sp12), I see the following issue intermittently ( say biweekly) in the sap work process logs. RTE:[89006] System call 'connect' failed, rc=111:Connection refused (<hostname>:\ 32415)) SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (<hostname>:\ C 32415)) B DBREPO: report table: 'REPOTEXT ' B DBREPO: program: 'CL_ICF_SYSTEM_LOGIN===========CP ' B DBREPO: state: A, lang = E, mach = 0 B ***LOG BYM=> severe DB error -10709; work process in reconnect status [dbsh 1190] B ***LOG BY4=> sql error -10709 performing SEL on table REPOTEXT [dbrepo 3169] B ***LOG…

User Rating: Be the first one !
0
3 weeks 0 Answers 20 views 0