Connection failed (RTE:[89006] System call 'send' failed,rc=32:Broken pipe)

[Former Member]

Dear Sir,

We are running SAP S/4HANA SP 9 Multitenant DB. Running on Kernel 742 DP 217 DBSL 217.

Since a couple days ago we are having the following error during the backup execution using DB13:

SQL Message: Connection failed (RTE:[89006] System call 'send' failed, rc=32:Broken pipe)

We found the SAP notes:

2222200 - FAQ: SAP HANA Network

2213725 - How-To: Troubleshooting of -10709 DBSQL_SQL_ERROR shortdumps

We did the following checks:

Check I:

Running se38 report ADBC_TEST_CONNECTION on PRD connection ->

Testing a Database Connection Defined in DBCON:

Could not open connection <SID>                            .

sql error     10.709- occured:

Connection failed (RTE:[89006] System call 'send' failed, rc=32:Broken pipe)

Check II:

hdbuserstore list

DATA FILE       : /home/<sidadm>/.hdb/<pas_hostname>/SSFS_HDB.DAT

KEY DEFAULT

  ENV : <hana_physical_hostname>.domain:30041**

  USER: SAPABAP1

**30041 is the tenant DB port.

Check III:

WP Log:

C  *** ERROR => Connect to database failed, rc=1, rcSQL=-10709

[dbhdbsql.cpp 512]

C  {root-id=005056835B121ED5ADA78B16A1787E14}_{conn-id=00000000000000000000000000000000}_0

C  SQLCODE    : -10709

C  SQLERRTEXT : Connection failed (RTE:[89006] System call 'send' failed, rc=32:Broken pipe)

B  ***LOG BY2=> sql error -10709 performing CON [dbds         971]

B  ***LOG BY0=> Connection failed (RTE:[89006] System call 'send' failed, rc=32:Broken pipe) [dbds         971]

B  Connect to PRD as SYSTEM with hana_vhostanme:30015

C  Try to connect as SYSTEM/<pwd>@hana_vhostanme:30015 on connection 1 …

C  *** ERROR => Connect to database failed, rc=1, rcSQL=-10709

Check IV:

The content of the /var/log/messages is the following:

Jan  5 15:19:09 PAS_PHYSICAL_HOSTNAME SAP<SID>_00[4552]: BY0 Database: > rc=32:Broken pipe)

Jan  5 15:19:09 PAS_PHYSICAL_HOSTNAME SAP<SID>_00[4552]: BY0 Database: > rc=32:Broken pipe)

Jan  5 15:19:09 PAS_PHYSICAL_HOSTNAME SAP<SID>_00[4552]: BY0 Database: > rc=32:Broken pipe)

Jan  5 15:19:09 PAS_PHYSICAL_HOSTNAME SAP<SID>_00[4552]: BY0 Database: > rc=32:Broken pipe)

…..

Best Regards,

Erick Ilarraza

[Former Member]

Can you try updating with latest DBSL PL

[viktar_vankevich]

Hi Erick,

did you solve your problem?

I've exactly the same issue.

kind regards,

Viktar

[former_member183326]

Check if the Hdbuserstore keys are correct .

[viktar_vankevich]

Hello Michael,

how could I check it?

Here is output of hdbuserstore list:

hybris:hybadm 8> hdbuserstore list

DATA FILE       : /home/hybadm/.hdb/hybris/SSFS_HDB.DAT

KEY FILE        : /home/hybadm/.hdb/hybris/SSFS_HDB.KEY

KEY DEFAULT

  ENV : 192.168.131.3:30050

  USER: SAPABAP1

kind regards,

Viktar

[Former Member]

as per your check III

the connect to DB failed for user system.

ERROR => Connect to database failed, rc=1, rcSQL=-10709

please check the test connection in dbacockpit and if connection fails with same error then password may need to be updated.

[Former Member]

Hello,

Thanks a lot for your reply.

The error in DB13 is the same:

SQL Message: Connection failed (RTE:[89006] System call 'send' failed, rc=32:Broken pipe)

The user that runs the Job, is an ABAP Dialog User. It is not blocked, in fact we are working with it to perform BC tasks. Also not roles or chages are registered for this user since november. The current error started 2 days ago.

Best Regards,

Erick Ilarraza