SAP Knowledge Base Article - Preview

3314827 - ASE server becomes unresponsive, but very little is running on the server. - SAP ASE

Symptom

  • An ASE Server became unresponsive.
  • The only processes running that time were dump database and reorg compact.
  • The server was freshly rebooted before the reorgs and dump databases where started.
  • The Backupserver log shows no issues.
  • ASE log shows no errors and the reorgs are doing well until the last one that hangs:

    00:0013:00000:06001:2023/03/01 19:12:30.73 server  REORG COMPACT of 'rs_lastcommit' partition 'rs_lastcommit_533573908' in database 'mydb' completed.
    00:0006:00000:06001:2023/03/01 19:12:30.73 server  Beginning REORG COMPACT of 'rs_ticket_history' partition 'rs_ticket_history_325573167' in database 'mydb'.
    00:0018:00000:01300:20XX/03/01 19:12:31.38 server  Beginning REORG COMPACT of 'mytable' partition 'mytable_1232004389' in database 'mydb'.
    00:0008:00000:00004:20XX/03/01 20:03:17.63 kernel  shutdownproc: shutting down server
    00:0008:00000:00004:20XX/03/01 20:03:17.63 kernel  ueshutdown: exiting
    00:0009:00000:00000:20XX/03/01 20:03:17.63 kernel  bucket manager consolidator terminating
    00:0000:00000:00000:20XX/03/01 20:03:17.63 kernel  Main thread performing final shutdown.
    00:0000:00000:00000:20XX/03/01 20:03:17.63 kernel  Blocking call queue shutdown.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.