2409396 - Error 1514: Sort failed because it attempted to allocate page xxx and found that the page was busy. - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2409396 - Error 1514: Sort failed because it attempted to allocate page xxx and found that the page was busy. - SAP ASE

Symptom

  • Recieved Error 1514:

Error: 1514, Severity: 21, State: 2
Sort failed because it attempted to allocate page 11728 and found that the page was busy. Buffer BUF=0xc000000f6f503068, MASS=0xc000000f6f503068, Buf#=0, page=0xc000000f56d0a800, dbid=2, Mass vdevno=11, vpage=9680, Buf lpage=11728, Mass stat=0x1008, Buf stat=0x1, size=2048, cid=4 ('tempdb_cache'), Pinned xdes=0x0000000000000000, spid=0 contains a cached and referenced page with ptnid 24 indid 2 and status 0x802.

  • It was followed by Error 2628 and multipe Errors 839, for example:

Error: 2628, Severity: 21, State: 3
In database 'tempdb', page 221456 is linked forward to page 239769, but that page is linked backward to page 11644. Please report this internal error to Sybase Technical Support.
Error: 839, Severity: 21, State: 1
Grabbed buffer dirty but not writing: BUF=0xc000000f6b9846c8, MASS=0xc000000f6b9846c8, Buf#=0, page=0xc000000f38328800, dbid=0, Mass vdevno=11, vpage=219408, Buf lpage=221456, Mass stat=0x4010010, Buf stat=0x0, size=2048, cid=4 ('tempdb_cache'), Pinned xdes=0x0000000000000000, spid=0.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.5

Keywords

CR740730, CR#740730, 740730, StoreIndex, reformatting, subquery , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.