Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

Deadlocks in SAP HANA

|| || 1

Deadlocks in SAP HANA
Stechies

Hello Friends,

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

Thank You.


Comments

  • 17 Feb 2015 6:19 pm 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?


Advertisement
Advertisement