This section contains error messages pertaining to killing Adaptive Server processes.
17
Unable to do cleanup for the killed process; received Msg %d.
Upon termination of any Adaptive Server process, the server attempts to clean up by releasing resources used by the terminated process. Error 6103 occurs when the server is unable to complete this cleanup. The “Msg %d” appearing in the 6103 message text identifies the error that was received during cleanup.
Error 6103 usually occurs after some other error or when an Adaptive Server process is aborted. This error can be serious as it can cause data corruption or an abnormal Adaptive Server shutdown.
Error 6103 is usually caused by the errors that occurred before it or by an Adaptive Server problem.
Review the error log to identify errors that occurred before the 6103 error. Use the information in this manual to recover from those errors. If errors are not covered in this manual, call Technical Support for assistance.
To recover from Error 6103 after reviewing other errors in the error log, shut down and restart Adaptive Server.
If you cannot perform an Adaptive Server shutdown, kill the Server process at the operating system level.
Run dbcc checkdb for the database that was being accessed by the killed process to determine whether data corruption has occurred. If other errors are displayed when dbcc checkdb is run, refer to the writeups in this manual for those errors to determine how to recover from them.
If the 6103 error occurs again or resources (such as locks) are not released, call Sybase Technical Support.
All versions
14
Only User processes can be KILLed or SYB_TERMINATEd.
A process is a task that is being carried out by Adaptive Server. Processes can be initiated by a user giving a command, or by Adaptive Server itself. You can see information about processes by running the system procedure sp_who.
Error 6107 is raised following an improper attempt to kill an Adaptive Server process; for example, it may be raised if you try to kill a background process. The error is raised with the following states:
State |
Meaning |
|---|---|
1 |
Attempted to kill a process that is not a user process (pre-12.0). Attempted to kill a process that is not a user process or an agent process for quiesce database (12.0). |
2 |
Attempted to kill an agent process for quiesce database, but the spid requesting the kill is not the parent process of the agent (12.0). |
Use sp_who to check the currently running processes and identify the process in question. Refer to “Killing Processes” in the System Administration Guide for a description of process status values and the effect of the kill command. If the error was raised when you attempted to clear a "killable" user process, take the following steps:
Perform a checkpoint in each database:
1> use database_name 2> go 1> checkpoint 2> go
Shut down the server using the nowait option:
1> shutdown with nowait 2> go
Restart the server.
If you need to terminate a batch program or other application which logs in to Adaptive Server, always terminate the server process first using the kill command before attempting to terminate the batch at the operating system level.
All versions
