Article View: borland.public.interbase.replication
Article #65How to drop Indices in REPL_LOG and will it cause any problem??
From: 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
Technical Details
Message-ID:
<86fea987.0411170343.54a59c8b@posting.google.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: f89d7,5633e899ecb23dc3,start X-Google-Attributes: gidf89d7,public X-Google-Language: ENGLISH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!not-for-mail From: mwongxn@yahoo.com (mc) Newsgroups: borland.public.interbase.replication Subject: How to drop Indices in REPL_LOG and will it cause any problem?? Date: 17 Nov 2004 03:43:50 -0800 Organization: http://groups.google.com Lines: 44 Message-ID: <86fea987.0411170343.54a59c8b@posting.google.com> NNTP-Posting-Host: 202.156.2.210 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1100691830 7113 127.0.0.1 (17 Nov 2004 11:43:50 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 17 Nov 2004 11:43:50 +0000 (UTC)