3702548 - Memory errors and timeslice in checkstorage functions for ASE 16.1 - SAP ASE

• While running dbcc checkstorage
• ASE errorlog reports
• Memory errors 
• followed by timeslice at pchk_release_retry_resource and / or signal 11 at prPCHK_INDEX_CHECK_IND
• A typycal log sequence includes:
  
  Error: 3689, Severity: 17, State: 1
  Cannot allocate shared memory as 'max memory' limit of '70000000' pages has been reached. Please increase configuration parameter 'max memory' to allow additional shared memory allocation. Total physical memory allocated so far '70123520' pages.
  No memory for DBCC Checkstorage Memory Pool bucket pool growth (8421376 bytes)
  
  timeslice -501, current process infected at 0x1556c32 (pchk_release_retry_resource+0x92)
  
  with stack functions
  pchk_hashtable_insert
  pchk_dol_page_row
  pchk_dol_data_page
  pchk_page
  pchk_all_pages
  pchk_scan_work
  
  
  Error: 9970, Severity: 20, State: 1
  DBCC cannot update the finish time in dbcc_operation_log table for this operation(opid = '70') of database 'db_name'. This can be patched by executing sp_dbcc_patch_finishtime.
  
  
  Address 0x0x000000000107ac08 (prPCHK_INDEX_CHECK_IND+0x93), ...
  Current process (0xf2902d6) infected with signal 11 (SIGSEGV)
  SQL Text: insert dbcc_operation_log(dbid, opid, optype, suid, start, seq, id) values(4, 70, 2, 1, getdate(), null, null) 
  curcmd = 317 (DBCC_CMD) program = isql 
  
  with stack functions
  prPCHK_INDEX_CHECK_IND
  pchk_get_all_rids
  checkstorage
  
  
  No memory for DBCC Checkstorage Memory Pool bucket pool growth (8421376 bytes)
  Insufficient memory for index consistency check (with_index). Aborting index check and releasing resources. The with_index option is disabled. DBCC Checkstorage continues with other checks.

SAP Adaptive Server Enterprise (ASE) 16.1

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed