Skip to Content
author's profile photo Former Member
Former Member

Trouble running AWS Hana - statisticserver and xsengine in parallel

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 , 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 , 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 >&) 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)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2014 at 07:43 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.