Register Login

Deadlocks in SAP HANA

Updated May 19, 2018

Hello Friends,

What happens in case of deadlocks in SAP HANA? If anyone know the complete scenario then please explain that here.

Thank You.


  • 17 Feb 2015 6:19 pm Sushma Best Answer

    Deadlocks are situations where two or more transactions lock each other cross-wise so that no transaction will ever be able to proceed. If SAP HANA recognizes a deadlock (typically in combination with record locks), one of the transaction will be terminated and the following error is issued:

    SQL error 133: transaction rolled back by detected deadlock

    This behavior is different from other databases like Oracle where a deadlock will only terminate the current DML operation and not the whole transaction.

    Read Here about How to check if SAP HANA database suffers from lock waits?