SAP Knowledge Base Article - Preview

3221747 - Error 12313 occurs which caused an Internal 'database shutdown' - SAP ASE

Symptom

There was an Error 12313 which caused an Internal "database shutdown"
After few seconds of the internal DB shutdown, ASE was trying to recover the DB but if failed.

00:0005:00000:00037:2022/06/22 11:43:54.36 server  Initiating shared memory dump for error 12313.
00:0005:00000:00037:2022/06/22 11:43:54.36 kernel  Dumping shared memory to dump file: /sybase/BOD/saparch_1/shmdump/BOD.dmp.2022062211435403
00:0005:00000:00037:2022/06/22 11:43:54.36 kernel  Writing segment 0:
00:0005:00000:00037:2022/06/22 11:43:54.36 kernel  Thread (0): Writing 26175168512 bytes starting at 0x0x1457bd000
00:0005:00000:00037:2022/06/22 11:45:31.19 kernel  Writing segment 1:
00:0005:00000:00037:2022/06/22 11:45:31.19 kernel  Thread (0): Writing 3407872 bytes starting at 0x0x75de4f000
00:0005:00000:00037:2022/06/22 11:45:31.20 kernel  Writing segment 2:
00:0005:00000:00037:2022/06/22 11:45:31.20 kernel  Thread (0): Writing 165560320 bytes starting at 0x0x75e98f000
00:0005:00000:00037:2022/06/22 11:45:31.84 kernel  Writing segment 3: 00:0005:00000:00037:2022/06/22 11:45:31.84 kernel  Thread (0): Writing 4096 bytes starting at 0x0x79d36f000
00:0005:00000:00037:2022/06/22 11:45:31.84 kernel Copying errorlog into dump file.
00:0005:00000:00037:2022/06/22 11:45:31.84 kernel Copying configuration file into dump file.
00:0005:00000:00037:2022/06/22 11:45:31.85 kernel  Dump complete in 98 seconds.
00:0005:00000:00037:2022/06/22 11:45:31.85 kernel  4 segments of total size 26344140800 bytes written to dump file.
00:0005:00000:00037:2022/06/22 11:45:31.85 server  Shared memory dump completed successfully.

00:0005:00000:00037:2022/06/22 11:45:31.85 server  Error: 12313, Severity: 21, State: 1
00:0005:00000:00037:2022/06/22 11:45:31.85 server  Internal error: Insert into page id 2038 of index id 11 of table 'Table7' (id = 1888006726) in d atabase 'BOD' tried to replace undeleted RID (4188,21) at slot 269 and ridposn 0. Try dropping and recreating the index.
00:0004:00000:00661:2022/06/22 11:45:31.85 kernel  Cannot send, host process disconnected: hec42v143972 2756 suid: 4
.................................
00:0005:00000:00037:2022/06/22 11:45:31.86 server  A transaction in database 'BOD' (spid=37) has hit a fatal error during rollback. ASE will try to reboot an d recover the database. The XREC_BEGINXACT of this failing transaction is (838803, 129).
00:0002:00000:00037:2022/06/22 11:45:31.86 server  Initiating shared memory dump for error 12313.
00:0002:00000:00037:2022/06/22 11:45:31.86 kernel  Dumping shared memory to dump file: /sybase/BOD/saparch_1/shmdump/BOD.dmp.2022062211453100

