What happens in case of deadlocks in SAP HANA? If anyone know the complete scenario then please explain that here.
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?
Sign up for STechies
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.