2202893 – HANA database Fail to start up during upgrade to Rev100 or Rev101


If HANA database started from before than Rev60, and it was upgraded to Rev100 or Rev101, startup of any HANA services can fail with following error.
[00000]{0}[0/0] 0000-00-00 00:00:00.000000 e Service_Startup  md_conv_util.cc(…) ……
[00000]{0}[0/0] 0000-00-00 00:00:00.000000 e assign TREXIndexServer.cpp(…) : assign failed with ltt exception. stopping service… :
[00000]{0}[0/0] 0000-00-00 00:00:00.000000 i Service_Shutdown TrexService.cpp(…) : Preparing for shutting service down
[00000]{0}[0/0] 0000-00-00 00:00:00.000000 e Row_Engine msglog.cc(…) :
10638[thr=109420]: Assign at

5: 0x00007f8a08ab2d31 in ptime::Catalog::runAutomatedMigration(bool)+0xb00 at catalog.cc:2197 (libhdbrskernel.so)
6: 0x00007f8a08ac589a in ptime::Catalog::convertDBImageAfterRestart()+0x6b6 at catalog.cc:596 (libhdbrskernel.so)
7: 0x00007f8a0a2b250f in ptime::PTimeFactory::checkAndCompensateMetadata()+0x1db at ptime_factory.cc:692 (libhdbrskernel.so)
8: 0x00007f8a2960813d in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0x4b9 at TREXIndexServer.cpp:1256 (hdbindexserver)
9: 0x00007f8a29640ca5 in TRexAPI::AssignThread::run(void*)+0x31 at TREXIndexServer.cpp:537 (hdbindexserver)
10: 0x00007f8a1e5090eb in TrexThreads::PoolThread::run()+0x9b7 at PoolThread.cpp:284 (libhdbbasement.so)
11: 0x00007f8a1e50b1a0 in TrexThreads::PoolThread::run(void*&)+0x10 at PoolThread.cpp:134 (libhdbbasement.so)
12: 0x00007f8a05c2cc39 in Execution::Thread::staticMainImp(void**)+0x7e5 at Thread.cpp:492 (libhdbbasis.so)
13: 0x00007f8a05c2dafd in Execution::Thread::staticMain(void*)+0x39 at ThreadMain.cpp:26 (libhdbbasis.so)
[00000]{0}[0/0] 0000-00-00 00:00:00.000000 e Row_Engine msglog.cc(00082) : error during execution of Auto migration. (ecode: 16) detail : statement retry (at ptime/query/catalog/systables.cc:…)
[00000]{0}[0/0] 0000-00-00 00:00:00.000000 e assign TREXIndexServer.cpp(01724) : assign failed with ltt exception. stopping service… :
[00000]{0}[0/0] 0000-00-00 00:00:00.000000 i Service_Shutdown TrexService.cpp(00784) : Preparing for shutting service down

Important Terms:
Platform components: SAP HANA database
Technical terms: start up failure, upgrade failure

Reason and Prerequisites

Due to programming error, the result of metadata migration of Rev60 can lead a failure of metadata migration of Rev100.
SAP HANA database started before than Revision 60 and it was upgraded to Revision 100 or 101. If it started from or after than Rev 60, this issue won’t happen.
In example, the database has been upgraded through RevXX -> Rev6x -> Rev69.07 (-> RevXX) -> Rev100 / Rev101, then this issue can happen.
This issue won’t happen on a upgrade path Rev 60 -> Rev69.07 (-> RevXX) -> Rev100 / Rev101, because metadata migration of Rev60 was not executed.


This issue is fixed in Rev102. If you have HANA database started before than Revision 60 and has a plan to upgrade to SPS10, please use Revision 102 or later.
Once this issue happens, recover system from BACKUP again.

One Response

  1. Kim Robins October 31, 2016

Leave a Reply