3356016 - Error 1289: Internal Error in lock manager routine - SAP ASE

• ASE error log reports error 1289
• Most commonly seen on dbcc commands (but not limited to this type of command)
  
  Error: 1289, Severity: 20, State: 3
  Internal Error in lock manager routine: Invalid lock mode exclusive page, requested by task (family id 123, spid 45) conflicts with existing family request mode exclusive page belonging to task (family id 123, spid 67).
  
  
• The ASE error log may contain warnings of a shortage of meta data descriptors:
  • Usually a warning for just 1 of the parameter types is reported, most likely indexes or partitions:
    
    Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation.
    Increase the config parameter 'number of open indexes' to avoid descriptor reuse. Reuse may result in performance degradation.
    Increase the config parameter 'number of open objects' to avoid descriptor reuse. Reuse may result in performance degradation.
    
    
• As a result
  • Messages are printed that dbcc checks failed, for example:
    
    Checkstorage check aborted for dbid '4', objid '1943506995', indid '2'. Type of check 'index chain'. Total checks aborted '1'.
    
    
  • ASE may become unresponsive, requiring a reboot to clear the situation

• SAP Adaptive Server Enterprise (ASE)
  
  
  • 16.0 SP03 PL12, PL13 & PL14
  • 16.0 SP04 PL03 & PL04

 sp_dbcc_runcheck , sp_dbcc_recommendations , checkstorage, 'open indexes',  828339, CR 828339, CR#828339, hangs, unresponsive , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem