Symptom
You are observing a frequent amount of restarts of the statisticsserver service of your HANA database.
If you check the statisticsserver tracefiles in HANA shared directory /usr/sap/SID/HDBxx/<hostname>/trace/statisticsserver_<hostname>.30005.xxx.trc you find the following entries:
i TraceContext TraceContext.cpp(00702) : UserName=_SYS_STATISTICS, ApplicationName=StatisticsServer
e Lock translock.cc(00190) : Failed to get table location during table lock, TRANSACTION_ID=5 ,
UPDATE_TRANSACTION_ID=0 , Schemaname=_SYS_STATISTICS , Table name=HOST_RESOURCE_UTILIZATION_STATISTICS ,
error=table does not exist;_SYS_STATISTICS:HOST_RESOURCE_UTILIZATION_STATISTICS
Read more...
Environment
- SAP HANA Database Revsion SPS 08 and earlier revisions.
- Up to SPS 08 the SAP HANA topology is maintained by the nameserver and so it is theoretically possible that the nameserver and the indexserver have inconsistent information.
Starting with SPS 09 this check is obsolete because the nameserver no longer maintains topology meta data.
Product
Keywords
crash, inconsistency, statistics server; repairTopology; nameserver; meta data; , 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.