Online Tutorials & Training Materials | STechies.com
Register Login

Deadlocks in SAP HANA

Chandan Singh Parihar || 17 Feb 2015 5:24 pm || 1

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?