HANA Studio连接不上Hana Server

回复 15# gold


@gold，  我想说，太感谢了，历经了多次的求救和奋斗以后，根据你的步骤，终于连接成功，密码就是HANAabc123，问题是，我感觉（1）要关闭firewall，但是我在运行（stop）这个SuSEfirewall2_init & SuSEfirewall2_setup 时，一直有如下问题：hanadb:/etc/init.d # SuSEfirewall2_setup stop
If 'SuSEfirewall2_setup' is not a typo you can run the following command to lookup the package that contains the binary:
    command-not-found SuSEfirewall2_setup
bash: SuSEfirewall2_setup: command not found
hanadb:/etc/init.d # SuSefirewall2_init stop
If 'SuSefirewall2_init' is not a typo you can run the following command to lookup the package that contains the binary:
    command-not-found SuSefirewall2_init
bash: SuSefirewall2_init: command not found

（2）我看了一下HDB info，发现还是index 没有启动的时候，运行了HDBstop，然后再启动了HDB start，现在5个server全部ok，ping IP或者hostname都没有问题。

（3）然后按照你的提示，我运行了hdbsql-i 00 -u system -p xxx，提示hdbsql后，我尝试了select now() from dummy，惊喜的发现居然有了结果，所以我就去连接了HANA studio，果然连接成功。


太感谢了，还有好多人都帮我想办法了，谢谢。收起

回复 15# gold


   太感谢了，非常详细，我晚上回家试试啊，然后告诉你结果，再次感谢~~收起

回复 14# gogo

我没有提Oracle啊，只是我把自己ODBC的list发出来，让大家看到里面有3个ODBC是HANA的。。。。。

   谢谢各位的耐心解答，本人实在是初级，所以很多问题都不知道该如何问起，我会努力的~~谢谢大家。

@GOGO，我一定回去多看看社区里面的帖子，谢谢~收起

回复 11# ksanajoe


  麻烦你帮我看一下，谢谢 hanadb:/usr[img]file:///C:\Users\IBM_AD~1\AppData\Local\Temp\{)_G62``_[8)(8ND1X0_M7L.gif[/img]p/HDB/HDB00> sapcontrol -nr 00 -function GetProcessList

24.01.2013 05:51:26
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, YELLOW, Initializing, 2013 01 24 05:39:11, 0:12:15, 4124
hdbnameserver, HDB Nameserver, GREEN, Running, 2013 01 24 05:39:18, 0:12:08, 4175
hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2013 01 24 05:39:54, 0:11:32, 4425
hdbindexserver, HDB Indexserver, RED, Stopped, , , -1
hdbstatisticsserver, HDB Statisticsserver, YELLOW, Initializing, 2013 01 24 05:40:00, 0:11:26, 4448
hdbxsengine, HDB XSEngine, YELLOW, Initializing, 2013 01 24 05:40:01, 0:11:25, 4454
sapwebdisp_hdb, SAP WebDispatcher, YELLOW, Scheduled, , , -1收起

我去运行了一下，没有看到30015端口号，而且，好像目前活动的端口号没有我的IP（192.168.0.30），怎么回事啊？？？
hanadb:/usr/sap/HDB/HDB00> netstat -ant|grep "LISTEN"
tcp        0      0 0.0.0.0:54984           0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:1128            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:30000           0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:30001           0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:30002           0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:30005           0.0.0.0:*               LISTEN
tcp        0      0 127.0.0.1:3350          0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:30007           0.0.0.0:*               LISTEN
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN
tcp        0      0 127.0.0.1:30008         0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:4984            0.0.0.0:*               LISTEN
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:3389            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:50013           0.0.0.0:*               LISTEN
tcp        0      0 :::111                  :::*                    LISTEN
tcp        0      0 :::22                   :::*                    LISTEN
tcp        0      0 ::1:631                 :::*                    LISTEN
tcp        0      0 ::1:25                  :::*                    LISTEN
hanadb:/usr/sap/HDB/HDB00>

