3685360 - Error 834 causing tempdb log segment full and service impact in server - SAP ASE

• The following error messages were logged:

Error: 834, Severity: 20, State: 3
Illegal attempt to clean buffer: BUF=0x00000003e83d32e0, MASS=0x00000003e83d32e0, Buf#=0, page=0x00000003dbb41800, dbid=2, Mass vdevno=13, vpage=158753, * lpage=160799, Mass stat=0x4210001, * stat=0x2, size=2048, cid=0 ('default data cache'), Pinned xdes=0x0000000000000000, spid=0.

************************************
SQL causing error : proc_cms_get_bulk_corp_parm @p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10썊
Current statement number: 7 Current line number: 24
************************************
SQL Text: proc_cms_get_bulk_corp_parm @p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10썊
SQL Text: create unique index idx_in_order on #parm_keys_temp(in_order)
curdb = 2 tempdb = 2 pstat = 0x8010000 p2stat = 0x80101002
p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x211 p7stat = 0x10000
p8stat = 0x8004008 p9stat = 0x0 p10stat = 0x0
lasterror = 834 preverror = 0 transtate = 1
isolation = 1 tranmode = 0 xactcnt = 0 attn = 0 extattn = 0 memusage = 11
curcmd = 294 program = weblogic.work.ExecuteThread
extended error information: hostname: eapsrv77f login: cms_eap_user
pc: 0x0000000101c58c0c pcstkwalk.fdpr.chunk.1+0x8()
pc: 0x0000000101c599f4 ucstkgentrace+0x3c8()
pc: 0x00000001033d93b8 ucbacktrace+0xc4()
pc: 0x0000000103021b3c terminate_process.fdpr.chunk.12+0x124()
pc: 0x00000001033c7750 hdl_default+0x6c()
pc: 0x0000000103123c9c ut_handle.fdpr.chunk.1+0x64()
pc: 0x000000010212e6c8 exc__raise.fdpr.chunk.2+0x3c()
pc: 0x000000010212e194 ex_raise+0x160()
pc: 0x0000000103159714 buffree.fdpr.chunk.2+0x68()
pc: 0x00000001023fd2cc bufunkeep_do_decrement.fdpr.chunk.7+0x3c()
pc: 0x00000001023fd560 bufunkeep_cache+0x15c()
00:0004:00000:04531:2025/11/05 14:45:50.88 kernel pc: 0x00000001023e1908 bufdbtlastlog+0x50()
00:0004:00000:04531:2025/11/05 14:45:50.88 kernel pc: 0x00000001023e1744 log__newpage+0x434()
pc: 0x00000001023e08ec plcblock__flush.fdpr.chunk.17+0x1c()
pc: 0x00000001023df3f0 plc__flush.fdpr.chunk.14+0xcc()
pc: 0x00000001023e2318 xls_preflush.fdpr.chunk.7+0x90()
pc: 0x00000001023e1f90 syslogs_finishlog+0x2d0()
pc: 0x00000001023e27ec finishlog+0x1e0()
pc: 0x00000001023e3a24 xact__endxact+0x208()
pc: 0x00000001024439e8 xact__commitxact.fdpr.chunk.9+0x1bc()
pc: 0x0000000102443548 xact__commit_local+0xd0()
pc: 0x0000000102443418 xact_commit+0x70()
[Handler pc: 0x000000010212e590 hdl_backout installed by the following function:-]
[Handler pc: 0x000000010229e4e4 ut_handle installed by the following function:-]
pc: 0x000000010224fa7c cri_main+0xe04()
pc: 0x000000010224eb30 s_execute.fdpr.chunk.72+0x8()
[Handler pc: 0x000000010212e550 hdl_stack installed by the following function:-]
[Handler pc: 0x000000010212ec0c s_handle installed by the following function:-]
pc: 0x0000000102462b58 sequencer+0x4fc()
pc: 0x0000000102466250 execproc+0x744()
pc: 0x000000010234de80 s_execute.fdpr.chunk.97+0xc8()
[Handler pc: 0x000000010212e550 hdl_stack installed by the following function:-]
[Handler pc: 0x000000010212ec0c s_handle installed by the following function:-]
pc: 0x0000000102462b58 sequencer+0x4fc()
pc: 0x000000010247f2dc tdsrecv_language+0x280()
end of stack trace, spid 4531, kpid 1443305508, suid 13
Error: 21, Severity: 20, State: 1
WARNING - Fatal Error 834 occurred at Nov 5 2025 2:45PM. Please note the error and time, and contact a user * System Administrator (SA) authorization.
Error: 834, Severity: 20, State: 3
Illegal attempt to clean buffer: BUF=0x00000003e83d32e0, MASS=0x00000003e83d32e0, Buf#=0, page=0x00000003dbb41800, dbid=2, Mass vdevno=13, vpage=158753, * lpage=160799, Mass stat=0x4210001, * stat=0x2, size=2048, cid=0 ('default data cache'), Pinned xdes=0x0000000000000000, spid=0.
Error while undoing log * in database 'tempdb'. Rid pageid = 0; * num = 0.
WARNING: Pss 0x000000033052e528 found with open sdes. pspid 4531, psuid 13, pcurdb 2, range entry 0, sdesp 0x00000002ebff8ee0, objid 753624829.
WARNING: Pss 0x000000033052e528 found with open sdes. pspid 4531, psuid 13, pcurdb 2, system table entry 0, sdesp 0x00000002ec28f758, objid 8.
Error: 6103, Severity: 17, State: 1
Unable to do * for the killed process; received Msg 3300.
WARNING: spid 4531 with suid 13 and curdbid 2 has an active transaction in dbid 2 with xactid (160799, 5).
Error: 2812, Severity: 16, State: 5
Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
Space available in segment 'logsegment' has fallen critically low in database 'tempdb2'. All future modifications to this database will be suspended until the transaction log is successfully dumped and space becomes available.

• SAP Adaptive Server Enterprise 16.0

error 834, tempdb log segment full, illegal buffer cleanup, error 6103, buffer free phase , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem