SAP Knowledge Base Article - Preview

1827393 - High nameserver CPU usage due to incorrect landscapeVariables.properties

Symptom

The nameserver is configured to be the active SLD data supplier. After starting the database, the nameserver process continuously uses one core even though there is nearly no activity in the system.

Tasks: 156 total,   1 running, 155 sleeping,   0 stopped,   0 zombie

Cpu(s):  0.2%us,  0.3%sy,  0.0%ni, 98.2%id,  0.1%wa,  0.0%hi,  0.2%si,  0.0%st
PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND

1495 hanadm    20   0 8463m 1.7g 612m S  100  2.7   1009:34 hdbnameserver 

Using the kernel profiler trace shows that most time is spent in the following functions:

nameserver_cpu.png

Stack traces created with the command hdbcons -p <nameserver pid> 'context l -ise' would always contain the following calls:

17095[thr=46877]: SldRegistrator at 0x00007fb99649a54f in SLDDataSupplier::NamedValues::getValue...
 
1:  SLDDataSupplier::NamedValues::getValue...
 
2:  SLDDataSupplier::SLDDocument::setVariableText...
 
3:  SLDDataSupplier::SLDDocument::replaceVariablesInNode...
 
4:  SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
 
5:  SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
 
6:  SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
 
7:  SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
 
8:  SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
 
9:  SLDDataSupplier::LandscapeDescription::load...

10:  SLDDataSupplier::CIMModel::loadLandscape()...

11:  SLDDataSupplier::CIMModel::CIMModel...

12:  NameServer::SldRegistrator::generateSldXml...

13:  NameServer::SldRegistrator::doSldRegistry...

14:  NameServer::SldRegistrator::callback()...

15:  NameServer::TimerThread::run(void*)...

16:  TrexThreads::PoolThread::run()...

17:  TrexThreads::PoolThread::run(void*&)...

18:  Execution::Thread::staticMainImp(void**)...


Read more...

Environment

SAP HANA Database

Product

SAP HANA, enterprise extended edition all versions

Keywords

high cpu; nameserver; sld; sldreg.xml; hdbinst; lm_structure package; , KBA , HAN-DB , SAP HANA Database , Problem

About this page

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

Search for additional results

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