Attaching a Raw Dump and Displaying the Backtrace - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantageā„¢

First type the csp -mode list command to allow CSP to display what dumps are available.

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)  

Then run the Teradata system debugger utility (/usr/pde/bin/gdb) to start up a Coroner session to debug one of the raw dumps.

It is not recommended to debug a raw dump if csp is currently saving dumps.
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)