cancel
Showing results for 
Search instead for 
Did you mean: 

increase in CPU usage in HANA

0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

HakanHaslaman
Product and Topic Expert
Product and Topic Expert

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.

Answers (0)