Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4

    Unanswered: Stacktrace in errorlog: bad?

    Today I discovered a massive errorlog in one of my ASE15-servers. Apparently traceflag 3605 was on, sending stacktraces to the errorlog.
    I am a little scared (or tbh: very scared) that my server is corrupt because I cannot decypher the text.
    Can anyone tell me what the snippet below is trying to tell me? Is it bad, is there a reason to worry?
    Code:
    ESTMT (0x0x2aaababc56f8) STATEMENT NUMBER 3 AT LINE 46:
    
    e_next=0x0x2aaababc59b8 e_estep=0x0x2aaababc5830 e_goto=0x0x2aaababc59b8 e_xdes=0x(nil) e_mpcr=0x0x2aaababc5990 e_procdes=0x(nil)
    e_offset=1920 e_lineno=46 e_stmtno=3 e_stmttype=326 (UPDATESTATS) e_open_varct=0 e_open_workct=0 e_open_ri_cnt = 0 e_locks=0x(nil) e_nlocks=0 e_mode=0 (XMOD_NOLOG) e_isolation=0 (NOT_SPECIFIED), e_complevel=1 (LEVEL_1), e_estcost=0 e_status=(0x0010 (LEGALINXACT)) e_status2=(0x0000) e_status3=(0x00000004 (MDA_SAVED_FLAG)) e_capbits=(0x00000000) e_updcol=0x(nil) ( )
    e_css=0x(nil) e_resconst_list=0x(nil)e_tempdb_cid=0
    e_dseg_cnt=0, e_dseg_firsttbl=0x(nil), e_dseg_curtbl=0x(nil),
    e_dseg_curtblcnt=0;
    e_pre_dseg_alloc=0x(nil),
    
    e_runvars=0x(nil) {}
    
    E_PLL:
    e_plldeg=0
    e_plansize: 0u
    e_pmemcnt: 0u
    e_pmemhwm: 0u
    e_ptempdb_hwm: 0
    
    MAIN ESTEP (0x0x2aaababc5830) NUMBER 0:
    e_stnext=0x(nil) e_stsubor=0x(nil) e_stfirst=0x(nil) e_stbegrow=0x(nil)
    e_strowsz=0 e_stendrow=0x(nil) e_stresdom=0x(nil) e_stdefcol=0x(nil)
    e_ststat=(0x00000001 (USER)) e_st2stat=(0x00200000 (LASTQUERY), 0x00100000 (FIRSTQUERY)) e_st3stat=(0x00800000 (UPD_STAT)) e_st4stat=(0x00000000)
    e_st5stat=(0x00000000)
    e_st6stat=(0x00000001 (UPD_STATISTICS_TB))
    e_st7stat=(0x00000000)
    e_stepstat=(0x00000000)
    e_toplimit=0 e_stvarct=0 e_stworkct=0 e_stresvar=0 (  )
    e_streadvar=0 (  ), e_stquerytype=326 (UPDATESTATS)
     e_stinsvar=0 (  ) e_stdelvar=0 (  )e_stname=0x2aaababc5948 ("usrtable1") e_staggbuf=0x0 e_stvirtrg=0x0 e_strange=0x0
    
    E_STPLL:
    e_stpll=0x(nil)
    00:03:00000:00131:2014/05/12 10:14:46.43 server  SET SWITCH SERVERWIDE OFF 3605, SPID 131.
    00:03:00000:00131:2014/05/12 10:14:46.43 server  Invalid column length: 31. Value must be between 0 and 27 at offset 8 for 'all-pages' row with minimum row length of 6.
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x000000000179130f pcstkwalk+0x30()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001791105 ucstkgentrace+0x1a5()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001730d81 ucbacktrace+0x43()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a73603 collocate+0x303()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x00000000019ae698 setkeys+0x68()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a509e2 stat_collect+0x42()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000d71b00 ut_handle installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a76836 ups_build+0x5d6()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000000d5e576 ups__updstats+0x1e6()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000d71b00 ut_handle installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x00000000016a0a9c update_statistics+0x1e1()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000d71b00 ut_handle installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x000000000169f834 ups_main+0x294()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a610d0 s_execute+0x6ab0()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000cd09a0 hdl_stack installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000cb1370 s_handle installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a6e0b1 sequencer+0x6b1()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a67cf2 execproc+0x6b2()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a5dc54 s_execute+0x3634()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000cd09a0 hdl_stack installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000cb1370 s_handle installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a6e0b1 sequencer+0x6b1()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a67cf2 execproc+0x6b2()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a5dc54 s_execute+0x3634()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000cd09a0 hdl_stack installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000cb1370 s_handle installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000001a6e0b1 sequencer+0x6b1()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x0000000000758225 tdsrecv_language+0xb5()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  [Handler pc: 0x0x0000000000d71b00 ut_handle installed by the following function:-]
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  pc: 0x000000000194776f conn_hdlr+0xc1f()
    00:03:00000:00131:2014/05/12 10:14:46.43 kernel  end of stack trace, spid 131, kpid 1136787597, suid 16
    00:03:00000:00131:2014/05/12 10:14:46.43 server  SET SWITCH SERVERWIDE ON 3605, SPID 131.
    SDES: (at 0x0x2aaab28a4f90) sdes_next=0x0x2aaab28a5510 sdesp=0x0x2aaab063ea20 objuid=1 objid=1887397843 objname=usrtable1 scurpage=463146, dbid=7
    
    ESTMT (0x0x2aaababc56f8) STATEMENT NUMBER 3 AT LINE 46:
    
    e_next=0x0x2aaababc59b8 e_estep=0x0x2aaababc5830 e_goto=0x0x2aaababc59b8 e_xdes=0x(nil) e_mpcr=0x0x2aaababc5990 e_procdes=0x(nil)
    e_offset=1920 e_lineno=46 e_stmtno=3 e_stmttype=326 (UPDATESTATS) e_open_varct=0 e_open_workct=0 e_open_ri_cnt = 0 e_locks=0x(nil) e_nlocks=0 e_mode=0 (XMOD_NOLOG) e_isolation=0 (NOT_SPECIFIED), e_complevel=1 (LEVEL_1), e_estcost=0 e_status=(0x0010 (LEGALINXACT)) e_status2=(0x0000) e_status3=(0x00000004 (MDA_SAVED_FLAG)) e_capbits=(0x00000000) e_updcol=0x(nil) ( )
    e_css=0x(nil) e_resconst_list=0x(nil)e_tempdb_cid=0
    e_dseg_cnt=0, e_dseg_firsttbl=0x(nil), e_dseg_curtbl=0x(nil),
    e_dseg_curtblcnt=0;
    e_pre_dseg_alloc=0x(nil),
    
    e_runvars=0x(nil) {}
    
    E_PLL:
    e_plldeg=0
    e_plansize: 0u
    e_pmemcnt: 0u
    e_pmemhwm: 0u
    e_ptempdb_hwm: 0
    
    MAIN ESTEP (0x0x2aaababc5830) NUMBER 0:
    e_stnext=0x(nil) e_stsubor=0x(nil) e_stfirst=0x(nil) e_stbegrow=0x(nil)
    e_strowsz=0 e_stendrow=0x(nil) e_stresdom=0x(nil) e_stdefcol=0x(nil)
    e_ststat=(0x00000001 (USER)) e_st2stat=(0x00200000 (LASTQUERY), 0x00100000 (FIRSTQUERY)) e_st3stat=(0x00800000 (UPD_STAT)) e_st4stat=(0x00000000)
    e_st5stat=(0x00000000)
    e_st6stat=(0x00000001 (UPD_STATISTICS_TB))
    e_st7stat=(0x00000000)
    e_stepstat=(0x00000000)
    e_toplimit=0 e_stvarct=0 e_stworkct=0 e_stresvar=0 (  )
    e_streadvar=0 (  ), e_stquerytype=326 (UPDATESTATS)
     e_stinsvar=0 (  ) e_stdelvar=0 (  )e_stname=0x2aaababc5948 ("usrtable1") e_staggbuf=0x0 e_stvirtrg=0x0 e_strange=0x0
    
    E_STPLL:
    e_stpll=0x(nil)
    I'm not crazy, I'm an aeroplane!

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hi,

    What version is that?
    Check the errorlog you will probably see the traceflag 3605 being turned on and off multiple times on the same minute. You will have a lot of on and off of it.

    I have had that issue, not with the command you are doing ( update stats ), however the error seems similar:

    00:03:00000:00131:2014/05/12 10:14:46.43 server Invalid column length: 31. Value must be between 0 and 27 at offset 8 for 'all-pages' row with minimum row length of 6.
    Invalid column lenght

    Try to
    Run dbcc checkcatalog(<database name>). If any errors are reported, fix them by running dbcc checkcatalog(<database name>, "fixall").
    From Sybase manual.

  3. #3
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Thank you Catarrunas, the checkcatalog helped. There aren't any new stacktraces in the errorlog anymore.
    I'm not crazy, I'm an aeroplane!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •