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.