还有，根据另一个帖子，http://scn.sap.com/thread/3204053
看起来我的indexserver确实没有启动，然后我运行了一下indexserver_alert_imdbhdb.trc，log如下：
NOTE: full crash dump will be written to /usr/sap/HDB/HDB00/hanadb/trace/indexserver_hanadb.30003.crashdump.04408.trc
Call stack of crashing context:
1: 0x00007eff7e0ec65b in raise+0x27 (libpthread.so.0)
2: 0x00007eff8aad5c3a in Basis::crashImpl(char const*, int, char const*, ltt::exception const&)+0xb6 at Crash.cpp:583 (libhdbbasis.so)
3: 0x00007eff8aad5c8e in Basis::crashImpl(char const*, int, ltt::exception const&)+0xa at Crash.cpp:523 (libhdbbasis.so)
4: 0x00007eff8aad5e7e in Basis::crashImpl(char const*, int, char const*)+0x6a at Crash.cpp:489 (libhdbbasis.so)
5: 0x00007eff8ab3ba3a in exit_handler+0x46 at FaultProtectionImpl.cpp:531 (libhdbbasis.so)
6: 0x000000000049949a in _exit+0x16 at LinuxMallocInitializer.cpp:143 (hdbindexserver)
7: 0x00007eff81a29e97 in ptime::CheckpointMgr::restarter(void*)+0xd3 at CheckpointMgr.cc:522 (libhdbrskernel.so)
8: 0x00007eff8103e6f0 in ptime::PtimeThread::run(void*)+0x10 at ptime_thread.h:131 (libhdbrskernel.so)
9: 0x00007eff95f779ee in TrexThreads::PoolThread::run()+0xb9a at PoolThread.cpp:254 (libhdbbasement.so)
10: 0x00007eff95f79028 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:105 (libhdbbasement.so)
11: 0x00007eff8abcdf42 in Execution::Thread::staticMainImp(void**)+0x640 at Thread.cpp:446 (libhdbbasis.so)
12: 0x00007eff8abce10d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:505 (libhdbbasis.so)
[4636]{0}[0] 2013-01-19 15:22:08.923767 f PersistenceL PersistenceFactory.cpp(00557) : start up of newdb persistence failed: exception  1: no.1000002  (ltt/impl/memory.cpp:115)
    Out of memory ; $size$=1073741824; $name$=LogRecovery; $type$=pool; $inuse_count$=2; $allocated_size$=544
exception throw location:
1: 0x00007fbe424d703f in DataRecovery::RecoverySegment::prepareBuffer()+0x2b at RecoveryHandlerImpl.cpp:152 (libhdbdataaccess.so)
2: 0x00007fbe424cd18e in DataRecovery::RecoveryHandlerImpl::pushLogSegment(DataAccess::LogSegmentBackupInfo const&, DataRecovery::LogSegment*, ltt::smartptr_handle const&)+0x3ca at RecoveryHandlerImpl.cpp:993 (libhdbdataaccess.so)
3: 0x00007fbe424cd5d7 in DataRecovery::RecoveryHandlerImpl::pushLocalLogSegment(DataRecovery::LogSegment&, DataRecovery::ReplayProgressCallback&)+0x33 at RecoveryHandlerImpl.cpp:1022 (libhdbdataaccess.so)
4: 0x00007fbe424ceea4 in DataRecovery::RecoveryHandlerImpl::RecoveryHandlerImpl(DataRecovery::LoggerImpl&, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*, unsigned long, DataAccess::OnDiskLogState&)+0x15b0 at RecoveryHandlerImpl.cpp:704 (libhdbdataaccess.so)
5: 0x00007fbe424a4fae in DataRecovery::LoggerImpl::prepareRecovery(unsigned long, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*)+0x27a at LoggerImpl.cpp:638 (libhdbdataaccess.so)
6: 0x00007fbe4221a8c2 in DataAccess::PersistenceManager::prepareLogRecovery(DataAccess::LogRecoveryCallback&, bool)+0x320 at PersistenceManagerImpl.cpp:1492 (libhdbdataaccess.so)
7: 0x00007fbe4221a9a1 in DataAccess::PersistenceManagerImpl::replayOrClearLog(bool, bool)+0x40 at PersistenceManagerImpl.cpp:2709 (libhdbdataaccess.so)
8: 0x00007fbe4221ae56 in DataAccess::PersistenceManager::replay()+0xa2 at PersistenceManagerImpl.cpp:1356 (libhdbdataaccess.so)
9: 0x00007fbe4e63dfb8 in PersistenceLayer::PersistenceFactory::startPersistence(NameServer::ServiceStartInfo&, bool, bool)+0x64 at PersistenceFactory.cpp:530 (libhdbpersistence.so)
10: 0x00007fbe4e377cdf in PersistenceController::startup(PersistenceLayer::PERSISTENCE_MODE, NameServer::ServiceStartInfo*, bool, TREX_ERROR::TRexError*)+0x133b at PersistenceController.cpp:383 (libhdblogger.so)
11: 0x00000000004a7a64 in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0xb0 at TREXIndexServer.cpp:355 (hdbindexserver)
12: 0x00000000005250ed in TRexAPI::AssignThread::run(void*)+0x39 at TREXIndexServer.cpp:260 (hdbindexserver)
13: 0x00007fbe4ee179ee in TrexThreads::PoolThread::run()+0xb9a at PoolThread.cpp:254 (libhdbbasement.so)
14: 0x00007fbe4ee19028 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:105 (libhdbbasement.so)
15: 0x00007fbe43a6df42 in Execution::Thread::staticMainImp(void**)+0x640 at Thread.cpp:446 (libhdbbasis.so)
16: 0x00007fbe43a6e10d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:505 (libhdbbasis.so)
[4636]{0}[0] 2013-01-19 15:22:09.003637 f PersistenceL PersistenceController.cpp(00385) : newdb persistence startup failed
[4636]{0}[0] 2013-01-19 15:22:09.004101 e assign       TREXIndexServer.cpp(00364) : assign failed with persistence startup error. stopping service...
[4766]{0}[0] 2013-01-19 15:22:09.567973 e parallel     Parallel.cpp(00163) : release; Allocator[702]:Pool/parallel(reset_time=(none),CATEGORY=Pool/parallel,DEPTH=2,INCLUSIVE_SIZE_IN_USE=7680B,INCLUSIVE_COUNT_IN_USE=20,INCLUSIVE_ALLOCATED_SIZE=7680B,INCLUSIVE_DEALLOCATED_SIZE=0B,INCLUSIVE_ALLOCATED_COUNT=20,INCLUSIVE_DEALLOCATED_COUNT=0,INCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,INCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_SIZE_IN_USE=7680B,EXCLUSIVE_COUNT_IN_USE=20,EXCLUSIVE_ALLOCATED_SIZE=7680B,EXCLUSIVE_DEALLOCATED_SIZE=0B,EXCLUSIVE_ALLOCATED_COUNT=20,EXCLUSIVE_DEALLOCATED_COUNT=0,EXCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,EXCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_ALLOC_ERRORS=0,MALLOC_PROXY_CACHE_MISSES=0,FLAGS=(none))
[4527]{0}[0] 2013-01-22 01:32:54.528817 f PersistenceL PersistenceFactory.cpp(00557) : start up of newdb persistence failed: exception  1: no.1000002  (ltt/impl/memory.cpp:115)
    Out of memory ; $size$=1073741824; $name$=LogRecovery; $type$=pool; $inuse_count$=2; $allocated_size$=544
