When I query a view in SQL server, I get this error:
Server: Msg 1203, Level 20, State 1, Line 1
Process ID 10 attempting to unlock unowned resource PAG: 10:1:2258.
Connection Broken
This is the explanation and action I found for this error:
***********************************************************
Explanation
This error occurs when Microsoft SQL Server is engaged in some activity other than normal post-processing cleanup and it finds that a particular page it is attempting to unlock is already unlocked. The underlying cause for this error may be related to structural problems within the affected database. SQL Server manages the acquisition and release of pages to maintain concurrency control in the multiuser environment. This mechanism is maintained through the use of various internal lock structures that identify the page and the type of lock present. Locks are acquired for processing of affected pages and released when the processing is completed.
Action
Execute DBCC CHECKDB against the database in which the object belongs. If DBCC CHECKDB reports no errors, attempt to reestablish the connection and execute the command.
************************************************************
But when I run the DBCC CHECKDB, I do not get any errors, but I still get the error when I execute the sql.
The strange thing is, when I execute the same sql with a different where clause it works, it doesn't work for a particular where clause (say 'DEF').
eg:
select * from view - works
select col1, col2 from view - works
select col1, col2 from view where col1 = 'ABC' - works
select col1, col2 from view where col1 = 'DEF' - doesn't work
select * from view where col1 = 'DEF' - works
I wonder if someone's been thru this - pl. help!
Thank you.
Server: Msg 1203, Level 20, State 1, Line 1
Process ID 10 attempting to unlock unowned resource PAG: 10:1:2258.
Connection Broken
This is the explanation and action I found for this error:
***********************************************************
Explanation
This error occurs when Microsoft SQL Server is engaged in some activity other than normal post-processing cleanup and it finds that a particular page it is attempting to unlock is already unlocked. The underlying cause for this error may be related to structural problems within the affected database. SQL Server manages the acquisition and release of pages to maintain concurrency control in the multiuser environment. This mechanism is maintained through the use of various internal lock structures that identify the page and the type of lock present. Locks are acquired for processing of affected pages and released when the processing is completed.
Action
Execute DBCC CHECKDB against the database in which the object belongs. If DBCC CHECKDB reports no errors, attempt to reestablish the connection and execute the command.
************************************************************
But when I run the DBCC CHECKDB, I do not get any errors, but I still get the error when I execute the sql.
The strange thing is, when I execute the same sql with a different where clause it works, it doesn't work for a particular where clause (say 'DEF').
eg:
select * from view - works
select col1, col2 from view - works
select col1, col2 from view where col1 = 'ABC' - works
select col1, col2 from view where col1 = 'DEF' - doesn't work
select * from view where col1 = 'DEF' - works
I wonder if someone's been thru this - pl. help!
Thank you.