motioneye
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.100106020 001.cons.l og.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>
PleTax01 MYSQL_DBPT1> zcat MYSQL_DBPT1.Test.100106020
==========================
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK let me try with checkverify.