Troubleshooting and Error Messages Guide

Home

Troubleshooting and Error Messages Guide

Chapter 3 Error Message Writeups

Process Kill Errors

Error 6107

Severity

Error message text

Only User processes can be KILLed or SYB_TERMINATEd.

Explanation

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).

Action

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.

Additional information

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.

Versions in which this error is raised

All versions


	Expand Search