Unble to start HANA DB

[former_member203760]

Hi Expert,

While i am  try to start HANA DB i am getting error like below,

i have stopped correctly and trying to start. but still same issue please help me.

Thanks

JANA

[TomCenens]

Dear JANA

SAP HANA System Down, HANA not starting - Technology Troubleshooting Guide - SCN Wiki

Please check these basic troubleshooting steps in the wiki and proceed to check the alert trace file so you can provide additional information.

Without additional information it's very difficult for community members to assist you further in this error situation as the alert is way to generic and more information is needed to provide a decent quality answer.

Kind regards

Tom

[former_member203760]

Hello Tom,

Thank for your quick response.please find the attached alert trace file.

[63797]{-1}[-1/-1] 2015-05-12 01:00:23.569153 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[64068]{-1}[-1/-1] 2015-05-12 01:51:00.888702 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[69181]{-1}[-1/-1] 2015-05-12 03:15:20.451015 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[69771]{-1}[-1/-1] 2015-05-12 04:15:20.736714 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[69771]{-1}[-1/-1] 2015-05-12 04:57:22.793394 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[69771]{-1}[-1/-1] 2015-05-12 12:25:42.400606 e TNS	TNSClient.cpp(00603) : nameserver hanatest:30001 not initialized. retry in 5 sec...
[69771]{-1}[-1/-1] 2015-05-12 12:25:42.400855 e TNS	TNSClient.cpp(00619) : process is terminating -> aborting nameserver retries
[69149]{-1}[-1/-1] 2015-05-12 12:25:42.403888 e TNS	TNSClient.cpp(00603) : nameserver hanatest:30001 not initialized. retry in 5 sec...
[11874]{-1}[-1/-1] 2015-05-13 07:18:57.051783 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 08:18:57.551495 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 09:18:57.863038 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11874]{-1}[-1/-1] 2015-05-13 10:18:57.942536 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 11:18:58.071849 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11874]{-1}[-1/-1] 2015-05-13 12:18:58.177718 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 13:18:58.310526 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11874]{-1}[-1/-1] 2015-05-13 14:18:58.442633 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 15:18:58.569570 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11874]{-1}[-1/-1] 2015-05-13 16:18:58.672240 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 17:18:58.771700 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11874]{-1}[-1/-1] 2015-05-13 18:18:59.111439 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 19:18:59.290036 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 20:18:59.438850 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11874]{-1}[-1/-1] 2015-05-13 21:18:59.582424 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 22:18:59.701618 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11275]{-1}[-1/-1] 2015-05-13 23:18:59.799972 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11874]{-1}[-1/-1] 2015-05-14 00:18:59.941847 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11874]{-1}[-1/-1] 2015-05-14 01:19:00.077222 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[11874]{-1}[-1/-1] 2015-05-14 02:18:08.259398 e TNS	TNSClient.cpp(00603) : nameserver hanatest:30001 not initialized. retry in 5 sec...
[11874]{-1}[-1/-1] 2015-05-14 02:18:08.259500 e TNS	TNSClient.cpp(00619) : process is terminating -> aborting nameserver retries
[11226]{-1}[-1/-1] 2015-05-14 02:18:08.261979 e TNS	TNSClient.cpp(00603) : nameserver hanatest:30001 not initialized. retry in 5 sec...
[6570]{-1}[-1/-1] 2015-05-14 03:40:25.679434 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[6570]{-1}[-1/-1] 2015-05-14 04:40:28.292599 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[6570]{-1}[-1/-1] 2015-05-14 05:40:51.859663 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[7151]{-1}[-1/-1] 2015-05-14 06:40:53.686929 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[6570]{-1}[-1/-1] 2015-05-14 07:41:20.149570 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[7151]{-1}[-1/-1] 2015-05-14 08:41:21.687113 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[6570]{-1}[-1/-1] 2015-05-14 09:41:23.772762 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[7151]{-1}[-1/-1] 2015-05-14 10:41:24.396117 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[7151]{-1}[-1/-1] 2015-05-14 11:41:25.141169 e SrvInternal	HandlerRegistry.cpp(00078) : No handler found for: pers/trigger_update_license
[115921]{-1}[-1/-1] 2015-05-18 00:03:45.402708 e TNS	TNSClient.cpp(00603) : nameserver hanatest:30001 not initialized. retry in 5 sec...
[115921]{-1}[-1/-1] 2015-05-18 00:03:45.402838 e TNS	TNSClient.cpp(00619) : process is terminating -> aborting nameserver retries
[115884]{-1}[-1/-1] 2015-05-18 00:03:45.404721 e TNS	TNSClient.cpp(00603) : nameserver hanatest:30001 not initialized. retry in 5 sec...
[7728]{-1}[-1/-1] 2015-05-18 01:08:40.002218 e Memory	ReportMemoryProblems.cpp(00799) : OUT OF MEMORY occurred.

