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.
SAP Knowledge Base Article - Preview