Symptom
- A long running process is killed.
- it leaves phantom locks with the following errors in the ASE errorlog:
Error: 631, Severity: 21, State: 4
The length of xxx passed to delete row routine for the row at offset xxx is incorrect on the following page of database 'dbname': Page pointer = 0x0x2caa508
00, pageno = xxx, status = 0x101, ptnid = xxxxxx, indexid = 0, level = 0, pnextrno = 0. The expected row length is xxx. The offset should be no greater than xx.
Error while undoing log row in database 'dbname'. Rid pageid = xxxxx row num = x.
WARNING: Pss 0x0x00000001f67a1e88 found with open sdes. pspid [killed spid], psuid xx, pcurdb x, range entry x, sdesp 0x0x00000001d41b89a0, objid xxx.
.
.
Error: 6103, Severity: 17, State: 1
Unable to do cleanup for the killed process; received Msg 3300.
WARNING: spid [killed spid] with suid xx and curdbid x has an active transaction in dbid 8 with xactid (xxx, 0).
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0
- SAP Adaptive Server Enterprise (ASE) 15.7
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
CR815548, CR#815548, 815548, rollback, kill, last chance threshold, syslogs, space , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.