SAP Knowledge Base Article - Preview

3023338 - HANA hang due to "Undo logging" scenario.

Symptom

  • You experience a system hang and possibly some CPU Spiking on your system.
  • From analysis of active threads at the time of issue, following section "4. How can I check if my SAP HANA database suffers from lock waits?" of SAP Note 1999998, you can see the presence of ConsistentChangeLock.
  • When investigating some more, you find the thread that is holding this lock has the call stack that contains calls similar to the below:
DataAccess::UndoFileAnchor::logUndo
DataAccess::ConsistentChange::logUndo


Read more...

Environment

  • SAP HANA, platform edition 1.0
  • SAP HANA, platform edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

Locking , CPU Spike, system hang, standstill , Mutex Wait , CPU Consumption , ConsistentChangeLock , KBA , HAN-DB-PERF , SAP HANA Database Performance , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.