Skip to Content

HANA garbage collection might be blocked alert

Nov 29, 2016 at 06:40 AM


avatar image
Former Member

We are on Hana 1.0 SP11, we are receiving alerts "N-IM016794632-HANA LP0 M_MVCC_TABLES shows 1809497 active versions, Garbage Collector may be blocked. Check the SA".

When I check I don't find any transaction, query and statement in blocking situation. Can somebody guide me if I can increase the threshold value from 1000000 to 180000 as whenever Active version crossed 1000000 value it generates an alert? I studied that Active version more than 8 million is problematic slowness in Hana DB.

So my question is that: can I increase the value from 1000000 to 18 million to reduce the alert frequency.

10 |10000 characters needed characters left characters exceeded

I'm not fimilair with that error? What is the error number?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tong Ning Oct 13, 2017 at 07:18 AM

Have you already checked the KBA 2169283 - FAQ: SAP HANA Garbage Collection -> 13. Is the update transaction ID range relevant for garbage collection?

Is that relevant for your case?

10 |10000 characters needed characters left characters exceeded