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.