increase in CPU usage in HANA

[former_member732579]

We are currently running Hybris 6.6 on SAP Hana 1.0 SP12 and we have detected a sudden jump in cpu resource consumption from 1.6.2021 at 14:00 on on hybris hana prod node. At that time we have not make any deployments on production.

In logs we found a lot of :

open channel: session was forcibly closed by the remote host

19013]{-1}[-1/-1] 2021-10-14 12:46:26.857404 e SQLSession sm_handler.cc(00231) : (sockfd:383, part:<not assigned>) open channel: session was forcibly closed by the remote host
[17505]{-1}[-1/-1] 2021-10-14 12:46:26.904037 e SQLSession sm_handler.cc(00231) : (sockfd:384, part:<not assigned>) open channel: session was forcibly closed by the remote host
[94925]{-1}[-1/-1] 2021-10-14 12:46:38.257883 e SQLSession sm_handler.cc(00231) : (sockfd:211, part:<not assigned>) open channel: session was forcibly closed by the remote host
[17505]{-1}[-1/-1] 2021-10-14 12:47:42.338526 e SQLSession sm_handler.cc(00231) : (sockfd:367, part:<not assigned>) open channel: session was forcibly closed by the remote host
[107119]{-1}[-1/-1] 2021-10-14 12:48:10.452550 e SQLSession sm_handler.cc(00231) : (sockfd:367, part:<not assigned>) open channel: session was forcibly closed by the remote host
[78915]{-1}[-1/-1] 2021-10-14 12:48:38.187630 e SQLSession sm_handler.cc(00231) : (sockfd:185, part:<not assigned>) open channel: session was forcibly closed by the remote host
[78914]{-1}[-1/-1] 2021-10-14 12:49:38.104137 e SQLSession sm_handler.cc(00231) : (sockfd:263, part:<not assigned>) open channel: session was forcibly closed by the remote host
[12768]{-1}[-1/-1] 2021-10-14 12:50:38.200068 e SQLSession sm_handler.cc(00231) : (sockfd:207, part:<not assigned>) open channel: session was forcibly closed by the remote host
[9849]{-1}[-1/-1] 2021-10-14 12:51:22.553118 e SQLSession sm_handler.cc(00231) : (sockfd:209, part:<not assigned>) open channel: session was forcibly closed by the remote host
[65170]{-1}[-1/-1] 2021-10-14 12:51:22.636471 e SQLSession sm_handler.cc(00231) : (sockfd:209, part:<not assigned>) open channel: session was forcibly closed by the remote host
[141748]{-1}[-1/-1] 2021-10-14 12:51:38.237920 e SQLSession sm_handler.cc(00231) : (sockfd:207, part:<not assigned>) open channel: session was forcibly closed by the remote host
[128618]{-1}[-1/-1] 2021-10-14 12:52:38.127164 e SQLSession sm_handler.cc(00231) : (sockfd:204, part:<not assigned>) open channel: session was forcibly closed by the remote host
[43510]{-1}[-1/-1] 2021-10-14 12:53:11.205830 e SQLSession sm_handler.cc(00231) : (sockfd:204, part:<not assigned>) open channel: session was forcibly closed by the remote host
[30291]{-1}[-1/-1] 2021-10-14 12:53:38.102522 e SQLSession sm_handler.cc(00231) : (sockfd:204, part:<not assigned>) open channel: session was forcibly closed by the remote host
[105692]{-1}[-1/-1] 2021-10-14 12:54:38.253038 e SQLSession sm_handler.cc(00231) : (sockfd:204, part:<not assigned>) open channel: session was forcibly closed by the remote host
[105299]{-1}[-1/-1] 2021-10-14 12:55:38.156293 e SQLSession sm_handler.cc(00231) : (sockfd:230, part:<not assigned>) open channel: session was forcibly closed by the remote host
[37931]{-1}[-1/-1] 2021-10-14 12:56:22.284122 e SQLSession sm_handler.cc(00231) : (sockfd:230, part:<not assigned>) open channel: session was forcibly closed by the remote host
[37934]{-1}[-1/-1] 2021-10-14 12:56:22.380340 e SQLSession sm_handler.cc(00231) : (sockfd:230, part:<not assigned>) open channel: session was forcibly closed by the remote host
[105604]{-1}[-1/-1] 2021-10-14 12:56:38.078313 e SQLSession sm_handler.cc(00231) : (sockfd:230, part:<not assigned>) open channel: session was forcibly closed by the remote host
[139704]{-1}[-1/-1] 2021-10-14 12:57:38.047434 e SQLSession sm_handler.cc(00231) : (sockfd:234, part:<not assigned>) open channel: session was forcibly closed by the remote host
[73577]{-1}[-1/-1] 2021-10-14 12:58:08.621255 e SQLSession sm_handler.cc(00231) : (sockfd:300, part:<not assigned>) open channel: session was forcibly closed by the remote host
[105692]{-1}[-1/-1] 2021-10-14 12:58:38.074527 e SQLSession sm_handler.cc(00231) : (sockfd:224, part:<not assigned>) open channel: session was forcibly closed by the remote host
[128618]{-1}[-1/-1] 2021-10-14 12:59:38.245843 e SQLSession sm_handler.cc(00231) : (sockfd:300, part:<not assigned>) open channel: session was forcibly closed by the remote host
[19009]{-1}[-1/-1] 2021-10-14 13:00:38.113996 e SQLSession sm_handler.cc(00231) : (sockfd:309, part:<not assigned>) open channel: session was forcibly closed by the remote host
[32700]{-1}[-1/-1] 2021-10-14 13:01:22.605065 e SQLSession sm_handler.cc(00231) : (sockfd:309, part:<not assigned>) open channel: session was forcibly closed by the remote host
[51058]{-1}[-1/-1] 2021-10-14 13:01:22.872759 e SQLSession sm_handler.cc(00231) : (sockfd:309, part:<not assigned>) open channel: session was forcibly closed by the remote host
[136880]{-1}[-1/-1] 2021-10-14 13:01:38.236818 e SQLSession sm_handler.cc(00231) : (sockfd:309, part:<not assigned>) open channel: session was forcibly closed by the remote host
[116113]{-1}[-1/-1] 2021-10-14 13:02:38.154659 e SQLSession sm_handler.cc(00231) : (sockfd:246, part:<not assigned>) open channel: session was forcibly closed by the remote host

instance.png

performance-increase.png

expensive-statements.png

Any hints on how we can diagnoze what is causing the increase in CPU usage?

[HakanHaslaman · Accepted solution]

There was a known bug in SP12, so please check if this fix your issue:
https://launchpad.support.sap.com/#/notes/2621115

If this does not fix the issue, runtime dump should provide possibly more information.