How to drop Indices in REPL_LOG and will it cause any problem??
mc
is setup as the SOURCE database and the other as a TARGET database.
We also setup Interbase Replication to replicate data every 180mins
from the SOURCE to the TARGET.
Recently, we noticed that bits and pieces of information are not being
replicated over to the TARGET database. Upon some investigation, we
realised that there are 60k+ records in the REPL_LOG table in the
SOURCE database that will not get replicated.
During our investigation, we run the statement "select * from
Repl_log" (using Interactive SQL) and it displayed the results on
screen. However, when we try
to scroll down the results, we'll encounter the following error:
database file appears corrupt ()
wrong page type
page 6277292 is of wrong type (expected 7, found 5)
I tried to export the results out by using 'Query' => 'Save Output'
but also get the same error message.
Note that we were able to perform a "select count(*) from Repl_log"
without any error.
One of our programmer suspected that this could be due to corruption
of the indices in the REPL_LOG table. If this is really the case, we
are thinking of dropping the indices for this REPL_LOG table and
re-creating it. In this way, we should be able to preserve the 60k+
records.
Questions:
1) Can anyone please advise if dropping the indices and recreating
them will cause any problem to the Interbase Replication??
2) How and where can we check for the indices that should be dropped
from this REPL_LOG table??
3) What's the command to drop and recreate these indices??
Please advise.
Thank you and Regards,
MC