Host: hanatest

Executable: hdbcompileserver

PID: 7708

Failed to allocate 32808 byte.

Current callstack:

1: 0x00007fbdc4f7d7fd in MemoryManager::PoolAllocator::allocateNoThrowImpl(unsigned long, void const*)+0x2a9 at PoolAllocator.cpp:1139 (libhdbbasis.so)

2: 0x00007fbdc362e84d in __alloc_dir+0x69 (libc.so.6)

3: 0x00007fbdc503d004 in System::UX::opendir(char const*)+0x20 at SystemCallsUNIX.cpp:74 (libhdbbasis.so)

4: 0x00007fbdc4e6ba78 in FileAccess::DirectoryEntry::findFirst()+0x14 at SimpleFile.cpp:600 (libhdbbasis.so)

5: 0x00007fbdc4e71a29 in FileAccess::DirectoryEntry::DirectoryEntry(char const*)+0x455 at SimpleFile.cpp:99 (libhdbbasis.so)

6: 0x00007fbdc4d6d6f0 in Diagnose::TraceSegmentCompressorThread::run(void*&)+0x1b0 at TraceSegment.cpp:162 (libhdbbasis.so)

7: 0x00007fbdc4e10759 in Execution::Thread::staticMainImp(void**)+0x875 at Thread.cpp:492 (libhdbbasis.so)

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

Memory consumption information:

[No information available.]

[7728]{-1}[-1/-1] 2015-05-18 01:08:40.031379 e Memory	ReportMemoryProblems.cpp(00884) : Out of memory occured. More information in oom runtime dump!
[7728]{-1}[-1/-1] 2015-05-18 01:08:40.437606 e Memory	ReportMemoryProblems.cpp(00894) : Finished writing oom runtime dump!
[7728]{-1}[-1/-1] 2015-05-18 01:08:40.437641 e compileserver	ljit_server_CompileService.cpp(00090) : Emergency shutdown because of out-of-memory
[7728]{-1}[-1/-1] 2015-05-18 01:08:40.437670 e Basis	ljit_server_CompileService.cpp(00045) : Process exited due to an error via explicit exit call with exit code 1 , no crash dump will be written

Thanks

Jana

[TomCenens]

Hi Jana

Can you also share your SAP HANA revision (versioning) and if this is a new installation or other relevant information?

This can still have multiple root causes so you'll need to dig deeper to find the correct one.

One example could be:

2111143 - HANA DB Crash

Please check other relevant trace files for more information.

Kind regards

Tom

[former_member203760]

Hello Tom,

I have checked as per the snote , but no entries in that fiel, HAN version is,

Please let me know which trace file you need.basically  when i have installed HANA DB it's working find i have started ECC6 EH& installation on HANA on same server, i got error in import ABAP phase like migration.monitor error,  i have that time hana is down. now i am unble to start the HANA.

Please help me.

Thanks

Jana

[TomCenens]

Hi Jana

Recommended way of troubleshooting is following the activities (steps) the system is performing.

You can see the sequence in the wiki but you should also be able to derive what is happening by looking at the trace files (during your startup attempt).

Try out the method mentioned in the wiki "If this fails ..." and check what happens.

Suggestion there is to try and start the nameserver and if that succeeds the indexserver and check logs/traces along the way.

Kind regards

Tom

[former_member203760]

Tom,

Anyway thank you for your help. i will try as per wiki and let you know if it will work,

if you have possible please share your Skype or contact no, so that i will reach you once.

thanks

Jana

[TomCenens]

Hi Jana

My gmail is in my SCN profile. We can chat there if you want.

Kind regards

Tom

[former_member203760]

Tom,

I have checked your profile but i am unable to see your gmail Id.

Thanks

Jana

[TomCenens]

If you float over my picture in this thread, you should see my mail address.

[TomCenens]

You were right though, I just changed my privacy settings now (I'll keep it open temporarily)

[former_member203760]

Thank you so much.  i have an request please add me.