HANA Statistics server not starting

[Former Member]

I got oom errors  when i started the HANA DB.

So  i went and change the memory allocation in statistics servver.ini to 20%.

Still i got the same erros when i tried to open the backup catalog.

So i restarted the HANA (HDB stop/Start ) .

Now i am getting

FAIL: process hdbstatisticsserver HDB Statisticsserver not running

ip-172-31-9-187:/usr/sap/HA1/SYS/global/hdb> hdsstatisticsserver

-sh: hdsstatisticsserver: command not found

ip-172-31-9-187:/usr/sap/HA1/SYS/global/hdb> hdbstatisticsserver

service startup...

accepting requests at 127.0.0.1:30005; 127.0.0.2:30005

assigning to volume 6 ...

assign failed with persistence startup error. exception  1: no.70029048  (Logger/PersistenceController.cpp:288)

    try to open existing persistence data volume, but filesystem path does not exists: /hana/zedbdi/data/HA1/mnt00001/hdb00006/

exception throw location:

1: 0x00007ff2005415f1 in PersistenceController::checkVolumes(NameServer::ServiceStartInfo*)+0xdb0 at PersistenceController.cpp:288 (libhdblogger.so)

2: 0x00007ff200543125 in PersistenceController::startup(PersistenceLayer::PERSISTENCE_MODE, NameServer::ServiceStartInfo*, bool, DataAccess::TablePreloadWriteCallback*, DataAccess::TablePreloadReadCallback*, Backup::RecoverCbc_Federation*)+0x12d1 at PersistenceController.cpp:504 (libhdblogger.so)

3: 0x00007ff20b8b8df8 in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0x2e4 at TREXIndexServer.cpp:1193 (hdbstatisticsserver)

4: 0x00007ff20b8ed905 in TRexAPI::AssignThread::run(void*)+0x31 at TREXIndexServer.cpp:542 (hdbstatisticsserver)

5: 0x00007ff200e45ff8 in TrexThreads::PoolThread::run()+0x8e4 at PoolThread.cpp:402 (libhdbbasement.so)

6: 0x00007ff200e48600 in TrexThreads::PoolThread::run(void*&)+0x10 at PoolThread.cpp:175 (libhdbbasement.so)

7: 0x00007ff1e8423059 in Execution::Thread::staticMainImp(void**)+0x7e5 at Thread.cpp:467 (libhdbbasis.so)

8: 0x00007ff1e8423f2d in Execution::Thread::staticMain(void*)+0x39 at ThreadMain.cpp:26 (libhdbbasis.so)

i was just wondering what i need to do to get the statistics server running and do a backup .

Murali

[lucas_oliveira]

Hi,

Well your error is quite clear. The statistics server won't start because the data volume is not found:

"    try to open existing persistence data volume, but filesystem path does not exists: /hana/zedbdi/data/HA1/mnt00001/hdb00006/"

What happened with that folder?

If you need to reinitialize the stats server follow SAP Note 1950221.

Regards,

Lucas de Oliveira

[former_member251815]

Hi Lucas ,

   I was looking at the note.  My statistics server is embedded. Looks like i need to follow the note   2091256.

  Not sure what happened to the folder . When i restarted the HANA instance ,statistics server did not start . SO i did a hdbstatisticsserver from the prompt to start it manually.

This is a server i use it for POC . My data is still intact. But i can not do backups ?

In SAP HANA studio ,if i look at the status of the statistics server it is master,remove .

This is a standalone instance .

Murali

[former_member183326]

Were you able to find that particular file? Did you move any files?

[Former Member]

Michael,

No I did not find the directory ( file/mount point ) . The file might have been deleted/moved (may be ) by one of my cron jobs . THe reason i say this is , i move 2 weeks old log files to a different directory and delete any log file more than a week . i do a weekly backup(Full) .

So to answer your question , yes there a fair chance the file id deleted.

I am looking at my options for data /packages ( as i can not backup up the instance s of Now )

Murali