Replication with filtering turned on indexes.
This last week I had some maintenance where I had to drop my replicate
definition and redefine it. One of my table had filtering turned on the
indexes and constraints, leftover from a HPL which failed to change the
indexes an constraints back to enabled. I successfully defined the replicate
and believed everything was fine. After watching some transactions be
replicated I started seeing every transaction fail on the target server(the
server with the filtering enabled). Looking at the RIS files I was getting
ISAM:103. We ran an oncheck -cc <database> and got the following error. Has
anyone else seen this problem or found anything in the documentation which
would explain this? I can reproduce the problem.
Background info:
update anywhere definition.
Informix 7.31.uc5
oncheck -cc class
Validating database class
Validating systables for database class
ERROR: informix.cdr_deltab_000001 nindexes 1 != tblspace.nkeys 0 + detached
keys 0
ERROR: di_nkeys 0 != systables nindexes 1 - detached keys 0
for table informix.cdr_deltab_000001.
TBLspace name cdr_deltab_000001
Owner informix
TBLspace number f00011
Tabid 180
Row size 115
Number of columns 35
Number of indexes 1
Number of rows 0
Date created 07/31/2000
TBLspace major version number 180
TBLspace minor version number 1
TBLspace type T
Locking level R
Number of pages used 0
First extent size 32
Next extent size 32
Flags 0
Site
Database name
Validating syscolumns for database class
Validating sysindexes for database class
ERROR: No index found for sysindexes record.
Index name 180_175
Owner informix
Tabid 180
Index type U
Clustered
Part 1 4
Part 2 3
Part 3 0
Part 4 0
Part 5 0
Part 6 0
Part 7 0
Part 8 0
Number of levels -32768
Number of leaves -2147483648
Unique -2147483648
Clustness -2147483648
Validating systabauth for database class
Validating syscolauth for database class
Validating sysdepend for database class
WARNING:No sysdepend records found.
Validating syssyntable for database class
WARNING:No syssyntable records found.
Validating sysviews for database class
WARNING:No sysviews records found.
Validating sysconstraints for database class