MSSQLSERVER_1222
Details
Product Name |
SQL Server |
Product Version |
10.0 |
Product Build Number |
10 |
Event ID |
1222 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
LK_TIMEOUT |
Message Text |
Lock request time out period exceeded. |
Explanation
Another transaction held a lock on a required resource longer than this query could wait for it.
User Action
Perform the following tasks to alleviate the problem:
Locate the transaction that is holding the lock on the required resource, if possible. Use sys.dm_os_waiting_tasks and sys.dm_tran_locks dynamic management views.
If the transaction is still holding the lock, terminate that transaction if appropriate.
Execute the query again.
If this error occurs frequently change the lock time-out period or modify the offending transactions so that they hold the lock for less time.
Internal-Only
<xmrFileHeader><buildNo>9.00.1281.60</buildNo><component>SQLEngine</component><dsDbName></dsDbName><dsProjectName>SQLServer2005</dsProjectName><exportDate>2005-08-22T14:00:12</exportDate><importDate>2005-08-22T12:43:00</importDate><prodContact>pingwang</prodContact><prodName>SQL Server</prodName><prodVer>9.0</prodVer><sourceFileDepotPath></sourceFileDepotPath><sourceFileExt></sourceFileExt><sourceFileName></sourceFileName><userDefined></userDefined><xmrFilePath>.\sqlXMR.xml</xmrFilePath></xmrFileHeader><resourceString resourceStringGuid="c5b1c2f4-f591-4cc1-aa17-204636a27f29" resourceStringProxyID="MSSQL_ENG001222"><exportStatus>Do Not Export</exportStatus><importStatus>Unchanged</importStatus><inActive>No</inActive><inserts></inserts><message><cause>Lock held by someone longer than this connection wanted to wait for it</cause><causeCorrectiveActionStatus>Dev Signed Off</causeCorrectiveActionStatus><correctiveAction>If possible, find the transaction which is holding the lock resource on which this transaction timedout and terminate that transaction if appropriate. If this error is frequent, it may be necessary to change the lock timeout period if appropriate, or the transactions that hold the lock resource need to be modified so that they hold the lock for a shorter duration thus avoiding this timeout. If the owner has already released the lock, the query can be reexecuted.</correctiveAction><error><exMsgBoxID></exMsgBoxID><exMsgBoxSource></exMsgBoxSource></error><event><eventCategory></eventCategory><eventFacility></eventFacility><eventLanguage></eventLanguage><eventSeverityType></eventSeverityType><eventType></eventType><momEvent>Yes</momEvent><momOwner>borisb</momOwner><winRegEventID>1222</winRegEventID><winRegEventSource>MSSQLSERVER</winRegEventSource></event><msuid></msuid></message><numericID>1222</numericID><owner>santeriv</owner><pssReview><pssComments></pssComments><pssDebugger>No</pssDebugger><pssEngineer></pssEngineer><PSSSupportability>No</PSSSupportability></pssReview><suspect>No</suspect><symbolicName>LK_TIMEOUT</symbolicName><text>Lock request time out period exceeded.</text><type></type><ueReview><assignedTo></assignedTo><bugID></bugID><bugRequired>No</bugRequired><comments></comments><docStudio><dsTopicId></dsTopicId><export>Yes</export></docStudio><editor></editor><revisedStringText></revisedStringText><workStatus>Not Reviewed</workStatus><writer></writer></ueReview><userDefined><eventLoggingLevel></eventLoggingLevel></userDefined></resourceString>