Process ID %d attempted to unlock a resource it does not own: %.*ls. Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.

Details
Product: SQL Server
Event ID: 1203
Source: MSSQLServer
Version: 9.0
Component: SQLEngine
Symbolic Name: LK_NOT
Message: Process ID %d attempted to unlock a resource it does not own: %.*ls. Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.
   
Explanation

This error occurs when SQL Server 2005 is engaged in some activity other than ordinary post-processing cleanup and it finds that a particular page that it is trying to unlock is already unlocked.

   
User Action

Execute DBCC CHECKDB against the database in which the object belongs. If DBCC CHECKDB reports no errors, try to reestablish the connection and execute the command.

Important:

If you are executing DBCC CHECKDB with one of the REPAIR clauses does not correct the index problem, or if you are not sure what effect DBCC CHECKDB with a REPAIR clause has on your data, contact your primary support provider.

Related:

Leave a Reply