Tue Mar 4 01:26:53 PST 2008
- Previous message: [Slony1-general] failover problems with 3 nodes
- Next message: [Slony1-general] Subscribe set problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All,
I trying to replicate a large database (2GB) from the master to a slave.
The master has about 60 tables. When I added the smaller tables (<100000
rows) it replicates but it queues up the sync events from the master and I
don't see any data in the slave tables until its done.
When I added a large table to another replication set, it takes like
forever (which isn't the problem) but whenever there is a break in the
internet connection, there is no data in the table when I it (after stopping
the daemons) and when I restart daemon, it gives a "ERROR: Slony-I
setAddTable_int(): table id 1 has already been assigned!" even though I am
adding any table to the replication set.
Also I noticed that if I add the command:
sync (id=1);
wait for event (origin=1, confirmed=2, wait on=1, timeout=0);
to the subscribe command, it doesn't return until all the data has been
copied (for small tables) or it never does (for a large table).
Does any one have an idea what could be wrong? I am following the
commands as specified in the "Replicating Your First Database" section of
the Slony help.
Also, when replicating a table which is always updated every 3 minutes,
does slony added just the new data or does it start copying all the data
again?
Victor
--
View this message in context: http://www.nabble.com/Subscribe-set-problem-tp15823349p15823349.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.
- Previous message: [Slony1-general] failover problems with 3 nodes
- Next message: [Slony1-general] Subscribe set problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list