Skip to Content
0
Sep 11, 2022 at 01:46 PM

HANA Alert 47: 'Check a long-running serializable transactions'

240 Views

I found SAP note 1977293 - How to handle HANA Alert 47: 'Check a long-running serializable transactions'

Symptom

In SAP HANA Studio or SAP HANA Cockpit you see the Alert 47 Long-running serializable transactions

Environment

SAP HANA Database

Cause

Alert is visible when there is a long-running serializable transaction

Resolution

Close the serializable transaction in the application or kill the connection on the SAP HANA Database side.

You can close the connection on HANA by executing the SQL statement ALTER SYSTEM DISCONNECT SESSION <LOGICAL_CONNECTION_ID>.

To see the long running serializable transaction and associated LOGICAL_CONNECTION_ID execute the SQL statement select * from "_SYS_STATISTICS"."HOST_LONG_SERIALIZABLE_TRANSACTION";

---------------------

I got the result when I run this statement

select * from "_SYS_STATISTICS"."HOST_LONG_SERIALIZABLE_TRANSACTION";

I have attached the print screen of the result, as you can see the 'LOGICAL_CONNECTION_ID' are 312778 and 312766.

So, i want to close the connection, as I think it affect the server performance.

When I tried to run the following statement to close the connection, it was not able and error.

ALTER SYSTEM DISCONNECT SESSION '312766';

ALTER SYSTEM DISCONNECT SESSION '312778';

it give following error:

null

Could not execute 'ALTER SYSTEM DISCONNECT SESSION '312766''

null

How can I close the connection of these 2 'LOGICAL_CONNECTION_ID' 312778 and 312766?

image.png

image.png

Attachments

image.png (72.5 kB)
image.png (19.2 kB)