SAP Knowledge Base Article - Preview

2660763 - Phantom locks with error 631 when a process is killed. - SAP ASE

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.