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


ASE server unresponsive, database dump, reorg compact, server reboot, shared memory dump, tempdb cache binding, reorg process restart, server shutdown, kernel log, partition reorg compact, database 'mydb', performance , 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.