sybase consistency check errors

Posted on 2010-01-08
Last Modified: 2012-05-08
I getting below consistency check error, what should I do next to fix the problem

PleTax01 MYSQL_DBPT1> zcat MYSQL_DBPT1.Test.100106020001.cons.log.Z

Consistency Check is started as part of
backup_sybase MYSQL_DBPT1 -checkstorage started 10-01-06.02:00:00
Consistency Check run 02:00:01 - 10-01-06.02:05:55

MYSQL_DBPT1.Test   : Consistency check FAILED CS 10-01-06.02:05:55


Database Name : Test

 Table Name              Index  PartitionId Fault Type                Page Number
 ----------------------- ------ ----------- ------------------------- -----------
 Test_Belian_Dua      2   772314657 100012 (wrong type error)       76892
(return status = 0)
Question by:motioneye
    LVL 24

    Accepted Solution

    Ok, first of all, we can't tell what you're doing since it looks like you're running an in-house script. It seems like the script is running dbcc checkstorage though.

    If checkstorage throws an error, the next thing to do is to run dbcc checkverify instead (depending on exactly what version of ASE you have, though). Checkverify looks at the most recently run checkstorage and tries to verify if there's really a problem.

    It might take a while to run!

    It's all written up pretty well in the ASE 12.5.x Troubleshooting Guide, or the ASE 15.0.x Administration Guide.

    Author Comment

    OK let me try with checkverify.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    This is an issue that we can get adding / removing permissions in the vCSA 6.0. We can also have issues searching for users / groups in the AD (using your identify sources). This is how one of the ways to handle this issues and fix it.
    Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now