exception throw location:
1: 0x00007f16fac0803f in DataRecovery::RecoverySegment::prepareBuffer()+0x2b at RecoveryHandlerImpl.cpp:152 (libhdbdataaccess.so)
2: 0x00007f16fabfe18e in DataRecovery::RecoveryHandlerImpl::pushLogSegment(DataAccess::LogSegmentBackupInfo const&, DataRecovery::LogSegment*, ltt::smartptr_handle const&)+0x3ca at RecoveryHandlerImpl.cpp:993 (libhdbdataaccess.so)
3: 0x00007f16fabfe5d7 in DataRecovery::RecoveryHandlerImpl::pushLocalLogSegment(DataRecovery::LogSegment&, DataRecovery::ReplayProgressCallback&)+0x33 at RecoveryHandlerImpl.cpp:1022 (libhdbdataaccess.so)
4: 0x00007f16fabffea4 in DataRecovery::RecoveryHandlerImpl::RecoveryHandlerImpl(DataRecovery::LoggerImpl&, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*, unsigned long, DataAccess::OnDiskLogState&)+0x15b0 at RecoveryHandlerImpl.cpp:704 (libhdbdataaccess.so)
5: 0x00007f16fabd5fae in DataRecovery::LoggerImpl::prepareRecovery(unsigned long, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*)+0x27a at LoggerImpl.cpp:638 (libhdbdataaccess.so)
6: 0x00007f16fa94b8c2 in DataAccess::PersistenceManager::prepareLogRecovery(DataAccess::LogRecoveryCallback&, bool)+0x320 at PersistenceManagerImpl.cpp:1492 (libhdbdataaccess.so)
7: 0x00007f16fa94b9a1 in DataAccess::PersistenceManagerImpl::replayOrClearLog(bool, bool)+0x40 at PersistenceManagerImpl.cpp:2709 (libhdbdataaccess.so)
8: 0x00007f16fa94be56 in DataAccess::PersistenceManager::replay()+0xa2 at PersistenceManagerImpl.cpp:1356 (libhdbdataaccess.so)
9: 0x00007f1706d6efb8 in PersistenceLayer::PersistenceFactory::startPersistence(NameServer::ServiceStartInfo&, bool, bool)+0x64 at PersistenceFactory.cpp:530 (libhdbpersistence.so)
10: 0x00007f1706aa8cdf in PersistenceController::startup(PersistenceLayer::PERSISTENCE_MODE, NameServer::ServiceStartInfo*, bool, TREX_ERROR::TRexError*)+0x133b at PersistenceController.cpp:383 (libhdblogger.so)
11: 0x00000000004a7a64 in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0xb0 at TREXIndexServer.cpp:355 (hdbindexserver)
12: 0x00000000005250ed in TRexAPI::AssignThread::run(void*)+0x39 at TREXIndexServer.cpp:260 (hdbindexserver)
13: 0x00007f17075489ee in TrexThreads::PoolThread::run()+0xb9a at PoolThread.cpp:254 (libhdbbasement.so)
14: 0x00007f170754a028 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:105 (libhdbbasement.so)
15: 0x00007f16fc19ef42 in Execution::Thread::staticMainImp(void**)+0x640 at Thread.cpp:446 (libhdbbasis.so)
16: 0x00007f16fc19f10d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:505 (libhdbbasis.so)
[4527]{0}[0] 2013-01-22 01:32:54.590691 f PersistenceL PersistenceController.cpp(00385) : newdb persistence startup failed
[4527]{0}[0] 2013-01-22 01:32:54.590833 e assign       TREXIndexServer.cpp(00364) : assign failed with persistence startup error. stopping service...
[4572]{0}[0] 2013-01-22 01:32:54.621219 e parallel     Parallel.cpp(00163) : release; Allocator[702]:Pool/parallel(reset_time=(none),CATEGORY=Pool/parallel,DEPTH=2,INCLUSIVE_SIZE_IN_USE=7680B,INCLUSIVE_COUNT_IN_USE=20,INCLUSIVE_ALLOCATED_SIZE=7680B,INCLUSIVE_DEALLOCATED_SIZE=0B,INCLUSIVE_ALLOCATED_COUNT=20,INCLUSIVE_DEALLOCATED_COUNT=0,INCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,INCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_SIZE_IN_USE=7680B,EXCLUSIVE_COUNT_IN_USE=20,EXCLUSIVE_ALLOCATED_SIZE=7680B,EXCLUSIVE_DEALLOCATED_SIZE=0B,EXCLUSIVE_ALLOCATED_COUNT=20,EXCLUSIVE_DEALLOCATED_COUNT=0,EXCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,EXCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_ALLOC_ERRORS=0,MALLOC_PROXY_CACHE_MISSES=0,FLAGS=(none))
[5234]{0}[0] 2013-01-22 15:30:33.470806 f PersistenceL PersistenceFactory.cpp(00557) : start up of newdb persistence failed: exception  1: no.1000002  (ltt/impl/memory.cpp:115)
    Out of memory ; $size$=1073741824; $name$=LogRecovery; $type$=pool; $inuse_count$=2; $allocated_size$=544
exception throw location:
1: 0x00007f5939e1a03f in DataRecovery::RecoverySegment::prepareBuffer()+0x2b at RecoveryHandlerImpl.cpp:152 (libhdbdataaccess.so)
2: 0x00007f5939e1018e in DataRecovery::RecoveryHandlerImpl::pushLogSegment(DataAccess::LogSegmentBackupInfo const&, DataRecovery::LogSegment*, ltt::smartptr_handle const&)+0x3ca at RecoveryHandlerImpl.cpp:993 (libhdbdataaccess.so)
3: 0x00007f5939e105d7 in DataRecovery::RecoveryHandlerImpl::pushLocalLogSegment(DataRecovery::LogSegment&, DataRecovery::ReplayProgressCallback&)+0x33 at RecoveryHandlerImpl.cpp:1022 (libhdbdataaccess.so)
4: 0x00007f5939e11ea4 in DataRecovery::RecoveryHandlerImpl::RecoveryHandlerImpl(DataRecovery::LoggerImpl&, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*, unsigned long, DataAccess::OnDiskLogState&)+0x15b0 at RecoveryHandlerImpl.cpp:704 (libhdbdataaccess.so)
5: 0x00007f5939de7fae in DataRecovery::LoggerImpl::prepareRecovery(unsigned long, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*)+0x27a at LoggerImpl.cpp:638 (libhdbdataaccess.so)
6: 0x00007f5939b5d8c2 in DataAccess::PersistenceManager::prepareLogRecovery(DataAccess::LogRecoveryCallback&, bool)+0x320 at PersistenceManagerImpl.cpp:1492 (libhdbdataaccess.so)
7: 0x00007f5939b5d9a1 in DataAccess::PersistenceManagerImpl::replayOrClearLog(bool, bool)+0x40 at PersistenceManagerImpl.cpp:2709 (libhdbdataaccess.so)
8: 0x00007f5939b5de56 in DataAccess::PersistenceManager::replay()+0xa2 at PersistenceManagerImpl.cpp:1356 (libhdbdataaccess.so)
9: 0x00007f5945f80fb8 in PersistenceLayer::PersistenceFactory::startPersistence(NameServer::ServiceStartInfo&, bool, bool)+0x64 at PersistenceFactory.cpp:530 (libhdbpersistence.so)
10: 0x00007f5945cbacdf in PersistenceController::startup(PersistenceLayer::PERSISTENCE_MODE, NameServer::ServiceStartInfo*, bool, TREX_ERROR::TRexError*)+0x133b at PersistenceController.cpp:383 (libhdblogger.so)
11: 0x00000000004a7a64 in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0xb0 at TREXIndexServer.cpp:355 (hdbindexserver)
12: 0x00000000005250ed in TRexAPI::AssignThread::run(void*)+0x39 at TREXIndexServer.cpp:260 (hdbindexserver)
13: 0x00007f594675a9ee in TrexThreads::PoolThread::run()+0xb9a at PoolThread.cpp:254 (libhdbbasement.so)
14: 0x00007f594675c028 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:105 (libhdbbasement.so)
15: 0x00007f593b3b0f42 in Execution::Thread::staticMainImp(void**)+0x640 at Thread.cpp:446 (libhdbbasis.so)
16: 0x00007f593b3b110d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:505 (libhdbbasis.so)
[5234]{0}[0] 2013-01-22 15:30:33.617058 f PersistenceL PersistenceController.cpp(00385) : newdb persistence startup failed
[5234]{0}[0] 2013-01-22 15:30:33.987463 e assign       TREXIndexServer.cpp(00364) : assign failed with persistence startup error. stopping service...
[5281]{0}[0] 2013-01-22 15:30:34.714118 e parallel     Parallel.cpp(00163) : release; Allocator[702]:Pool/parallel(reset_time=(none),CATEGORY=Pool/parallel,DEPTH=2,INCLUSIVE_SIZE_IN_USE=7680B,INCLUSIVE_COUNT_IN_USE=20,INCLUSIVE_ALLOCATED_SIZE=7680B,INCLUSIVE_DEALLOCATED_SIZE=0B,INCLUSIVE_ALLOCATED_COUNT=20,INCLUSIVE_DEALLOCATED_COUNT=0,INCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,INCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_SIZE_IN_USE=7680B,EXCLUSIVE_COUNT_IN_USE=20,EXCLUSIVE_ALLOCATED_SIZE=7680B,EXCLUSIVE_DEALLOCATED_SIZE=0B,EXCLUSIVE_ALLOCATED_COUNT=20,EXCLUSIVE_DEALLOCATED_COUNT=0,EXCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,EXCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_ALLOC_ERRORS=0,MALLOC_PROXY_CACHE_MISSES=0,FLAGS=(none))
[4478]{0}[0] 2013-01-23 14:33:45.422033 e Metadata     ptl_shm.cc(00520) : ShmSystem::create (size=536870912) - Cannot allocate memory
[4478]{0}[0] 2013-01-23 14:33:45.422426 e Metadata     ptl_shm.cc(00661) : ShmSystem: retry attach 0/16
[4478]{0}[0] 2013-01-23 14:33:45.435732 e Metadata     ptl_shm.cc(00520) : ShmSystem::create (size=536870912) - Cannot allocate memory
[4478]{0}[0] 2013-01-23 14:33:45.435810 e Metadata     ptl_shm.cc(00661) : ShmSystem: retry attach 1/16
[4478]{0}[0] 2013-01-23 14:33:47.604893 e Memory       PoolAllocator.cpp(00510) : Destroying allocator 'LogRecovery' with 2 blocks still allocated
[4478]{0}[0] 2013-01-23 14:33:47.604910 e Memory       PoolAllocator.cpp(00515) : Block list (including suballocators):
Block 0x00007fa580000000, size 1073741824B, flags 0x80/BigBlock, head 0x00007fa580000000, type , alloc Pool/PersistenceManager/LogRecovery, allocated at:
1: 0x00007fa778bb503f in DataRecovery::RecoverySegment::prepareBuffer()+0x2b at RecoveryHandlerImpl.cpp:152 (libhdbdataaccess.so)
Block 0x00007fa668bbf700, size 256B, flags 0x1/SmallBlock, head 0x00007fa668bbf700, type DataRecovery::RecoverySegment, alloc Pool/PersistenceManager/LogRecovery, allocated at:
1: 0x00007fa778bab0b0 in DataRecovery::RecoveryHandlerImpl::pushLogSegment(DataAccess::LogSegmentBackupInfo const&, DataRecovery::LogSegment*, ltt::smartptr_handle const&)+0x2f0 at handle_ref.hpp:430 (libhdbdataaccess.so)
[allocator contains 2 blocks, in total 1073742080B]
[4478]{0}[0] 2013-01-23 14:33:47.647428 f PersistenceL PersistenceFactory.cpp(00557) : start up of newdb persistence failed: exception  1: no.1000002  (ltt/impl/memory.cpp:115)
    Out of memory ; $size$=1073741824; $name$=LogRecovery; $type$=pool; $inuse_count$=3; $allocated_size$=1073742368
