Post reply

Consistency errors in table 'sys.sysobjvalues' (object ID 60)

  • January 20, 2015 at 2:12 am

    #314713

    Good day All,

    I would appreciate your expert recommendations on getting this issue resolved.

    I am a relative newby to SQL to please bear with me.

    I have run a DBCC CHECKDB (mydb) with no_infomsgs and get the following result:

    Msg 8935, Level 16, State 1, Line 1

    Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). The previous link (1:51553) on page (1:45424) does not match the previous page (1:94976) that the parent (1:97186), slot 255 expects for this page.

    Msg 8934, Level 16, State 1, Line 1

    Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). The high key value on page (1:94976) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:51553).

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). Parent node for page (1:51553) was not encountered.

    CHECKDB found 0 allocation errors and 3 consistency errors in table 'sys.sysobjvalues' (object ID 60).

    I then tried running the DBCC to repair allow data loss and get the following:

    Msg 1505, Level 16, State 1, Line 1

    The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'sys.sysobjvalues' and the index name 'clst'. The duplicate key value is (60, 2101074721, 18, 0).

    DBCC CheckDB(mydb) WITH NO_INFOMSGS, ALL_ERRORMSGS results:

    Msg 8935, Level 16, State 1, Line 1

    Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). The previous link (1:51553) on page (1:45424) does not match the previous page (1:94976) that the parent (1:97186), slot 284 expects for this page.

    Msg 8934, Level 16, State 1, Line 1

    Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). The high key value on page (1:94976) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:51553).

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). Parent node for page (1:51553) was not encountered.

    CHECKDB found 0 allocation errors and 3 consistency errors in table 'sys.sysobjvalues' (object ID 60).

    CHECKDB found 0 allocation errors and 3 consistency errors in database 'mydb'.

    repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (mydb).

    How do I go about resolving the duplicate error on the sys.sysobjvalues?

    Regards,

  • January 20, 2015 at 11:25 pm

    This was removed by the editor as SPAM

  • January 20, 2015 at 11:45 pm

    #1771685

    Thank you for the reply.

    Unfortunately, there are no other backups available.

    The database recovery mode is set to simple although having a relatively large log file.

    The client would like to use this database purely for reading data from within the application. This is also a requirement from the local tax authorities for reporting.

    All other databases using the application has been upgraded to a later version of the application, and is not backward compatible.

  • August 22, 2021 at 7:20 pm

    This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

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