IDKCS001211
Teradata Database: Query failing with 9126 / 10417 - TD Snapshot AMP error - EVL Stack Overflow, no snapshot. WrittenMar 16, 2016

 
Attachments0
  

Product Categories
Teradata Database

 Problem
​Query failing with 7489 / 9126 / 10416 or 10417 - TD Snapshot AMP error -- EVL Stack Overflow, no snapshot.

Environment/Conditions/Configuration
​TDBMS 14.00.07.14
TDBMS 14.10.07.xx

Cause
​Complex query causing stack overflow exception

Solution
  • Workaround:  Simplify query
  • Code Fix:  RFC DR 174796 has been submitted (fix not yet available)
  • As stated in DR 174796:
    RFC DR 179398 can be the solution for UDF long-In-list queries.
    RFC DR 179398 is available starting from Teradata 16.10  
 
Note to Teradata GSO Base Team: Please collect messages logs from all nodes from the system and escalate the incident to the GSO DBS Recovery team.

Special Considerations

Additional Information
7489 / 9126: Stack Overflow in AMP -- 10417 : Stack overflow exception detected
 
 
Sample 1:
 
AMP/Non-AMP failure 9126 details follow:
........................................
........................................
--EVL Stack Overflow, no snapshot.--
 
 
Sample 2:
 
PROC/FUN
Location          Function                 File:Line
-------------------------------------------------------------
libpde.so         prgfaultcatch+0x1ac      prgport.c:1977
libpthread.so.0   __restore_rt            
libdbs1.so        evlinterp+0x10526        evlinterp.c:14520
libdbs1.so        evlbuild+0x7e            evlbuild.c:75
libstp.so         DoRowHashMatch+0x126f    stphjin.c:1778
libstp.so         ProbeWithRTbl+0x1397     stphjin.c:2803
libstp.so         ClassicHashJoin+0xd36    stphjin.c:3032
libstp.so         stphjin+0xd53            stphjin.c:4220
libstp.so         stpjin+0x4121            stpjin.c:8244
libstp.so         awtstphd+0x5b5           awtstphd.c:448
libstp.so         awtmain+0x30f6           awtmain.c:3066
libpde.so         tsknewthread+0x38d       tskport.c:1263
libpthread.so.0   start_thread+0x93       
libc.so.6         __clone+0x6d
 
 
Sample 3: 
 
PROC/FUN
Location          Function                       File:Line
-------------------------------------------------------------------

libpde.so         prgfaultcatch+0x219            prgport.c:2006
libpthread.so.0   __restore_rt
libfpf.so         splitString+0xc                fpfregexp.c:644
libfpf.so         regexp_replace_unicode+0xc27   fpfregexp.c:2210
libfpf.so         ExecuteRegexFunction+0x3e1     fpfregexp_anytype.cpp:3977
libfpf.so         regexp_replace+0x83            fpfregexp_anytype.cpp:3892
libfpf.so         fpfInvokeFpUdfOp+0xfa          fpfbase.cpp:1117
libdbs1.so        evlinterp+0x64a2               evlinterp.c:19390
libdbs1.so        evlbuild+0x7e                  evlbuild.c:75
libstp.so         WalkTbl+0x1065                 stpret.c:5624
libstp.so         stpret+0x3dff                  stpret.c:7494
libstp.so         awtstphd+0xaac                 awtstphd.c:627
libstp.so         awtmain+0x3be2                 awtmain.c:3357
libpde.so         tsknewthread+0x39f             tskport.c:1337
libpthread.so.0   start_thread+0xe6
libc.so.6         clone+0x6d
 
 
Sample 4:
 
PROC/FUN
Location          Function                      File:Line
------------------------------------------------------------------

libpde.so         prgfaultcatch+0x1a9           prgport.c:1990
libpthread.so.0   __restore_rt                 
libfpf.so         regexp_substr_unicode+0xc     fpfregexp.c:1586
libfpf.so         ExecuteRegexFunction+0x35b    fpfregexp_anytype.cpp:4186
libfpf.so         regexp_substr4+0x74           fpfregexp_anytype.cpp:3874
libfpf.so         fpfInvokeFpUdfOp+0xe2         fpfbase.cpp:1211
libdbs1.so        evlinterp+0x5b6b              evlinterp.c:20775
libdbs1.so        evlbuild+0x6a                 evlbuild.c:75
libstp.so         WalkTbl+0xfb5                 stpret.c:6741
libstp.so         stpret+0x41ab                 stpret.c:8761
libstp.so         awtstphd+0xaa5                awtstphd.c:635
libstp.so         awtmain+0x3d34                awtmain.c:3407
libpde.so         tsknewthread+0x3c7            tskport.c:1335
libpthread.so.0   start_thread+0xe6            
libc.so.6         clone+0x6d
 
 
Sample 5:
 
PROC/FUN
Location          Function              File:Line
----------------------------------------------------------

libpde.so         prgfaultcatch+0x1ac   prgport.c:1990
libpthread.so.0   __restore_rt         
libdbs1.so        evlinterp+0xffb5      evlinterp.c:7741
libdbs1.so        evlbuild+0x7e         evlbuild.c:75
libamp1.so        WalkTbl+0x1b35        agrlocal.c:2004
libamp1.so        agrlocal+0x213d       agrlocal.c:4074
libamp4.so        s2ssum+0x748          s2ssum.c:194
libamp4.so        awts2shd+0xac4        awts2shd.c:476
libstp.so         awtmain+0x3cca        awtmain.c:3411
libpde.so         tsknewthread+0x38d    tskport.c:1335
libpthread.so.0   start_thread+0x93    
libc.so.6         __clone+0x6d
 
 
Sample 6:
 
PROC/FUN
Location          Function                      File:Line
------------------------------------------------------------------
libpde.so         prgfaultcatch+0x1a9           prgport.c:1991
libpthread.so.0   __restore_rt                 
libstp.so         <no symbol>+0x7ffd5c3f7a49   
libdbs1.so        evlinterp+0x2d7               evlinterp.c:2961
libstp.so         LeftJoinRight+0x31e           stppjin.c:641
libstp.so         ProductJ+0x27ec               stppjin.c:2508
libstp.so         stppjin+0x92d                 stppjin.c:2816
libstp.so         stpjin+0x3b31                 stpjin.c:8820
libstp.so         awtstphd+0xb6b                awtstphd.c:658
libstp.so         awtmain+0x3f3a                awtmain.c:3484
libpde.so         tsknewthread+0x3c7            tskport.c:1346
libpthread.so.0   start_thread+0xe6            
libc.so.6         clone+0x6d
 
 
Sample 7:
 
PROC/FUN
Location          Function                      File:Line
------------------------------------------------------------------

libpde.so         prgfaultcatch+0x219   prgport.c:2006
libfpf.so         match+0xc             pcre_exec.c:416
libpthread.so.0   __restore_rt         
libfpf.so         match+0xc             pcre_exec.c:416
libfpf.so         match+0x60d           pcre_exec.c:701
libfpf.so         match+0x60d           pcre_exec.c:701
libfpf.so         match+0x268a          pcre_exec.c:1350
libfpf.so         match+0x268a          pcre_exec.c:1350
libfpf.so         match+0x60d           pcre_exec.c:701
libfpf.so         match+0x60d           pcre_exec.c:701
libfpf.so         match+0x268a          pcre_exec.c:1350
libfpf.so         match+0x268a          pcre_exec.c:1350
libfpf.so         match+0x60d           pcre_exec.c:701
libfpf.so         match+0x60d           pcre_exec.c:701
libfpf.so         match+0x268a          pcre_exec.c:1350
libfpf.so         match+0x268a          pcre_exec.c:1350
<snip...>
 
 
Sample 8:
 
PROC/FUN
Location          Function                      File:Line
------------------------------------------------------------------
libpde.so         prgfaultcatch+0x1e5           prgport.c2007
libpthread.so.0   __restore_rt
libfpf.so         compile_branch+0x10           pcre_compile.c2411
libfpf.so         compile_regex+0x1bc           pcre_compile.c5532
libfpf.so         compile_branch+0x10           pcre_compile.c2411
libfpf.so         compile_regex+0x1bc           pcre_compile.c5532
libfpf.so         compile_branch+0x5111         pcre_compile.c5009
libfpf.so         compile_regex+0x1bc           pcre_compile.c5532
libfpf.so         _pcre_compile2+0x63e          pcre_compile.c6196
libfpf.so         _pcre_compile+0x4b            pcre_compile.c5975
libfpf.so         regexp_substr_unicode+0x793   fpfregexp.c1768
libfpf.so         ExecuteRegexFunction+0x35b    fpfregexp_anytype.cpp4186
libfpf.so         regexp_substr2+0x74           fpfregexp_anytype.cpp3927
libfpf.so         fpfInvokeFpUdfOp+0xe2         fpfbase.cpp1267
libdbs1.so        evlinterp+0xd0da              evlinterp.c22454
libdbs1.so        evlbuild2+0x97                evlbuild.c94
libamp1.so        WalkTbl+0x2d9e                agrlocal.c2040
libamp1.so        agrlocal+0x2397               agrlocal.c4200
 
 
Sample 9:
 
PROC/FUN
Location          Function              File:Line
----------------------------------------------------------
libpde.so         prgfaultcatch+0x1a9   prgport.c:1990
libpthread.so.0   __restore_rt
libdbs1.so        evlinterp+0x625e      evlinterp.c:15755
libdbs1.so        evlcomp2+0x9c         evlcomp.c:157
libstp.so         RightReadNext+0x1cc6  stpmjin.c:7425
libstp.so         FSMRightOJ+0x274      stpmjin.c:7611
libstp.so         RightMOJ+0xfa         stpmjin.c:8440
libstp.so         stpmjin+0xa71         stpmjin.c:10485
libstp.so         stpjin+0x33de         stpjin.c:8303
libstp.so         awtstphd+0xa4b        awtstphd.c:608
libstp.so         awtmain+0x3d34        awtmain.c:3407
libpde.so         tsknewthread+0x3c7    tskport.c:1335
libpthread.so.0   start_thread+0xe6
libc.so.6         clone+0x6d
 
 
Sample 10:

PROC/FUN
Location          Function                   File:Line
---------------------------------------------------------------
libpde.so         prgfaultcatch+0x1a9        prgport.c:1990
libpthread.so.0   __restore_rt              
libfpf.so         otranslate_unicode+0xc     fpftranslate.c:228
libfpf.so         otranslate+0x634           fpftranslate_anytype.cpp:1376
libfpf.so         fpfInvokeFpUdfOp+0xe2      fpfbase.cpp:1211
libdbs1.so        evlinterp+0x5b6b           evlinterp.c:20775
libdbs1.so        evlcomp2+0x9c              evlcomp.c:157
libamp1.so        CheckRow.isra.0+0x61       sutstr.c:198
libamp1.so        sutstrrd+0x5ec             sutstr.c:1794
libstp.so         ReadNext+0x3f              stphjin.c:913
libstp.so         ProbeWithBaseRTbl+0x8cd    stphjin.c:2364
libstp.so         ProbeWithRTbl+0x20d        stphjin.c:2663
libstp.so         ClassicHashJoin+0xcce      stphjin.c:3104
libstp.so         stphjin+0xc0f              stphjin.c:4276
libstp.so         stpjin+0x38b9              stpjin.c:8349
libstp.so         awtstphd+0xa4b             awtstphd.c:608