how to kill a transaction

[Former Member]

Hi,

I am seeing one entry in MVCC Blocker Transaction.

348,791;hostname;30,001;-1;28;-1;28;115,208;0;ACTIVE;EXTERNAL TRANSACTION;Mar 7, 2016 3:40:39 PM;?;14,697,691;0;0;0;0;0;0;0;1,800,000;0;;0;6,408;0;0;0;0;14,697,691;-1;0;READ COMMITTED;TRUE;TRUE;0;

Connection ID is showing as -1.

can you please help me what to do?

do i need to cancel/kill the session with ID "-1"???

ALTER SYSTEM DISCONNECT SESSION '-1'

will this command work to kill the blocker transaction?

Regards,

Praveen Chanda

[Former Member · Accepted solution]

I would suggest you to check if you can cancel the transaction based on the information available in SAP Note 2092196, e.g. using:

hdbcons 'transaction c <transaction_id>'

[AtulKumarJain]

Hi Praveen,

Please check below SAP Note:

  2092196 - How-To: Terminating Sessions in SAP HANA Best Regards, Atul

[Former Member]

Right click on session -> cancel operation

Is it not working ?