2149248 - Error: 873 and stacktrace occurs during a drop procedure - ASE

• Drop of a stored procedure reports the following error:

Error: 873, Severity: 20, State: 1
server  Process 216 is requesting shared latch on buffer 0xf38a3518 (dbid: 1, pageno: 2992) while holding 4 latches. A process can hold only 4 latches at a time.

• Last-chance threshold is crossed reporting the following message:

Space available in the log segment has fallen critically low in database 'testdb'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.

• Stacktrace is reported after the error:

kernel  ************************************
kernel  SQL causing error : drop proc xxx_111_aaa
kernel  ************************************
server  SQL Text: drop proc drop proc xxx_111_aaa
kernel  curdb = 12 tempdb = 52 pstat = 0x10000 p2stat = 0x40101000
kernel  p3stat = 0x40800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x211 p7stat = 0x10000
kernel  lasterror = 873 preverror = 0 transtate = 0

<snip>

kernel  pc: 0x0000000000d155bb buf_get_latchedbuf_slot+0xbb()
kernel  pc: 0x0000000000d0a0f5 bufsearch_cache_getlatch+0x455()
kernel  pc: 0x0000000000a8e54d getpage_with_validation+0x1cd()
kernel  pc: 0x0000000000b5598d bt__getchildlatched+0x1dd()
kernel  pc: 0x0000000000b5478c bt__traverse+0x32c()
kernel  pc: 0x0000000000b52b87 bt__getstartpg+0x1f7()
kernel  pc: 0x0000000000b2939c bt_getnext+0x5ac()
kernel  pc: 0x0000000000b04753 dol_bt_getnext+0x193()
kernel  pc: 0x0000000000a823c4 getnext+0x3e4()
kernel  pc: 0x00000000013ff698 attrib_getrow+0x228()
kernel  pc: 0x0000000001115c29 s_get_usr_goal+0xbb()
kernel  pc: 0x00000000008604e8 OptGoal::ogInit(OptCriteriaBase*)+0x248()
kernel  pc: 0x0000000000860616 OptGoalInit+0x46()
kernel  pc: 0x0000000000863ed5 OptConnGlobalsInit+0x15()
kernel  pc: 0x0000000000df8b7d pss_init+0xeed()
kernel  pc: 0x0000000000df71d9 pss_alloc+0x29()
kernel  pc: 0x000000000077acb8 spawn_handler+0x58()
kernel  pc: 0x0000000000ea4811 th_spawn_th_hdlr+0xbe()
kernel  pc: 0x0000000000ea338b th_accounting+0xcbb()
kernel  pc: 0x0000000000dc9893 pg_th_reserve+0x53()
kernel  pc: 0x0000000000dca017 pg__allocate_syslogs_extent+0x177()
kernel  pc: 0x0000000000dcad62 pg_allocate_syslogs+0x192()
kernel  pc: 0x0000000000ae4e99 log__newpage+0x109()
kernel  pc: 0x0000000000aea4a6 plc__flush+0x736()
kernel  end of stack trace,

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0

buf_get_latchedbuf_slot , KBA , threshold action , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed