Post reply

Viewing the data at the PAGID

  • February 12, 2004 at 1:04 pm

    #359108

    I got this error from of the app: 'spid12 Error: 1203, Severity: 20, State: 1 spid12 Process ID 12 attempting to unlock unowned resource PAG: 15:1:40595..' Is there a way I can check the PageID to see what data is in that page? thanks..

  • February 12, 2004 at 1:20 pm

    #493886

    From BOL.

    "

    Error 1203

    Severity Level 20
    Message Text

    Process ID %d attempting to unlock unowned resource %.*ls.

    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 multi-user 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.

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

  • February 12, 2004 at 1:41 pm

    #493891

    Thanks for the info. We have tried the dbcc check and no errors were reported. On Micorsoft's knowledge base site, they mention that this could be due to a bug, and to apply the latest sp. We are already on latest SP...

  • February 12, 2004 at 10:29 pm

    #493938

     

    use following to view contents of page 15 :1 : 40595  ( db id : file id : page number)

    dbcc traceon (3604)

    dbcc page (15 ,1, 40595)

    -- Amit


    -- Amit


    "There is no 'patch' for stupidity."


    Download the Updated SQL Server 2005 Books Online.

  • February 13, 2004 at 8:17 am

    #493994

    Use dbcc page, as Amit says.  But bear in mind that unless you check immediately, things could have changed and something else might be on that page now.  I don't know the overall rules/trends for this, but I have seen a page change from one object to another.

  • February 13, 2004 at 12:19 pm

    #494046

    Thanks for the DBCC command. I ran it but does not report any error. DBCC checkdb and alloc but find no error. Probably some bug in SQL.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply