Thread View: borland.public.interbase.replication
1 messages
1 total messages
Started by mc
Wed, 17 Nov 2004 11:43
How to drop Indices in REPL_LOG and will it cause any problem??
Author: mc
Date: Wed, 17 Nov 2004 11:43
Date: Wed, 17 Nov 2004 11:43
44 lines
2460 bytes
2460 bytes
We have 2 Servers running Windows 2000 Server and Interbase 7.01. One 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
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads