Skip to Content
0
Former Member
Nov 24, 2014 at 01:44 PM

Stack Trace when running update stats - ASE 15.7 SP 100

56 Views

We migrated our current server from 15.0.3 to 15.7 SP 100 recently. We got the following stack trace when we are running update statistics on a large table ...

00:0013:00000:00525:2014/11/23 18:24:54.70 server The 2K memory pool of named cache tempdb1_cache (cache id 3, cachelet id 15) is configured too small for c

urrent demands (state 4). Transaction progress may cease or response time may increase.

00:0014:00000:00525:2014/11/23 18:24:55.40 server Error: 837, Severity: 21, State: 1

00:0014:00000:00525:2014/11/23 18:24:55.40 server Attempted to grab wash header.

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel ************************************

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel SQL causing error : update index statistics OTCReportItem

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel ************************************

00:0014:00000:00525:2014/11/23 18:24:55.40 server SQL Text: update index statistics OTCReportItem

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel curdb = 8 tempdb = 10 pstat = 0x10000 p2stat = 0x101000

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x10 p7stat = 0x110000

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel lasterror = 837 preverror = 0 transtate = 1

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel curcmd = 326 program = isql

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel extended error information: hostname: ykt1sybuat19 login: sshen

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001d18ca0 pcstkwalk+0x380()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001d18627 ucstkgentrace+0x177()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001d13e3a ucbacktrace+0x12a()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000c28f91 terminate_process+0x1241()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001951c4a hdl_default+0x1a()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001950dce ex_raise+0x30e()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000bee540 cm_grabmem_lru+0x340()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000bc7919 bufnewpage+0x309()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000c1025e pg__getpgbuf+0x25e()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000c08238 pg__allocate_completion+0x428()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000bff9f4 pg__allocate_near_target+0x324()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x00000000014b3a7e pg__allocate+0x1be()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000c1bbf1 pg_allocate+0x61()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000c1a5e0 linkovflow+0x170()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000bdb1b9 ncinsert+0x879()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000bb9ace ins_insert+0x3fe()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x00000000011c6455 insert+0xb5()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001c25dcb stat_ins_worktable+0x25b()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel [Handler pc: 0x0000000000000000 installed by the following function:-]

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001c278c7 update_statistics_col+0xa47()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel [Handler pc: 0x0000000000000000 installed by the following function:-]

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001c285ea update_statistics_colset_driver+0x3ba()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel [Handler pc: 0x0000000001c6fa70 ut_handle installed by the following function:-]

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001c207fc ups__minorattributes+0x1ac()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001c1f3cc ups__updstats+0x88c()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001c1f87e ups__updstats_driver+0xce()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel [Handler pc: 0x0000000001c6fa70 ut_handle installed by the following function:-]

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001c1ddb1 update_statistics+0x761()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel [Handler pc: 0x0000000001c6fa70 ut_handle installed by the following function:-]

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001c1bddc ups_main+0x6bc()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000b639ae s_execute+0x8c6e()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel [Handler pc: 0x00000000019512c0 hdl_stack installed by the following function:-]

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel [Handler pc: 0x00000000018eb2b0 s_handle installed by the following function:-]

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000bd7762 sequencer+0x11b2()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000c71ee3 tdsrecv_language+0x253()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel [Handler pc: 0x0000000001c6fa70 ut_handle installed by the following function:-]

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000000baaf9b conn_hdlr+0x1e3b()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel pc: 0x0000000001d4dda2 kpstartproc+0x32()

00:0014:00000:00525:2014/11/23 18:24:55.40 kernel end of stack trace, spid 525, kpid 1104609844, suid 481



I know it is pointing to the tempdb cache and we are rectifying it. (We will be dropping the tempdb cache). But, I wanted to know if anyone encountered this stack trace and if there is a known bug in this version.


TIA.