SAP Knowledge Base Article - Preview

1952370 - Error 814 "Keep count of buffer xxx in cache x holding logical page xxx in database x has become negative" while running 'update statistics' - SAP ASE

Symptom

  • ASE error 814 with a message about negative page in cache:

Error: 814, Severity: 20, State: 7
Keep count of buffer '0x2ab8eeab8d80' in cache 'tempdb_batch1' holding logical page '1240065' in database 'MyDB' has become negative.

  • Modules seen on the ASE stacktrace:

bufunkeep_cache()
bufallunkeep()
closetable()
ups_end_statglobalnosort()
ups_calctabdata()
ups__updstats()
ups__updstats_driver()
update_statistics()
ups_main()

  • The ASE server either crashed or hung
     
  • An "update statistics" or "create index" command was being run at the time the error and stacktrace were raised.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)  15.7 prior to SP110
  • SAP Adaptive Server Enterprise (ASE)  15.7 prior to SP60

Product

SAP Adaptive Server Enterprise 15.7

Keywords

hanging, aborted, minus , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.