Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

sybase consistency check errors

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)
----------------------------------------------------
PleTax01 MYSQL_DBPT1>
ASKER CERTIFIED SOLUTION
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of motioneye

ASKER

Hi,
OK let me try with checkverify.