If you find your ASE server unexpectedly not running, the errorlog can provide some useful clues as to how it shutdown.
Many years ago, I once worked a support case with a customer who had ended up with hard corruption in their database. Their errorlog showed that ASE had repeatedly rebooted, roughly 20 times over the course of the previous night. Their host was setup to automatically boot ASE when the OS started up. Each time there was no indication of why ASE had shutdown. I expressed the opinion that the lack of shutdown messages made me think the most likely cause was power being repeatedly shut off. A check of the OS logs confirmed that the host had also been rebooted many times with no indication of a polite shutdown. The problem was soon tracked down to new cleaning staff turning the power on and off in the computer lab. We didn't investigate the corruption further, the assumption being that a hard drive abruptly losing power while writing was a reasonable cause (and the corrupt data was clearly gibberish that didn't resemble formatted data).
00:0006:00000:00012:2013/07/22 09:33:58.10 server Shutdown started by user 'sa'. SQL text: shutdown
00:0006:00000:00012:2013/07/22 09:34:00.10 server ASE shutdown by request.
00:0006:00000:00012:2013/07/22 09:34:00.10 kernel ueshutdown: exiting
00:0000:00000:00000:2013/07/22 09:34:00.10 kernel Main thread performing final shutdown.
00:0000:00000:00000:2013/07/22 09:34:00.19 kernel Blocking call queue shutdown.
00:0000:00000:00000:2013/07/22 09:34:00.20 kernel SySAM: Checked in license for 1 ASE_CORE
00:0002:00000:00014:2013/07/22 09:30:11.14 server Shutdown started by user 'sa'. SQL text: shutdown with nowait
00:0002:00000:00014:2013/07/22 09:30:11.14 server Shutdown with nowait detected - ASE process level execution bindings will be cleared on startup.
00:0002:00000:00014:2013/07/22 09:30:11.16 server ASE shutdown by request.
00:0002:00000:00014:2013/07/22 09:30:11.17 kernel ueshutdown: exiting
00:0000:00000:00000:2013/07/22 09:30:11.18 kernel Main thread performing final shutdown.
00:0000:00000:00000:2013/07/22 09:30:11.28 kernel Blocking call queue shutdown.
00:0000:00000:00000:2013/07/22 09:30:11.80 kernel SySAM: Checked in license for 1 ASE_CORE
00:0006:00000:00000:2013/07/22 09:36:07.02 kernel ueshutdown: exiting
00:0000:00000:00000:2013/07/22 09:36:07.02 kernel Main thread performing final shutdown.
00:0000:00000:00000:2013/07/22 09:36:07.23 kernel Blocking call queue shutdown.
00:0000:00000:00000:2013/07/22 09:36:07.23 kernel SySAM: Checked in license for 1 ASE_CORE
00:0014:00000:02998:2014/01/20 03:10:23.62 kernel Spinlocks held by kpid <kpid#>
[...fatal error, typically with a stack trace...]
00:0014:00000:02998:2014/01/20 03:10:23.62 kernel Spinlock Resource-><spinlock name> at address <address> owned by <kpid#>
00:0014:00000:02998:2014/01/20 03:10:23.62 kernel End of spinlock display.
[... typically another stack trace ...]
00:0014:00000:02998:2014/01/20 03:10:23.62 kernel end of stack trace, spid <spid>, kpid <kpid>, suid <suid>
00:0014:00000:02998:2014/01/20 03:10:23.62 kernel ueshutdown: exiting
[On a server running in threaded mode rather than process mode, the following additional line is also output:]
00:0000:00000:00000:2014/01/20 03:10:23.62 kernel Main thread performing final shutdown.
00:0006:00000:00000:2013/07/22 09:36:07.02 kernel Engine 0 (os pid <pid> has died, server is performing emergency shutdown
[...]
stacktrace containing the function keipanic+0x8c (offset may vary by platform)
[...]
00:0006:00000:00000:2013/07/22 09:36:07.02 kernel ueshutdown: exiting
00:0006:00000:00000:2013/07/22 09:36:07.02kernel end of stack trace, kernel
service process: kpid 1114129
[no output added to log].
[no output added to log]
[no output added to log]
a) Errorlog's file system filled before the shutdown
b) Errorlog file disconnected from file descriptor used by ASE.
For example, errorlog copied to another file, original file deleted, copy renamed.
A possible hint for this is an unusual lack of entries preceeding the shutdown.
c) Errorlog could have been edited to remove information.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
32 | |
24 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |