cancel
Showing results for 
Search instead for 
Did you mean: 

Trouble running AWS Hana - statisticserver and xsengine in parallel

Former Member
0 Kudos

Hi All,

I'm constantly running into difficulties in running SAP Hana on AWS.

The system is always running out-of-memory running leveraging scriptserver and xsengine in parallel.

For statistic server I now receive this error message even after I've deactivated the xsengine.

Any idea on how to bypassing this problem on AWS or detecting the problem.

The only thing I've done so far is doing some PAL and UI5 examples...in native HANA.

Thanks

Olli

[6983]{-1}[-1/-1] 2014-01-27 16:35:48.557345 e Memory           ReportMemoryProblems.cpp(00779) : Out of memory occured. More information in oom runtime dump!

[6983]{-1}[-1/-1] 2014-01-27 16:35:49.418068 e Memory           ReportMemoryProblems.cpp(00788) : Finished writing oom runtime dump!

[6983]{-1}[-1/-1] 2014-01-27 16:35:49.418451 f PersistenceLayer PersistenceController.cpp(00559) : startup failed exception  1: no.1000002  (ltt/impl/memory.cpp:63)

    Out of memory ; $size$=16384; $name$=StatementSnapshotManager; $type$=pool; $inuse_count$=3; $allocated_size$=49344

exception throw location:

1: 0x00007f885f90a30e in TransactionManager::LinkHash<ptime::OidCidVidTriple, int, TransactionManager::HashFunc<ptime::OidCidVidTriple>, TransactionManager::SpinRWLock, 509u, 8u>::LinkHash(bool, ltt::allocator&)+0x8a at LinkHash.h:788 (libhdbrskernel.so)

2: 0x00007f885f90777f in ptime::StmtSnapshotMgr::StmtSnapshotMgr()+0x3b at StmtSnapshotMgr.cc:165 (libhdbrskernel.so)

3: 0x00007f885f907850 in ptime::StmtSnapshotMgr::initInstance()+0x40 at StmtSnapshotMgr.cc:172 (libhdbrskernel.so)

4: 0x00007f885f8ee407 in ptime::VersionMgr::init()+0x143 at VersionMgr.cc:93 (libhdbrskernel.so)

5: 0x00007f885fbc8bba in ptime::Transaction::recover_after_log_replay(bool)+0xb6 at transmgmt.cc:5420 (libhdbrskernel.so)

6: 0x00007f885f6c4805 in ptime::Master::recover_memorydb_after_tm_init()+0x21 at ptime_master_start.cc:680 (libhdbrskernel.so)

7: 0x00007f885f6c519d in ptime::Master::poststartup()+0x29 at ptime_master_start.cc:170 (libhdbrskernel.so)

8: 0x00007f885f7db545 in ptime::DriverManager::poststartup()+0x11 at DriverManager.cc:830 (libhdbrskernel.so)

9: 0x00007f885f6c0287 in ptime::PTimeFactory::finalize()+0x23 at ptime_factory.cc:423 (libhdbrskernel.so)

10: 0x00007f888023d704 in PersistenceController::startup(PersistenceLayer::PERSISTENCE_MODE, NameServer::ServiceStartInfo*, bool, DataAccess::TablePreloadWriteCallback*, DataAccess::TablePreloadReadCallback*)+0x5c0 at PersistenceController.cpp:541 (libhdblogger.so)

11: 0x00000000004a656d in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0x299 at TREXIndexServer.cpp:537 (hdbscriptserver)

12: 0x000000000051e2dd in TRexAPI::AssignThread::run(void*)+0x39 at TREXIndexServer.cpp:338 (hdbscriptserver)

13: 0x00007f8880d96087 in TrexThreads::PoolThread::run()+0x9a3 at PoolThread.cpp:276 (libhdbbasement.so)

14: 0x00007f8880d98268 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:124 (libhdbbasement.so)

15: 0x00007f8873939515 in Execution::Thread::staticMainImp(void**)+0x681 at Thread.cpp:476 (libhdbbasis.so)

16: 0x00007f88739396bd in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:544 (libhdbbasis.so)

[6983]{-1}[-1/-1] 2014-01-27 16:35:51.854167 e assign           TREXIndexServer.cpp(00563) : assign failed with persistence startup error. exception  1: no.1000002  (ltt/impl/memory.cpp:63)

    Out of memory ; $size$=16384; $name$=StatementSnapshotManager; $type$=pool; $inuse_count$=3; $allocated_size$=49344

exception throw location:

1: 0x00007f885f90a30e in TransactionManager::LinkHash<ptime::OidCidVidTriple, int, TransactionManager::HashFunc<ptime::OidCidVidTriple>, TransactionManager::SpinRWLock, 509u, 8u>::LinkHash(bool, ltt::allocator&)+0x8a at LinkHash.h:788 (libhdbrskernel.so)

2: 0x00007f885f90777f in ptime::StmtSnapshotMgr::StmtSnapshotMgr()+0x3b at StmtSnapshotMgr.cc:165 (libhdbrskernel.so)

3: 0x00007f885f907850 in ptime::StmtSnapshotMgr::initInstance()+0x40 at StmtSnapshotMgr.cc:172 (libhdbrskernel.so)

4: 0x00007f885f8ee407 in ptime::VersionMgr::init()+0x143 at VersionMgr.cc:93 (libhdbrskernel.so)

5: 0x00007f885fbc8bba in ptime::Transaction::recover_after_log_replay(bool)+0xb6 at transmgmt.cc:5420 (libhdbrskernel.so)

6: 0x00007f885f6c4805 in ptime::Master::recover_memorydb_after_tm_init()+0x21 at ptime_master_start.cc:680 (libhdbrskernel.so)

7: 0x00007f885f6c519d in ptime::Master::poststartup()+0x29 at ptime_master_start.cc:170 (libhdbrskernel.so)

8: 0x00007f885f7db545 in ptime::DriverManager::poststartup()+0x11 at DriverManager.cc:830 (libhdbrskernel.so)

9: 0x00007f885f6c0287 in ptime::PTimeFactory::finalize()+0x23 at ptime_factory.cc:423 (libhdbrskernel.so)

10: 0x00007f888023d704 in PersistenceController::startup(PersistenceLayer::PERSISTENCE_MODE, NameServer::ServiceStartInfo*, bool, DataAccess::TablePreloadWriteCallback*, DataAccess::TablePreloadReadCallback*)+0x5c0 at PersistenceController.cpp:541 (libhdblogger.so)

11: 0x00000000004a656d in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0x299 at TREXIndexServer.cpp:537 (hdbscriptserver)

12: 0x000000000051e2dd in TRexAPI::AssignThread::run(void*)+0x39 at TREXIndexServer.cpp:338 (hdbscriptserver)

13: 0x00007f8880d96087 in TrexThreads::PoolThread::run()+0x9a3 at PoolThread.cpp:276 (libhdbbasement.so)

14: 0x00007f8880d98268 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:124 (libhdbbasement.so)

15: 0x00007f8873939515 in Execution::Thread::staticMainImp(void**)+0x681 at Thread.cpp:476 (libhdbbasis.so)

16: 0x00007f88739396bd in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:544 (libhdbbasis.so)

stopping service...

[7141]{-1}[-1/-1] 2014-01-27 16:35:52.159668 e Row_Engine       msglog.cc(00092) : shutdown during DB startup (at ptime/query/catalog/sysquery.cc:3735 )

[7141]{-1}[-1/-1] 2014-01-27 16:35:52.159684 e Row_Engine       msglog.cc(00138) : Stacktrace for Context Name:Request

1: 0x00007f88738ee545 in Execution::Context::dumpStackTrace(char const*, ltt::basic_ostream<char, ltt::char_traits<char> >&) const+0x31 at Context.cpp:1492 (libhdbbasis.so)

2: 0x00007f8880da3fdc in TrexTrace::Tracer::stack(char const*, unsigned int, TrexTrace::TraceLevel const&)+0xa8 at TrexTrace.cpp:1278 (libhdbbasement.so)

3: 0x00007f885deab3f0 in ptime::__ptime_stack(char const*, char const*, int)+0x30 at msglog.cc:141 (libhdbrscommon.so)

4: 0x00000000004a4bc2 in TRexAPI::TREXIndexServer::prepareToShutdown()+0x6c0 at TREXIndexServer.cpp:2231 (hdbscriptserver)

5: 0x000000000055460b in PrepareToShutdownThread::run(void*)+0x27 at TrexService.cpp:5452 (hdbscriptserver)

6: 0x00007f8880d96087 in TrexThreads::PoolThread::run()+0x9a3 at PoolThread.cpp:276 (libhdbbasement.so)

7: 0x00007f8880d98268 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:124 (libhdbbasement.so)

8: 0x00007f8873939515 in Execution::Thread::staticMainImp(void**)+0x681 at Thread.cpp:476 (libhdbbasis.so)

9: 0x00007f88739396bd in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:544 (libhdbbasis.so)

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I've now started a new AWS image from scratch and it seems impossible, at least for me :-), to run statisticserver and xsengine in parallel.

Still seeking for any tips to solve this issue, I assume with a clean vanilla test AWS instance it should be possible to do both...

Thanks

Olli