SAP Knowledge Base Article - Preview

3068356 - SAP HANA slow startup due to Hybrid LOB initialization

Symptom

You notice SAP HANA taking longer to start. In indexserver traces, you can see entries similar to the following:

[437755]{-1}[-1/-1] 2021-05-15 18:33:12.131692 i MidSizeLobContai LOBFileIDMapping.cpp(00161) : Starting 112 threads (lob_fileid_mapping_parallel_load_count) to load file ID mappings into lobFileIDMap, lobFileIDBackMap, eidMap and ownerBackMap with 224 stripes each (lob_fileid_mapping_stripe_count), stripeFactor 28 for eidMap and ownerBackMap (lob_fileid_eid_mapping_stripe_factor).
[440414]{-1}[-1/-1] 2021-05-15 18:33:17.740385 i MidSizeLobContai LOBFileIDMapping.cpp(00355) : Producer[108] processed 794831 file ID mappings in 5.16557 seconds.
...
[440337]{-1}[-1/-1] 2021-05-15 18:33:25.143249 i MidSizeLobContai LOBFileIDMapping.cpp(00355) : Producer[97] processed 796987 file ID mappings in 12.6617 seconds.
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.636023 i MidSizeLobContai LOBFileIDMapping.cpp(00216) : Loading 88940331 file ID mappings finished in 20.5678 seconds.
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.636055 i PersistenceManag PersistentSpaceImpl.cpp(01510) : loadContainerDirectories - done.
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.636064 i PersistenceManag PersistenceManagerImpl.cpp(02309) : PersistenceManager::setState(ReadyForRestart)
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.636075 i PMRestart        PersistenceSessionRegistry.cpp(00329) : Initialize transient structures
[444115]{-1}[-1/-1] 2021-05-15 18:33:30.641438 i PMRestart        VirtualFileStatsProxy.cpp(00306) : Initialize LOB owner statistics from VirtualFiles...
[440351]{-1}[-1/-1] 2021-05-15 18:33:30.641454 i PMRestart        VirtualFileStatsProxy.cpp(00215) : Initialize VirtualFile statistics...
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.642467 i ContainerDirecto ContainerNameDirectoryImpl.cpp(01440) : Load ContainerNameDirectory...
[440849]{-1}[-1/-1] 2021-05-15 18:33:30.642468 i PMRestart        VirtualFileStatsProxy.cpp(00371) : Initialize LOB owner statistics from MidSizeLob...
[440849]{-1}[-1/-1] 2021-05-15 18:33:30.649728 i PMRestart        VirtualFileStatsProxy.cpp(00427) : LOB owner statistics initialized from MidSizeLob: 213 CD entries in 7.25 msec
[440351]{-1}[-1/-1] 2021-05-15 18:33:31.564489 i PMRestart        VirtualFileStatsProxy.cpp(00282) : VirtualFile statistics initialized: 63100/63100 CD entries in 923.02 msec
[437755]{-1}[-1/-1] 2021-05-15 18:33:32.336785 i ContainerDirecto ContainerNameDirectoryImpl.cpp(01464) : ContainerNameDirectory loaded 192587/192587 in 1.69 sec
[444115]{-1}[-1/-1] 2021-05-15 18:45:08.326197 i PMRestart        VirtualFileStatsProxy.cpp(00351) : LOB owner statistics initialized from VirtualFile: 136345778 CD entries in 11.63 min


Read more...

Environment

SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

slow, startup, hanging, taking longer, not starting, started, poor, performance , KBA , HAN-DB-PER , SAP HANA Database Persistence , 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.