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 for Me (Login required).

Search for additional results

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