17.00 - 17.05 - ロー ダンプの添付およびバックトレースの表示 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - データベースの管理

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
2020年6月
Content Type
管理
Publication ID
B035-1093-170K-JPN
Language
日本語 (日本)

まず、csp -mode listコマンドを入力して、使用可能なダンプをCSPで表示できるようにします。

foosystem:/var/opt/teradata/tddump # csp -mode list
csp: Searching for dumps in raw dump directory /var/opt/teradata/tddump
csp: 2 dumps found, 2 dumps to process
csp: Sel  ID (date-time-token)    Nodes  Event  Instigator    Status
csp: ---  ----------------------  -----  -----  ------------  ------
csp:  *   2008/09/16-14:00:40-05      1  10416  1/11/(20096)
csp:  *   2008/09/16-13:53:07-04      1  10416  0/11/(14975)  

次に、Teradata System Debuggerユーティリティ(/usr/pde/bin/gdb)を実行して、Coronerセッションを開始し、ロー ダンプの1つをデバッグします。

cspが現在ダンプを保存している場合は、ロー ダンプをデバッグすることは推奨されません。
foosystem:/var/opt/teradata/tddump # gdb
GNU gdb 6.0/13.10.00.00
Copyright 2003 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are welcome to
change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "x8664-suselinux-teradata".
(gdb) i raw
//:
2008/09/16-14:00:40-05
2008/09/16-13:53:07-04
(gdb) at raw 2008/09/16-14:00:40-05
Attaching to crash dump
//: cdbopen: *** Processing data from raw dump, please wait... ***
//: Unloading files to:  /var/opt/teradata/tdtemp/crn-daeqV1
//: Unloading file libm.so.6
//: Unloading file libcliv2.so
//: Unloading file libdl.so.2
//: Unloading file libelf.so.0
//: Unloading file libgcc_s.so.1
//: Unloading file libpthread.so.0
//: Unloading file libnsl.so.1
//: Unloading file libc.so.6
//: Unloading file libtdusr.so
//: Unloading file libthread_db.so.1
//: Unloading file ld-linux-x86-64.so.2
//: Unloading file libnss_files.so.2
//: Unloading file emffile
//: Unloading file emffile.idx
//: Unloading file libstdc++.so.6
//: Unloading file libaio.so.1
//: Unloading file librt.so.1
//: Unloading file libbz2.so.1
//: Unloading file libz.so.1
//: Unloading file libcrypt.so.1
//: Unloading file libresolv.so.2
//: Unloading file libgssapi_krb5.so
//: Unloading file libkrb5.so.3
//: Unloading file libk5crypto.so.3
//: Unloading file libcom_err.so.2
//: Unloading file libkrb5support.so.0
 *** Selecting Aborting task(s), if any
Software Versions:
PDE    = 13.10.00.00
TDBMS  = 13.10.00.00
PDEGPL = 13.10.00.00
TGTW   = 13.10.00.00
TDGSS  = 13.10.00.00
Reading symbols for task actmain...Using host libthread_db library "/lib64/
libthread_db.so.1".

   ('libdbs1.so', 2aaaaabc7000) ('libumm1.so', 2aaaaaee9000)
   ('libevl1.so', 2aaaaafec000) ('libfil1.so', 2aaaab105000)
   ('libudf.so', 2aaaab455000) ('libudt.so', 2aaaab558000)
   ('libuci.so', 2aaaab6c3000) ('libamp1.so', 2aaaab7cf000)
   ('libamp4.so', 2aaaabbf3000) ('libstp.so', 2aaaabf02000)
   ('libpdt.so', 2aaaac28d000) ('libtvsasam.so', 2aaaac3c0000)
   ('libjil.so', 2aaaac50a000) ('libnetpde.so', 2aaaac623000)
   ('libpde.so', 2aaaac75d000) ('libemf.so', 2aaaac8b1000)
   ('libpdesym.so', 2aaaac9dd000) ('libbz2.so.1', 2aaaacb06000)
   ('libpthread.so.0', 2aaaacc17000) ('libelf.so.0', 2aaaacd2e000)
   ('libnsl.so.1', 2aaaace44000) ('libalgapi.so', 2aaaacf5b000)
   ('libgeos.so.2', 2aaaad0d4000) ('libgeos_c.so.1', 2aaaad3e0000)
   ('libproj.so.0', 2aaaad4f6000) ('libgdal.so.1', 2aaaad651000)
   ('libogrx.so', 2aaaadd1d000) ('libm.so.6', 2aaaade4e000)
   ('libcrypt.so.1', 2aaaadfa3000) ('libc.so.6', 2aaaae0dc000)
   ('libstdc++.so.6', 2aaaae30e000) ('libgcc_s.so.1', 2aaaae50c000)
   ('libaio.so.1', 2aaaae61a000) ('libdl.so.2', 2aaaae71b000)
   ('libthread_db.so.1', 2aaaae81f000) ('ld-linux-x86-64.so.2', 2aaaaaaab000)
   ('libz.so.1', 2aaaae928000) ('librt.so.1', 2aaaaea3c000) done.
1//20871: Event number 33-10416-00 (severity 50, category 10), occurred on
1//20871: Tue Sep 16 14:00:40 2008, at 001-01 (Vproc 1, partition 11, task
1//20871: 20871) in system foosystem in Module , version
1//20871: PDE:13.10.00.00,TDBMS:13.10.00.00,PDEGPL:13.10.00.00,TGTW:13.10.
1//20871: 00.00,TDGSS:13.10.00.00
1//20871:  Task aborted abnormally.
1//20871:
1//20871:
1//20871:
[Switching to 1//20871]
1//20871: ---Type <return> to continue, or q <return> to quit---
0x00002aaaae16dec1 in __nanosleep_nocancel ()
   from /var/opt/teradata/tdtemp/crn-daeqV1/libc.so.6
(gdb) bt
#0  0x00002aaaae16dec1 in __nanosleep_nocancel ()
    from /var/opt/teradata/tdtemp/crn-daeqV1/libc.so.6
#1  0x00002aaaae16ddae in sleep ()
    from /var/opt/teradata/tdtemp/crn-daeqV1/libc.so.6
#2  0x00002aaaac77368e in tsksuspend (utcbp=0x2aaaaebd7d80)
    at tsk/tskport.c:404
#3  0x00002aaaac794407 in logeventreset (logmsg_p=0x2aab1441a260, resetflags=0)
    at log/logusrlib.c:959
#4  0x00002aaaabf6e1b2 in awtcheck (MessagePtr=0x2aab1441a260)
    at ../../amp/awt/awtmain.c:1244
#5  0x00002aaaac794e19 in logevent_com (eventcode=10416,
    location=<value optimized out>, length=<value optimized out>,
    dumpkind=0 '\0', resetflags=0) at log/logusrlib.c:658
#6  0x00002aaaac78a315 in prgfaultcatch (signal=339177112,
    siginfo=0x2aab12fe1000, contextp=<value optimized out>)
    at prg/prgport.c:2268
#7  <signal handler called>
#8  evlfaultgen (a=1) at ../../par/evl/evllib.c:892
#9  0x00002aab144bb678 in ?? ()
#10 0x00002aaaaac4f20f in evlinterp (cm=0x2aab14377f30, context=0x2aab143acdf8)
    at ../../par/evl/evlinterp.c:2033
#11 0x00002aaaaac7784c in evlbuild (EvlCtxt=0x2aab143acdf8,
    OutRowLoc=46914267187568, OutRowFld5=
      {fldptr = {loc = 46914268279680, ptr = 0x2aab144bb380}, statusptr =
      0x2aab144bb380, ptr = 0x2aab144bb380, loc = 46914268279680}, Sequent=0x2aab143ad0e8,
    DumRowFlag=<value optimized out>) at ../../par/evl/evlbuild.c:222
#12 0x00002aaaabfc05a8 in WalkTbl (LINK=0x2aab14378e10)
    at ../../amp/stp/stpret.c:2108
#13 0x00002aaaabfc55d4 in stpret () at ../../amp/stp/stpret.c:3613
#14 0x00002aaaac10427e in awtstphd () at ../../amp/awt/awtstphd.c:264
#15 0x00002aaaabf7106c in awtmain (argc=296775680, argv=0xabf6e615)
    at ../../amp/awt/awtmain.c:2844
#16 0x00002aaaac77404a in tsknewthread (threadargp=<value optimized out>)
    at tsk/tskport.c:1185
#17 0x00002aaaacc1d143 in start_thread ()
    from /var/opt/teradata/tdtemp/crn-daeqV1/libpthread.so.0
#18 0x00002aaaae19b74d in clone ()
    from /var/opt/teradata/tdtemp/crn-daeqV1/libc.so.6
(gdb)