exception throw location:
1: 0x00007fa778bb503f in DataRecovery::RecoverySegment::prepareBuffer()+0x2b at RecoveryHandlerImpl.cpp:152 (libhdbdataaccess.so)
2: 0x00007fa778b94638 in DataRecovery::LogSegment::doSegmentRecovery()+0x84 at LogSegment.cpp:1447 (libhdbdataaccess.so)
3: 0x00007fa778b948fb in DataRecovery::LogSegment::load(ltt::refcounted_handle, DataRecovery::LogSegment::LoadCallback&)+0xd7 at LogSegment.cpp:1427 (libhdbdataaccess.so)
4: 0x00007fa778bab649 in DataRecovery::RecoveryHandlerImpl::pushLocalLogSegment(DataRecovery::LogSegment&, DataRecovery::ReplayProgressCallback&)+0xa5 at RecoveryHandlerImpl.cpp:1030 (libhdbdataaccess.so)
5: 0x00007fa778bacea4 in DataRecovery::RecoveryHandlerImpl::RecoveryHandlerImpl(DataRecovery::LoggerImpl&, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*, unsigned long, DataAccess::OnDiskLogState&)+0x15b0 at RecoveryHandlerImpl.cpp:704 (libhdbdataaccess.so)
6: 0x00007fa778b82fae in DataRecovery::LoggerImpl::prepareRecovery(unsigned long, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*)+0x27a at LoggerImpl.cpp:638 (libhdbdataaccess.so)
7: 0x00007fa7788f88c2 in DataAccess::PersistenceManager::prepareLogRecovery(DataAccess::LogRecoveryCallback&, bool)+0x320 at PersistenceManagerImpl.cpp:1492 (libhdbdataaccess.so)
8: 0x00007fa7788f89a1 in DataAccess::PersistenceManagerImpl::replayOrClearLog(bool, bool)+0x40 at PersistenceManagerImpl.cpp:2709 (libhdbdataaccess.so)
9: 0x00007fa7788f8e56 in DataAccess::PersistenceManager::replay()+0xa2 at PersistenceManagerImpl.cpp:1356 (libhdbdataaccess.so)
10: 0x00007fa784d1bfb8 in PersistenceLayer::PersistenceFactory::startPersistence(NameServer::ServiceStartInfo&, bool, bool)+0x64 at PersistenceFactory.cpp:530 (libhdbpersistence.so)
11: 0x00007fa784a55cdf in PersistenceController::startup(PersistenceLayer::PERSISTENCE_MODE, NameServer::ServiceStartInfo*, bool, TREX_ERROR::TRexError*)+0x133b at PersistenceController.cpp:383 (libhdblogger.so)
12: 0x00000000004a7a64 in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0xb0 at TREXIndexServer.cpp:355 (hdbindexserver)
13: 0x00000000005250ed in TRexAPI::AssignThread::run(void*)+0x39 at TREXIndexServer.cpp:260 (hdbindexserver)
14: 0x00007fa7854f59ee in TrexThreads::PoolThread::run()+0xb9a at PoolThread.cpp:254 (libhdbbasement.so)
15: 0x00007fa7854f7028 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:105 (libhdbbasement.so)
16: 0x00007fa77a14bf42 in Execution::Thread::staticMainImp(void**)+0x640 at Thread.cpp:446 (libhdbbasis.so)
17: 0x00007fa77a14c10d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:505 (libhdbbasis.so)
[4478]{0}[0] 2013-01-23 14:33:47.744132 f PersistenceL PersistenceController.cpp(00385) : newdb persistence startup failed
[4478]{0}[0] 2013-01-23 14:33:47.744336 e assign       TREXIndexServer.cpp(00364) : assign failed with persistence startup error. stopping service...
[4519]{0}[0] 2013-01-23 14:33:47.758861 e parallel     Parallel.cpp(00163) : release; Allocator[702]:Pool/parallel(reset_time=(none),CATEGORY=Pool/parallel,DEPTH=2,INCLUSIVE_SIZE_IN_USE=7680B,INCLUSIVE_COUNT_IN_USE=20,INCLUSIVE_ALLOCATED_SIZE=7680B,INCLUSIVE_DEALLOCATED_SIZE=0B,INCLUSIVE_ALLOCATED_COUNT=20,INCLUSIVE_DEALLOCATED_COUNT=0,INCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,INCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_SIZE_IN_USE=7680B,EXCLUSIVE_COUNT_IN_USE=20,EXCLUSIVE_ALLOCATED_SIZE=7680B,EXCLUSIVE_DEALLOCATED_SIZE=0B,EXCLUSIVE_ALLOCATED_COUNT=20,EXCLUSIVE_DEALLOCATED_COUNT=0,EXCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,EXCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_ALLOC_ERRORS=0,MALLOC_PROXY_CACHE_MISSES=0,FLAGS=(none))
[5657]{0}[0] 2013-01-23 14:49:05.799130 f PersistenceL PersistenceFactory.cpp(00557) : start up of newdb persistence failed: exception  1: no.1000002  (ltt/impl/memory.cpp:115)
    Out of memory ; $size$=1073741824; $name$=LogRecovery; $type$=pool; $inuse_count$=2; $allocated_size$=544
