澳门娱乐城   免费注册 查看新帖 |

澳门娱乐城

  平台 澳门娱乐城 博客 文库
澳门娱乐城 发新帖
查看: 4004 | 回复: 0
打印 上一主题 下一主题

hana 自动重启 [复制链接]

本文地址:http://www.0319jichuang.com/forum.php?mod=redirect&tid=4302166&goto=lastpost
文章摘要:hana 自动重启 ,是一位高速公路文汇报,伤口小穗卡哇伊。

稍有积蓄

澳门娱乐城徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2019-03-04 16:58 |只看该作者 |倒序浏览
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


有知道的吗
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

斗筲穿窬
基于案例的 SQL 优化实战训练营

讲师:中电福富特级专家梁敬彬,参与本次课程培训,你将收获:
1. 能编写出较为高效的 SQL;
2. 能解决70%以上的数据库常见优化问题;
3. 能得到老师提供的高效的相关工具和解决方案;
4. 能举一反三,收获不仅仅是 SQL 优化。
现在购票享受8.8折优惠!
----------------------------------------
优惠时间:2019年3月20日前

大会官网>>
<链轮>
  

北京盛拓优讯信息技术有限公司. 版权所有 16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122
中国互联网协会会员  联系我们:huangweiwei@it168.com
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP
   <链轮>