SAP Knowledge Base Article - Preview

2058212 - HANA Statisticsserver continuously restarting

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

SAP HANA 1.0, platform edition

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.