Troubleshooting and Error Messages Guide

Home

Troubleshooting and Error Messages Guide

Chapter 3 Error Message Writeups

Lock Manager Errors

Error 1279

Severity

Error message text

SQL Server has run out of locks on engine %d. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure maximum engine freelocks or number of locks.

Explanation

An Adaptive Server engine is a process running an Adaptive Server that communicates with other Adaptive Server processes via shared memory. An Adaptive Server running on a multiprocessor machine can have one or more engines.

Adaptive Server uses two configuration parameters to control lock use:

number of locks controls lock use Server-wide
max engine freelocks controls lock use for each Adaptive Server engine

Adaptive Server maintains a list of Server-wide free locks and a list of per-engine free locks. When locks are needed for an engine, Adaptive Server moves a block of free locks from the Server-wide free lock list to the free lock cache for that engine.

Error 1279 occurs when Adaptive Server runs out of locks on an engine and is unable to move any more locks from the Server-wide free list but there is an another engine with some free locks. (Error 1204 occurs when Adaptive Server completely runs out of locks.) The error message includes the number of the engine that has run out of locks.

Action

Run your command again later when there are fewer active users or increase the number of locks available to the engine. If you want to increase the resources, you can do one of the following:

Increase the total number of locks available Server-wide by using sp_configure to increase the value of the number of locks configuration parameter.
Decrease the maximum number of locks available for each engine by using sp_configure to decrease the value of the max engine freelocks configuration parameter. By decreasing the value of this parameter, you make more locks available to the engine for which you are getting the error.
Increasing the value of the number of locks parameter increases the memory resources used by Adaptive Server. Make sure your Adaptive Server memory is configured appropriately if you change this value.

Additional information

Refer to "Lock Manager" in the System Administration Guide for information about Adaptive Server engines and the Adaptive Server Lock Manager.

Refer to the Reference Manual for information about sp_configure and configuration parameters.

Refer to the Performance and Tuning Guide for information about memory management for Adaptive Server.

Versions in which this error is raised

All versions


	Expand Search