- 论坛徽章:
- 0
|
hana 在使得过程中,hdbindexserver 变黄,其他正常。过一会又自动正常。其日志为:
[45150]{400715}[-1/-1] 2019-03-04 14:24:59.949727 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
[45150]{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'
[45061]{400723}[-1/-1] 2019-03-04 14:33:22.987403 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
[45061]{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'
[46077]{400744}[-1/-1] 2019-03-04 14:43:13.582868 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
[46077]{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'
[46064]{400750}[-1/-1] 2019-03-04 14:47:44.888780 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
[46064]{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'
[44979]{400751}[-1/-1] 2019-03-04 14:47:44.907865 i TraceContext TraceContext.cpp(00702) : UserName=SAPECP
[44979]{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'
[46124]{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);
[46124]{400753}[-1/-1] 2019-03-04 14:51:31.788412 e Basis FaultProtectionImpl.cpp(01246) : SIGNAL 11 (SIGSEGV) caught, thread: 10813237[thr=46124]: 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 (25740f x86_64
----> Register Dump <----
rax: 0x0000000000000000 rbx: 0x00007f03e25b04f0
rcx: 0x0000000000000000 rdx: 0x00007f03db3895a0
rsi: 0x00007f03e19fbd58 rdi: 0x0000000000000000
rsp: 0x00007e8928934f48 rbp: 0x00007e8928934fa0
r08: 0x00007f03db13ea00 r09: 0x00007e8928935030
r10: 0x00007f03fa3b6ea8 r11: 0x00000000004db620
r12: 0x0000000000000000 r13: 0x00007ea4aadd9a00
r14: 0x00007f03b2242000 r15: 0x00007ea4aacac800
rip: 0x00007f03db09c3e8 eflg: 0x0000000000010246
cs: 0x0000 gs: 0x0000
fs: 0x0000
omsk: 0x0000000000000000 cr2: 0x0000000000000000
trap: 0x000000000000000e err: 0x0000000000000004
----> Floating-point register dump <----
foper: 0x0000 frip: 0x0000000000000000 fdata: 0x0
control: 0x0000 status: 0x0000 tag: 0x0
mxcsr: 0x0000037f mxcr_mask: 0x0000
fp[0]: 0x0.0000 0000 0000 0000 * 2^0x0
fp[1]: 0x0.1fa5 0000 ffff 0000 * 2^0xc
fp[2]: 0x0.ffff 0000 0000 0000 * 2^0x34
fp[3]: 0x0.ffff 0000 0000 0000 * 2^0x0
fp[4]: 0x0.ffff 0000 0000 0000 * 2^0x1
fp[5]: 0x0.ffff 0000 0000 0000 * 2^0x0
fp[6]: 0x0.0000 0000 0000 0000 * 2^0x0
fp[7]: 0x0.0000 0000 0000 0000 * 2^0x0
xmm[00]: 0x00000000.00000000.00000000.00000000
xmm[01]: 0x0000ffff.00000000.00000000.00000000
xmm[02]: 0x00000000.00000000.00000000.00000000
xmm[03]: 0x00ff0000.00000000.00000000.00000000
xmm[04]: 0x00000000.ffff0000.52007265.72757465
xmm[05]: 0x5300206e.482d5041.8302b863.bc92750e
xmm[06]: 0x00000000.00000000.9d6d2ae0.3e12e92b
xmm[07]: 0x00000000.00000000.00000000.bcc3d125
xmm[08]: 0x00000000.00000000.eaa8d7e0.40a4e5b8
xmm[09]: 0x00000000.00000000.02020202.02020202
xmm[10]: 0x03030303.03030303.00000000.00000000
xmm[11]: 0x01010101.01010101.01010101.01010101
xmm[12]: 0x01010101.01010101.ffffffff.ffffffff
xmm[13]: 0xffffffff.ffffffff.ffffffff.ffffffff
xmm[14]: 0xffffffff.ffffffff.01010101.01010101
xmm[15]: 0x01010101.01010101.00000000.00000000
[46124]{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: rotocol::ClientInfoPart&, ptime::Action*)+0x268 at sm_codec_newdb.cc:4307 (libhdbrskernel.so)
4: 0x00007f03e0d79987 in ptime::SessionCodecNewdb::dExecuteString(Communication: rotocol::RequestPacket&, ptime::Action*)+0x363 at sm_codec_newdb.cc:2120 (libhdbrskernel.so)
5: 0x00007f03e0d8e7b6 in ptime::SessionCodecNewdb::dVendorMessage(ptime: rawstream& +0x5d2 at sm_codec_newdb.cc:629 (libhdbrskernel.so)
6: 0x00007f03e0d5a88a in ptime::SessionCodec::decodeMessage(ptime: rawstream& +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: oolThread::run()+0x980 at PoolThread.cpp:278 (libhdbbasement.so)
11: 0x00007f03fa68b8a8 in TrexThreads: oolThread::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)
[52805]{-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 [gcc-4_3-branch revision 152973]
[52805]{-1}[-1/-1] 2019-03-04 14:52:50.778411 i Basis TraceStream.cpp(00401) : MaxOpenFiles: 1048576
[52805]{-1}[-1/-1] 2019-03-04 14:52:50.778458 i Memory MallocProxy.cpp(01259) : Installed malloc hooks
[52805]{-1}[-1/-1] 2019-03-04 14:52:50.778461 i Basis ProcessorInfo.cpp(00657) : Using GDT segment limit to determine current CPU ID
[52805]{-1}[-1/-1] 2019-03-04 14:52:50.778462 i Basis Timer.cpp(00584) : Using RDTSC for HR timer
[52805]{-1}[-1/-1] 2019-03-04 14:52:50.778463 i Memory AllocatorImpl.cpp(0121 : Allocators activated
[52805]{-1}[-1/-1] 2019-03-04 14:52:50.778464 i Memory AllocatorImpl.cpp(01234) : Using big block segment size 268435456
[52805]{-1}[-1/-1] 2019-03-04 14:52:50.778467 w Environment Environment.cpp(00286) : Changing environment set IMSLERRPATH=/usr/sap/ECP/HDB00/exe//
[52805]{-1}[-1/-1] 2019-03-04 14:52:50.778469 w Environment Environment.cpp(00286) : Changing environment set IMSLSERRPATH=/usr/sap/ECP/HDB00/exe//
[52805]{-1}[-1/-1] 2019-03-04 14:53:15.838176 w Environment Environment.cpp(00286) : Changing environment set SSL_WITH_OPENSSL=0
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.236027 i assign TREXIndexServer.cpp(00622) : assign to volume 4 started
[52832]{-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)
[52832]{-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)
[52832]{-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)
[52832]{-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)
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.248770 i HistoryManager HistoryManager.cpp(00486) : Maximum garbage collection parallelity set to 80
[52832]{-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)
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.248977 i PhysicalPageAcce DataVolumeImpl.cpp(00556) : --confMaxFileSize= 0MB, fsysMaxFilesSize= 2048000MB --> 2048000MB
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.249099 i PhysicalPageAcce DataVolumeImpl.cpp(00601) : --opened volume file "datavolume_0000.dat"
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.267355 i PersistenceManag PersistenceManagerImpl.cpp(04007) : Restart page version 1 loaded (96bytes)
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.267398 i PersistenceManag PersistenceManagerImpl.cpp(04032) : Initial maximum known TID after restart: 3540928841
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.267403 i Logger PersistenceManagerImpl.cpp(04040) : Newest known master commit position: 0x85120537ca
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.267408 i Logger PersistenceManagerImpl.cpp(04050) : Known last prepare commit position on volume 1: 0x1f2f0989
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.267412 i Logger PersistenceManagerImpl.cpp(04050) : Known last prepare commit position on volume 2: 0x186537ed42
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.267415 i Logger PersistenceManagerImpl.cpp(04050) : Known last prepare commit position on volume 3: 0x404e343
[52832]{-1}[-1/-1] 2019-03-04 14:53:17.267434 i PersistenceManag PersistenceManagerImpl.cpp(04104) : Known DTX volume set [1,2,3], 0 RTT entries
[52832]{-1}[-1/-1] 2019-03-04 14:53:52.648818 i PersistenceManag PersistenceSessionRegistry.cpp(00252) : Start loading open sessions and history cleanup files
[52832]{-1}[-1/-1] 2019-03-04 14:53:58.786392 i Logger PersistenceSessionRegistry.cpp(0099 : Open session count at restart: 2/2, max known TID at restart: 3540928841
[52832]{-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;
[52832]{-1}[-1/-1] 2019-03-04 14:53:59.378224 i Service_Startup ContMgr.cc(00076) : Initializing system catalog.
[52832]{-1}[-1/-1] 2019-03-04 14:53:59.672008 i Service_Startup ContMgr.cc(0019 : Initializing system catalog done.
[52860]{-1}[-1/-1] 2019-03-04 14:55:45.590749 i Service_Startup CheckpointMgr.cc(01327) : - RS segment loading progress: 10% done
[52860]{-1}[-1/-1] 2019-03-04 14:55:45.828404 i Service_Startup CheckpointMgr.cc(00682) : 890 RS segments loaded from Persistency in 105.11999999731779 sec (541.85692543239509MB/s)
[52832]{-1}[-1/-1] 2019-03-04 14:55:45.831432 i Service_Startup MemSystem.cc(00143) : total memory size (MB) = 1033909
[52832]{-1}[-1/-1] 2019-03-04 14:55:45.831575 i Logger PersistenceManagerImpl.cpp(02273) : Preparing log recovery handler, start position 0x8512053804
[52832]{-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
[52832]{-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
[52832]{-1}[-1/-1] 2019-03-04 14:55:45.896023 i PersistenceManag PersistenceManagerImpl.cpp(0350 : BACKUP DATA seems to have been executed, database should be recoverable from backup
[52832]{-1}[-1/-1] 2019-03-04 14:55:45.896053 i Logger PersistenceManagerImpl.cpp(03701) : Deactivating REDO logging for log replay
[52832]{-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
[52832]{-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;
[52832]{-1}[-1/-1] 2019-03-04 14:55:45.932233 i Logger PersistenceManagerImpl.cpp(03725) : Start garbage collection of history files
[52832]{-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;
[52832]{-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
[52832]{-1}[-1/-1] 2019-03-04 14:55:46.573768 i Logger RecoveryHandlerImpl.cpp(00936) : RecoveryQueueCount used: 64
[52839]{-1}[-1/-1] 2019-03-04 14:55:51.821920 i Logger RecoveryHandlerImpl.cpp(00374) : Stopping parsing of open segment LogSegment[0:0x8511a17800/Writing][GUID=DE2B0009-B835-20190304-025858-3430000008/PrevGUID=DE2B0009-B835-20190304-025858-3430000007/PersGUID=DE2B0009-B835-20140416-084048-3110000001/RestoreGUID=51E0056B-B8C5-20140416-080704-2730000001] at file position 426987520, unused rest 3867979776B, termination reason: Invalid buffer header found at position 0x19735000 in segment 0x8511a17800
[52832]{-1}[-1/-1] 2019-03-04 14:55:51.889391 i Logger PersistenceManagerImpl.cpp(03820) : Starting log replay at position 0x8512053804
[52832]{-1}[-1/-1] 2019-03-04 14:55:51.889419 i Logger RecoveryHandlerImpl.cpp(01472) : Triggering recovery of remaining log
[52832]{-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
[53045]{-1}[-1/-1] 2019-03-04 14:55:51.895923 i Logger PersistenceManagerImpl.cpp(03037) : Found savepoint 757389 log record
[53045]{-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[/hana/log/ECP/mnt00001/hdb00004/:0]: #segments 0/1 processed, 1/1 loaded, 1 total, last loaded LogSegment[0:0x8511a17800/Writing][GUID=DE2B0009-B835-20190304-025858-3430000008/PrevGUID=DE2B0009-B835-20190304-025858-3430000007/PersGUID=DE2B0009-B835-20140416-084048-3110000001/RestoreGUID=51E0056B-B8C5-20140416-080704-2730000001]
[53045]{-1}[-1/-1] 2019-03-04 14:55:51.939911 i Logger RecoveryHandlerImpl.cpp(02166) : Recovery finished at log position 0x8512074540
有知道的吗
|
|