hana 自动重启
hana 在使得过程中，hdbindexserver 变黄，其他正常。过一会又自动正常。其日志为：{400715}[-1/-1] 2019-03-04 14:24:59.949727 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
{400715}[-1/-1] 2019-03-04 14:24:59.949709 i SQLSessionCmd Statement.cc(03305) : session control command is performed by 400715, user=SAPECP, application user=, application source=, query=ALTER SYSTEM CANCEL SESSION '400033'
{400723}[-1/-1] 2019-03-04 14:33:22.987403 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
{400723}[-1/-1] 2019-03-04 14:33:22.987386 i SQLSessionCmd Statement.cc(03305) : session control command is performed by 400723, user=SAPECP, application user=, application source=, query=ALTER SYSTEM CANCEL SESSION '400260'
{400744}[-1/-1] 2019-03-04 14:43:13.582868 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
{400744}[-1/-1] 2019-03-04 14:43:13.582857 i SQLSessionCmd Statement.cc(03305) : session control command is performed by 400744, user=SAPECP, application user=, application source=, query=ALTER SYSTEM CANCEL SESSION '400034'
{400750}[-1/-1] 2019-03-04 14:47:44.888780 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
{400750}[-1/-1] 2019-03-04 14:47:44.888767 i SQLSessionCmd Statement.cc(03305) : session control command is performed by 400750, user=SAPECP, application user=, application source=, query=ALTER SYSTEM CANCEL SESSION '400480'
{400751}[-1/-1] 2019-03-04 14:47:44.907865 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
{400751}[-1/-1] 2019-03-04 14:47:44.907854 i SQLSessionCmd Statement.cc(03305) : session control command is performed by 400751, user=SAPECP, application user=, application source=, query=ALTER SYSTEM CANCEL SESSION '400468'
{400753}[-1/-1] 2019-03-04 14:51:31.788440 i TraceContext TraceContext.cpp(00702) : UserName=MY_XUGH, ApplicationUserName=xugh, ApplicationName=HDBStudio, ApplicationSource=csns.sql.editor.SQLExecuteFormEditor$2$1.run(SQLExecuteFormEditor.java:920);
{400753}[-1/-1] 2019-03-04 14:51:31.788412 e Basis FaultProtectionImpl.cpp(01246) : SIGNAL 11 (SIGSEGV) caught, thread: 10813237: SqlExecutor, addr: 0x0000000000000000, time: 2019-03-04 14:51:31 000 Local
Instance ECP/00, OS Linux sapecp1db 3.0.80-0.7-default #1 SMP Tue Jun 25 18:32:49 UTC 2013 (25740f8) x86_64
----> Register Dump <----
rax: 0x0000000000000000rbx: 0x00007f03e25b04f0
rcx: 0x0000000000000000rdx: 0x00007f03db3895a0
rsi: 0x00007f03e19fbd58rdi: 0x0000000000000000
rsp: 0x00007e8928934f48rbp: 0x00007e8928934fa0
r08: 0x00007f03db13ea00r09: 0x00007e8928935030
r10: 0x00007f03fa3b6ea8r11: 0x00000000004db620
r12: 0x0000000000000000r13: 0x00007ea4aadd9a00
r14: 0x00007f03b2242000r15: 0x00007ea4aacac800
rip: 0x00007f03db09c3e8 eflg: 0x0000000000010246
cs: 0x0000 gs: 0x0000
fs: 0x0000
omsk: 0x0000000000000000cr2: 0x0000000000000000
trap: 0x000000000000000eerr: 0x0000000000000004
----> Floating-point register dump <----
foper: 0x0000 frip: 0x0000000000000000fdata: 0x0
control: 0x0000status: 0x0000tag: 0x0
mxcsr: 0x0000037fmxcr_mask: 0x0000
fp: 0x0.0000 0000 0000 0000 * 2^0x0
fp: 0x0.1fa5 0000 ffff 0000 * 2^0xc
fp: 0x0.ffff 0000 0000 0000 * 2^0x34
fp: 0x0.ffff 0000 0000 0000 * 2^0x0
fp: 0x0.ffff 0000 0000 0000 * 2^0x1
fp: 0x0.ffff 0000 0000 0000 * 2^0x0
fp: 0x0.0000 0000 0000 0000 * 2^0x0
fp: 0x0.0000 0000 0000 0000 * 2^0x0
xmm: 0x00000000.00000000.00000000.00000000
xmm: 0x0000ffff.00000000.00000000.00000000
xmm: 0x00000000.00000000.00000000.00000000
xmm: 0x00ff0000.00000000.00000000.00000000
xmm: 0x00000000.ffff0000.52007265.72757465
xmm: 0x5300206e.482d5041.8302b863.bc92750e
xmm: 0x00000000.00000000.9d6d2ae0.3e12e92b
xmm: 0x00000000.00000000.00000000.bcc3d125
xmm: 0x00000000.00000000.eaa8d7e0.40a4e5b8
xmm: 0x00000000.00000000.02020202.02020202
xmm: 0x03030303.03030303.00000000.00000000
xmm: 0x01010101.01010101.01010101.01010101
xmm: 0x01010101.01010101.ffffffff.ffffffff
xmm: 0xffffffff.ffffffff.ffffffff.ffffffff
xmm: 0xffffffff.ffffffff.01010101.01010101
xmm: 0x01010101.01010101.00000000.00000000
{400753}[-1/-1] 2019-03-04 14:51:31.788538 i Basis Helper.cpp(00500) : Using 'x64_64 ABI unwind' for stack tracing
NOTE: full crash dump will be written to /usr/sap/ECP/HDB00/sapecp1db/trace/indexserver_sapecp1db.30003.crashdump.20190304-145131.044494.trc
Call stack of crashing context:
1: 0x00007f03db09c3e8 in __GI___strcasecmp+0x24 (libc.so.6)
2: 0x00007f03e0c0ed76 in ptime::Connection::setSessionVariable(char const*, char const*, bool)+0xe2 at Connection.cc:4411 (libhdbrskernel.so)
3: 0x00007f03e0d6f6ec in ptime::SessionCodecNewdb::dClientInfo(Communication::Protocol::ClientInfoPart&, ptime::Action*)+0x268 at sm_codec_newdb.cc:4307 (libhdbrskernel.so)
4: 0x00007f03e0d79987 in ptime::SessionCodecNewdb::dExecuteString(Communication::Protocol::RequestPacket&, ptime::Action*)+0x363 at sm_codec_newdb.cc:2120 (libhdbrskernel.so)
5: 0x00007f03e0d8e7b6 in ptime::SessionCodecNewdb::dVendorMessage(ptime::orawstream&)+0x5d2 at sm_codec_newdb.cc:629 (libhdbrskernel.so)
6: 0x00007f03e0d5a88a in ptime::SessionCodec::decodeMessage(ptime::orawstream&)+0x46 at sm_codec.cc:237 (libhdbrskernel.so)
7: 0x00007f03e0da8db6 in ptime::SessionHandler::receiveMessage(ptime::CommEvent*)+0xec2 at sm_handler.cc:510 (libhdbrskernel.so)
8: 0x00007f03e0dc021c in ptime::TcpReceiver::doWork(ptime::CommMgr*)+0x938 at tcp_receiver.cc:481 (libhdbrskernel.so)
9: 0x00007f03e0dc22a0 in ptime::TcpReceiver::run(void*)+0x270 at tcp_receiver.cc:549 (libhdbrskernel.so)
10: 0x00007f03fa689af3 in TrexThreads::PoolThread::run()+0x980 at PoolThread.cpp:278 (libhdbbasement.so)
11: 0x00007f03fa68b8a8 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:124 (libhdbbasement.so)
12: 0x00007f03ee78b38b in Execution::Thread::staticMainImp(void**)+0x627 at Thread.cpp:475 (libhdbbasis.so)
13: 0x00007f03ee78b52d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:543 (libhdbbasis.so)
{-1}[-1/-1] 2019-03-04 14:52:50.778229 i Basis TraceStream.cpp(00396) : ==== Starting hdbindexserver, version 1.00.72.00.388670 (NewDB100_REL), build linuxx86_64 not set 2014-02-20 11:34:55 ld7270.wdf.sap.corp gcc (SAP release 20130125, based on SUSE gcc43-4.3.4_20091019-0.22.17.5096.1.PTF.799300) 4.3.4
{-1}[-1/-1] 2019-03-04 14:52:50.778411 i Basis TraceStream.cpp(00401) : MaxOpenFiles: 1048576
{-1}[-1/-1] 2019-03-04 14:52:50.778458 i Memory MallocProxy.cpp(01259) : Installed malloc hooks
{-1}[-1/-1] 2019-03-04 14:52:50.778461 i Basis ProcessorInfo.cpp(00657) : Using GDT segment limit to determine current CPU ID
{-1}[-1/-1] 2019-03-04 14:52:50.778462 i Basis Timer.cpp(00584) : Using RDTSC for HR timer
{-1}[-1/-1] 2019-03-04 14:52:50.778463 i Memory AllocatorImpl.cpp(01218) : Allocators activated
{-1}[-1/-1] 2019-03-04 14:52:50.778464 i Memory AllocatorImpl.cpp(01234) : Using big block segment size 268435456
{-1}[-1/-1] 2019-03-04 14:52:50.778467 w Environment Environment.cpp(00286) : Changing environment set IMSLERRPATH=/usr/sap/ECP/HDB00/exe//
{-1}[-1/-1] 2019-03-04 14:52:50.778469 w Environment Environment.cpp(00286) : Changing environment set IMSLSERRPATH=/usr/sap/ECP/HDB00/exe//
{-1}[-1/-1] 2019-03-04 14:53:15.838176 w Environment Environment.cpp(00286) : Changing environment set SSL_WITH_OPENSSL=0
{-1}[-1/-1] 2019-03-04 14:53:17.236027 i assign TREXIndexServer.cpp(00622) : assign to volume 4 started
{-1}[-1/-1] 2019-03-04 14:53:17.237016 i FileIO FileStatistics.cpp(00287) : FileFactoryConfiguration::initial(path="/usr/sap/ECP/SYS/global/hdb/backint/", AsyncWriteSubmitActive=auto,AsyncWriteSubmitBlocks=new,AsynReadSubmit=off,#SubmitQueues=1,#CompletionQueues=1)
{-1}[-1/-1] 2019-03-04 14:53:17.240392 i FileIO FileStatistics.cpp(00287) : FileFactoryConfiguration::initial(path="/usr/sap/ECP/SYS/global/hdb/backint/", AsyncWriteSubmitActive=auto,AsyncWriteSubmitBlocks=new,AsynReadSubmit=off,#SubmitQueues=1,#CompletionQueues=1)
{-1}[-1/-1] 2019-03-04 14:53:17.243840 i FileIO FileStatistics.cpp(00287) : FileFactoryConfiguration::initial(path="/hana/log/ECP/mnt00001/hdb00004/", AsyncWriteSubmitActive=auto,AsyncWriteSubmitBlocks=new,AsynReadSubmit=off,#SubmitQueues=1,#CompletionQueues=1)
{-1}[-1/-1] 2019-03-04 14:53:17.246362 i FileIO FileStatistics.cpp(00287) : FileFactoryConfiguration::initial(path="/hana/data/ECP/mnt00001/hdb00004/", AsyncWriteSubmitActive=auto,AsyncWriteSubmitBlocks=new,AsynReadSubmit=off,#SubmitQueues=1,#CompletionQueues=1)
{-1}[-1/-1] 2019-03-04 14:53:17.248770 i HistoryManager HistoryManager.cpp(00486) : Maximum garbage collection parallelity set to 80
{-1}[-1/-1] 2019-03-04 14:53:17.248960 i PhysicalPageAcce DataVolumeImpl.cpp(00543) : Open volume file(s) in "/hana/data/ECP/mnt00001/hdb00004/" (readOnly= 0, diagMode= 0)
{-1}[-1/-1] 2019-03-04 14:53:17.248977 i PhysicalPageAcce DataVolumeImpl.cpp(00556) : --confMaxFileSize= 0MB, fsysMaxFilesSize= 2048000MB --> 2048000MB
{-1}[-1/-1] 2019-03-04 14:53:17.249099 i PhysicalPageAcce DataVolumeImpl.cpp(00601) : --opened volume file "datavolume_0000.dat"
{-1}[-1/-1] 2019-03-04 14:53:17.267355 i PersistenceManag PersistenceManagerImpl.cpp(04007) : Restart page version 1 loaded (96bytes)
{-1}[-1/-1] 2019-03-04 14:53:17.267398 i PersistenceManag PersistenceManagerImpl.cpp(04032) : Initial maximum known TID after restart: 3540928841
{-1}[-1/-1] 2019-03-04 14:53:17.267403 i Logger PersistenceManagerImpl.cpp(04040) : Newest known master commit position: 0x85120537ca
{-1}[-1/-1] 2019-03-04 14:53:17.267408 i Logger PersistenceManagerImpl.cpp(04050) : Known last prepare commit position on volume 1: 0x1f2f0989
{-1}[-1/-1] 2019-03-04 14:53:17.267412 i Logger PersistenceManagerImpl.cpp(04050) : Known last prepare commit position on volume 2: 0x186537ed42
{-1}[-1/-1] 2019-03-04 14:53:17.267415 i Logger PersistenceManagerImpl.cpp(04050) : Known last prepare commit position on volume 3: 0x404e343
{-1}[-1/-1] 2019-03-04 14:53:17.267434 i PersistenceManag PersistenceManagerImpl.cpp(04104) : Known DTX volume set , 0 RTT entries
{-1}[-1/-1] 2019-03-04 14:53:52.648818 i PersistenceManag PersistenceSessionRegistry.cpp(00252) : Start loading open sessions and history cleanup files
{-1}[-1/-1] 2019-03-04 14:53:58.786392 i Logger PersistenceSessionRegistry.cpp(00998) : Open session count at restart: 2/2, max known TID at restart: 3540928841
{-1}[-1/-1] 2019-03-04 14:53:58.786419 i PersistenceManag PersistenceSessionRegistry.cpp(00259) : Loading 2 open session(s) and 2234 history cleanup file(s) finished in 12.2751 seconds;
{-1}[-1/-1] 2019-03-04 14:53:59.378224 i Service_StartupContMgr.cc(00076) : Initializing system catalog.
{-1}[-1/-1] 2019-03-04 14:53:59.672008 i Service_StartupContMgr.cc(00198) : Initializing system catalog done.
{-1}[-1/-1] 2019-03-04 14:55:45.590749 i Service_StartupCheckpointMgr.cc(01327) :- RS segment loading progress: 10% done
{-1}[-1/-1] 2019-03-04 14:55:45.828404 i Service_StartupCheckpointMgr.cc(00682) : 890 RS segments loaded from Persistency in 105.11999999731779 sec (541.85692543239509MB/s)
{-1}[-1/-1] 2019-03-04 14:55:45.831432 i Service_StartupMemSystem.cc(00143) : total memory size (MB) = 1033909
{-1}[-1/-1] 2019-03-04 14:55:45.831575 i Logger PersistenceManagerImpl.cpp(02273) : Preparing log recovery handler, start position 0x8512053804
{-1}[-1/-1] 2019-03-04 14:55:45.831887 i Logger LoggerImpl.cpp(00441) : Setting log segment size to 4096MB, original value was 1024MB
{-1}[-1/-1] 2019-03-04 14:55:45.831897 i Logger LoggerImpl.cpp(00444) : Setting log segment backup timeout to 1800s, original value was 0s
{-1}[-1/-1] 2019-03-04 14:55:45.896023 i PersistenceManag PersistenceManagerImpl.cpp(03508) : BACKUP DATA seems to have been executed, database should be recoverable from backup
{-1}[-1/-1] 2019-03-04 14:55:45.896053 i Logger PersistenceManagerImpl.cpp(03701) : Deactivating REDO logging for log replay
{-1}[-1/-1] 2019-03-04 14:55:45.896056 i Logger PersistenceManagerImpl.cpp(03712) : Start termination of rollback(s) open in restart/backup savepoint
{-1}[-1/-1] 2019-03-04 14:55:45.932211 i Logger PersistenceManagerImpl.cpp(03720) : Termination of rollback(s) open in restart/backup savepoint finished in 0.000101 seconds;
{-1}[-1/-1] 2019-03-04 14:55:45.932233 i Logger PersistenceManagerImpl.cpp(03725) : Start garbage collection of history files
{-1}[-1/-1] 2019-03-04 14:55:46.573556 i Logger PersistenceManagerImpl.cpp(03736) : Garbage collection of history files finished: 2234 cleanup files in 0.641316 seconds;
{-1}[-1/-1] 2019-03-04 14:55:46.573568 i Logger PersistenceManagerImpl.cpp(03752) : Expecting savepoint 757389 log record as first log record at 0x8512053804
{-1}[-1/-1] 2019-03-04 14:55:46.573768 i Logger RecoveryHandlerImpl.cpp(00936) : RecoveryQueueCount used: 64
{-1}[-1/-1] 2019-03-04 14:55:51.821920 i Logger RecoveryHandlerImpl.cpp(00374) : Stopping parsing of open segment LogSegment at file position 426987520, unused rest 3867979776B, termination reason: Invalid buffer header found at position 0x19735000 in segment 0x8511a17800
{-1}[-1/-1] 2019-03-04 14:55:51.889391 i Logger PersistenceManagerImpl.cpp(03820) : Starting log replay at position 0x8512053804
{-1}[-1/-1] 2019-03-04 14:55:51.889419 i Logger RecoveryHandlerImpl.cpp(01472) : Triggering recovery of remaining log
{-1}[-1/-1] 2019-03-04 14:55:51.889455 i Logger RecoveryHandlerImpl.cpp(01520) : Finishing log recovery, waiting for in-process and in-load segments
{-1}[-1/-1] 2019-03-04 14:55:51.895923 i Logger PersistenceManagerImpl.cpp(03037) : Found savepoint 757389 log record
{-1}[-1/-1] 2019-03-04 14:55:51.939853 i Logger RecoveryHandlerImpl.cpp(01866) : Log recovery cannot expect any more data at position 0x8512074540, load states:
- LogPartition: #segments 0/1 processed, 1/1 loaded, 1 total, last loaded LogSegment
{-1}[-1/-1] 2019-03-04 14:55:51.939911 i Logger RecoveryHandlerImpl.cpp(02166) : Recovery finished at log position 0x8512074540
有知道的吗
页:
[1]