SAP Knowledge Base Article - Preview

3002626 - Error 1295 hit by ALTER DATABASE...LOG OFF - SAP ASE 16.0

Symptom

  • The ALTER DATABASE ... LOG OFF command fails with Error 1295 followed by a stack trace:

Error: 1295, Severity: 26, State: 2
Unconditional lock request for table or page 20, dbid 4 was made while holding a latch.

  • The stack trace include the following functions:

log_to_virt
altdb__upd_bcache
altdb__divide_diskmap
altdb__do_shrinkdb

  • A similar ALTER DATABASE command using 'OFF' instead of 'LOG OFF', caused a spinlock order violation and crashed ASE:

Spinlock default data cache at address 0x0000000149189780 owned by 0x14942efe8, level = 0x1, prspinlocksheld = 0x1
ulpspinlock: spinlock order violation

Note: Samples of stack traces are available under Attachments.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR800203, CR#800203, 800203 , 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.