FAIL: process hdbindexserver HDB Indexserver-HDB not running

[former_member792667]

Can someone please help regarding this error message when starting the services

attached the traces file but I don't know how to solve. thank you

indexserver-saphana30003row-store-reorg000.txt

indexserver-saphana30003loads000.txt

indexserver-saphana30003000.txt

indexserver-alert-saphana.txt

[hugo_amo]

Hi Elinus,

Probably the log area has somehow got corrupted as per error:

[29698]{-1}[-1/-1] 2022-06-17 14:49:45.984443 e Logger RecoveryHandlerImpl.cpp(02626) : Missing log, cannot recover starting from 0x13bf2e42, restart pos 0x13bf2e80

[29332]{-1}[-1/-1] 2022-06-17 14:49:45.989467 f PersistenceLayer PersistenceController.cpp(00786) : startup failed exception 1: no.3000280 (DataAccess/impl/PersistenceManagerImpl.cpp:3243) TID: 29332

Missing log, recovery stopped at log pos 0x13bf2e42

exception throw location:

1: 0x00007f687ae25c1b in DataAccess::PersistenceManagerImpl::replayOrClearLog(bool, bool, bool, unsigned long&, unsigned long&)+0x777 at PersistenceManagerImpl.cpp:3243 (libhdbdataaccess.so)

2: 0x00007f687ae1be81 in DataAccess::PersistenceManagerImpl::replayImpl(bool)+0x260 at PersistenceManagerImpl.cpp:5179 (libhdbdataaccess.so)

3: 0x00007f687d452f0e in PersistenceLayer::PersistenceSystem::start(NameServer::ServiceStartInfo const&, bool, bool)+0x8ea at PersistenceSystem.cpp:567 (libhdbpersistence.so)

...

Meaning that some necessary logs are missing. You need to perform a recovery. This situation is explained in KBA:

2956393- SAP HANA service does not start with error "Missing log, recovery stopped at log pos"

Regards,

Hugo

[former_member792667]

Hi Hugo,

Thank you for your reply.

I have the latest backup from yesterday before it happened but I don't know where to restore this missing logs. can you help? thanks