exception throw location:
1: 0x00007f491789803f in DataRecovery::RecoverySegment::prepareBuffer()+0x2b at RecoveryHandlerImpl.cpp:152 (libhdbdataaccess.so)
2: 0x00007f491788e18e in DataRecovery::RecoveryHandlerImpl::pushLogSegment(DataAccess::LogSegmentBackupInfo const&, DataRecovery::LogSegment*, ltt::smartptr_handle const&)+0x3ca at RecoveryHandlerImpl.cpp:993 (libhdbdataaccess.so)
3: 0x00007f491788e5d7 in DataRecovery::RecoveryHandlerImpl::pushLocalLogSegment(DataRecovery::LogSegment&, DataRecovery::ReplayProgressCallback&)+0x33 at RecoveryHandlerImpl.cpp:1022 (libhdbdataaccess.so)
4: 0x00007f491788fea4 in DataRecovery::RecoveryHandlerImpl::RecoveryHandlerImpl(DataRecovery::LoggerImpl&, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*, unsigned long, DataAccess::OnDiskLogState&)+0x15b0 at RecoveryHandlerImpl.cpp:704 (libhdbdataaccess.so)
5: 0x00007f4917865fae in DataRecovery::LoggerImpl::prepareRecovery(unsigned long, DataAccess::LogReplayCallback&, DataAccess::LogRecoveryCallback*)+0x27a at LoggerImpl.cpp:638 (libhdbdataaccess.so)
6: 0x00007f49175db8c2 in DataAccess::PersistenceManager::prepareLogRecovery(DataAccess::LogRecoveryCallback&, bool)+0x320 at PersistenceManagerImpl.cpp:1492 (libhdbdataaccess.so)
7: 0x00007f49175db9a1 in DataAccess::PersistenceManagerImpl::replayOrClearLog(bool, bool)+0x40 at PersistenceManagerImpl.cpp:2709 (libhdbdataaccess.so)
8: 0x00007f49175dbe56 in DataAccess::PersistenceManager::replay()+0xa2 at PersistenceManagerImpl.cpp:1356 (libhdbdataaccess.so)
9: 0x00007f49239fefb8 in PersistenceLayer::PersistenceFactory::startPersistence(NameServer::ServiceStartInfo&, bool, bool)+0x64 at PersistenceFactory.cpp:530 (libhdbpersistence.so)
10: 0x00007f4923738cdf in PersistenceController::startup(PersistenceLayer::PERSISTENCE_MODE, NameServer::ServiceStartInfo*, bool, TREX_ERROR::TRexError*)+0x133b at PersistenceController.cpp:383 (libhdblogger.so)
11: 0x00000000004a7a64 in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0xb0 at TREXIndexServer.cpp:355 (hdbindexserver)
12: 0x00000000005250ed in TRexAPI::AssignThread::run(void*)+0x39 at TREXIndexServer.cpp:260 (hdbindexserver)
13: 0x00007f49241d89ee in TrexThreads::PoolThread::run()+0xb9a at PoolThread.cpp:254 (libhdbbasement.so)
14: 0x00007f49241da028 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:105 (libhdbbasement.so)
15: 0x00007f4918e2ef42 in Execution::Thread::staticMainImp(void**)+0x640 at Thread.cpp:446 (libhdbbasis.so)
16: 0x00007f4918e2f10d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:505 (libhdbbasis.so)
[5657]{0}[0] 2013-01-23 14:49:05.831651 f PersistenceL PersistenceController.cpp(00385) : newdb persistence startup failed
[5657]{0}[0] 2013-01-23 14:49:05.831863 e assign       TREXIndexServer.cpp(00364) : assign failed with persistence startup error. stopping service...
[5677]{0}[0] 2013-01-23 14:49:05.860028 e parallel     Parallel.cpp(00163) : release; Allocator[702]:Pool/parallel(reset_time=(none),CATEGORY=Pool/parallel,DEPTH=2,INCLUSIVE_SIZE_IN_USE=7680B,INCLUSIVE_COUNT_IN_USE=20,INCLUSIVE_ALLOCATED_SIZE=7680B,INCLUSIVE_DEALLOCATED_SIZE=0B,INCLUSIVE_ALLOCATED_COUNT=20,INCLUSIVE_DEALLOCATED_COUNT=0,INCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,INCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_SIZE_IN_USE=7680B,EXCLUSIVE_COUNT_IN_USE=20,EXCLUSIVE_ALLOCATED_SIZE=7680B,EXCLUSIVE_DEALLOCATED_SIZE=0B,EXCLUSIVE_ALLOCATED_COUNT=20,EXCLUSIVE_DEALLOCATED_COUNT=0,EXCLUSIVE_MAX_SINGLE_ALLOCATION_SIZE=384B,EXCLUSIVE_PEAK_ALLOCATION_SIZE=7680B,EXCLUSIVE_ALLOC_ERRORS=0,MALLOC_PROXY_CACHE_MISSES=0,FLAGS=(none))hanadb:/usr/sap/HDB/HDB00/hanadb/trace>
有out of memory的错误，，我不太懂，请帮忙，谢谢。收起

我测试了 telnet hanadb  22（因为我看putty使用的是22端口），返回的是SSH-2.0-OpenSSH_5.1结果，我在百度上看，说是“显示的信息表示,你把连接的端口不是telenet
而是openssh的端口.”，，，，Hana默认的不是30015端口吗，为啥连接不上啊，我确认了hana server
4个server全开了（name，processor，statistic，engine），谢谢大家。收起

回复 4# ksanajoe


   需要连接JDBC？我的理解是，我现在不做开发呢，不用连接吧？我不懂，谢谢。。收起

回复 5# larry
我开启了telnet服务，连接失败。。。。
   C:\>telnet hanadb 30015正在连接hanadb...无法打开到主机的连接。 在端口 30015: 连接失败收起

C:\>telnet hanadb 30015
正在连接hanadb...无法打开到主机的连接。 在端口 30015: 连接失败收起

ODBC 吧，我不做Java开发用现在。。。谢谢收起