00:0002:00000:00037:2022/06/22 11:45:31.86 kernel Writing segment 0:
00:0002:00000:00037:2022/06/22 11:45:31.86 kernel Thread (0): Writing 26175168512 bytes starting at 0x0x1457bd000
00:0001:00000:00000:2022/06/22 11:46:38.95 kernel Warning: The internal timer is not progressing. If this message is generated multiple times, report to SAP Technical Support and restart the server (alarminterval=-666).
00:0002:00000:00037:2022/06/22 11:47:11.54 kernel Writing segment 1:
00:0002:00000:00037:2022/06/22 11:47:11.54 kernel Thread (0): Writing 3407872 bytes starting at 0x0x75de4f000
00:0002:00000:00037:2022/06/22 11:47:11.55 kernel Writing segment 2:
00:0002:00000:00037:2022/06/22 11:47:11.55 kernel Thread (0): Writing 165560320 bytes starting at 0x0x75e98f000
00:0002:00000:00037:2022/06/22 11:47:12.17 kernel Writing segment 3:
00:0002:00000:00037:2022/06/22 11:47:12.17 kernel Thread (0): Writing 4096 bytes starting at 0x0x79d36f000
00:0002:00000:00037:2022/06/22 11:47:12.17 kernel
Copying errorlog into dump file.
00:0002:00000:00037:2022/06/22 11:47:12.19 kernel
Copying configuration file into dump file.
00:0002:00000:00037:2022/06/22 11:47:12.19 kernel Dump complete in 102 seconds.
00:0002:00000:00037:2022/06/22 11:47:12.19 kernel 4 segments of total size 26344140800 bytes written to dump file.
00:0002:00000:00037:2022/06/22 11:47:12.19 server Shared memory dump completed successfully.
00:0002:00000:00037:2022/06/22 11:47:12.19 server Error: 12313, Severity: 21, State: 1
00:0002:00000:00037:2022/06/22 11:47:12.19 server Internal error: Insert into page id 2165 of index id 10 of table 'Table7' (id = 1888006726) in database 'BOD' tried to replace undeleted RID (4188,21) at slot 180 and ridposn 0. Try dropping and recreating the index.
00:0002:00000:00037:2022/06/22 11:47:12.19 server A transaction in database 'BOD' (spid=37) has hit a fatal error during rollback. ASE will try to reboot and recover the database. The XREC_BEGINXACT of this failing transaction is (838803, 129).
00:0005:00000:00241:2022/06/22 11:47:12.20 kernel Cannot send, host process disconnected: hec42v143972 4375 suid: 4
.........................................
00:0006:00000:00335:2022/06/22 11:47:12.20 server ---------- Shutting Down Database 'BOD' ----------
00:0003:00000:01048:2022/06/22 11:47:12.20 kernel Cannot send, host process disconnected: 4708 suid: 4
.........................................
00:0007:00000:00183:2022/06/22 11:47:12.20 server Database BOD with dbid 4 is already shut down.
00:0005:00000:00042:2022/06/22 11:47:12.20 server Database BOD with dbid 4 is already shut down.
00:0003:00000:00335:2022/06/22 11:47:12.21 server Error: 2259, Severity: 16, State: 1
00:0003:00000:00335:2022/06/22 11:47:12.21 server Warning: System process 13 is using the database 'BOD', dbid 4 while a database shutdown is being attempted. If the database shutdown is unsuccessful, retry it later.
00:0005:00000:00044:2022/06/22 11:47:12.21 server Database BOD with dbid 4 is already shut down.
00:0004:00000:00040:2022/06/22 11:47:12.21 server Database BOD with dbid 4 is already shut down.
00:0004:00000:00829:2022/06/22 11:47:12.21 server ---------- Shutting Down Database 'BOD' ----------
00:0004:00000:00829:2022/06/22 11:47:12.21 server Error: 2256, Severity: 16, State: 1
00:0004:00000:00829:2022/06/22 11:47:12.21 server Unable to shut down database 'BOD' with dbid 4 because another database shutdown or restart is executing. Try your command later.
00:0004:00000:00829:2022/06/22 11:47:12.21 server Error: 2256, Severity: 16, State: 1
00:0004:00000:00829:2022/06/22 11:47:12.21 server Unable to shut down database 'BOD' with dbid 4 because another database shutdown or restart is executing. Try your command later.
00:0004:00000:00829:2022/06/22 11:47:12.21 server ---------- Operation on Database 'BOD' Failed ----------
00:0005:00000:00043:2022/06/22 11:47:12.21 server Database BOD with dbid 4 is already shut down.
00:0004:00000:00182:2022/06/22 11:47:12.21 server Database BOD with dbid 4 is already shut down.
00:0003:00000:00335:2022/06/22 11:47:12.21 server Process id 35 killed by Hostname , Host process id .
.........................................
00:0006:00000:00315:2022/06/22 11:47:12.36 server Database BOD with dbid 4 is already shut down.


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 SP03 PL08 HF1

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Error 12313, CR-821309, CR821309, , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

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.