SAP Knowledge Base Article - Preview

2715495 - Hang on COMMIT when 'user log cache queue size' is enabled - SAP ASE 16.0

Symptom

  • While executing a batch, some processes executing a COMMIT were not running. They seeemed to be hanging.
  • This occurred after enabling the configuration parameter "user log cache queue size".
  • A memory dump showed the following stack traces for the processes involved:
     
    • kpsuspend
      upsleepgeneric
      smp_bufpredirty
      plcblock__flush
      xls_flush_plcqueue
      plc__flush
      xls_preflush
      syslogs_finishlog
      finishlog
      xact__endxact
      xact__commitxact
      xact__commit_local
      xact_commit
      s_execute
       
    • kpsuspend
      upsleepgeneric
      cm_writedes
      bufwritedes_log
      xls_flush
      write_prepare_rec
      xact__preparexact
      xact__commitxact
      xact__commit_local
      xact_commit
      s_execute
       
    • kpsuspend
      upsleepgeneric
      xls_flush_plcqueue
      plc__flush
      xls_preflush
      syslogs_finishlog
      finishlog
      xact__endxact
      xact__commitxact
      xact__commit_local
      xact_commit
      s_execute

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03

Product

SAP Adaptive Server Enterprise 16.0

Keywords

hang, user log cache queue size, CR817178, CR#817178, CR817178, BUO , 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.