Bi Way replication does not complete

Thread View: borland.public.interbase.replication

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by AG Fri, 23 Jan 2004 12:39

#137

Author: AG
Date: Fri, 23 Jan 2004 12:39

17 lines
1737 bytes

We have 2 IB dbases that replicate to each other using IBase Replic V
1.3. We use Ibase 6 open edition. When ever I do select count(*) from
repl_log in one database the result is always 394 and it appears that
both databases are up to date. In the other database the result is
currently 0. It seems that one database is just sending bucket loads
of data to the other database (500mb data/day) whereas the other
database sends only 50-60MB of data/day back.
I would like some advice as to what may be wrong with the set up of
the replication as the end result is excess download fees with our
ISP. How do I diagnose the error - it seems like one repl_log does not
get cleared despite sending the data. The database is only 600mb in
size.
This problem only started 1 month ago and the replication had never
caused this problem previously. Any advice as to the likely causes
would be appreciated
Thanks
Anthony

Re: Bi Way replication does not complete

#138

Author: AG
Date: Sat, 24 Jan 2004 06:15

12 lines
1559 bytes

My mistake....the replication is set to run continuously. That begs
the question...if there is no data to replicate what data is being
sent between the two databases. Is is possible to set the replication
that if no data is to be replicated then the replication stops until
more data is inserted into the database? My main question though is
what is causing such massive downloads when both databases are up to
date. (The repl_log table shows entries but these are just left overs
from how the replication was set up - certain tables were removed from
the replication setup and this is the left over data so in real terms
the repl_log table is being cleared)
Thanks
Anthony

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