Hello Team,

Request your help in finding the issue with Slony replication. This is a new
Slony setup of 381 Tables & 282 Sequences (the DB size of master is 160GB)

Steps I followed are:

Initialize the slony setup:
./slonik_init_cluster -c slon_tools.conf| ./slonik
=================================
Creating SETS:
./slonik_create_set -c slon_tools.conf 1|./slonik
Starting Slon Deamons and Watchdog process
./slon_start -c slon_tools.conf 1
./slon_start -c slon_tools.conf 2
=================================
Subscribing sets:
Usage: subscribe_set [--config file] set# node#
./slonik_subscribe_set -c slon_tools.conf 1 2|slonik

After subscribing the set, I am seeing the below logging in the logs
directory of Slony. I never saw the statements "Truncating table"...
Is the Slony performing the replication or not? When I am seeing the logs of
node1, I see the following...

2010-03-23 10:28:43 EDT DEBUG2 localListenThread: Received event 2,900 SYNC
2010-03-23 10:28:47 EDT DEBUG2 remoteListenThread_1: queue event 1,919 SYNC
2010-03-23 10:28:47 EDT DEBUG2 remoteWorkerThread_1: Received event 1,919
SYNC
2010-03-23 10:28:47 EDT DEBUG2 calc sync size - last time: 1 last length:
11004 ideal: 5 proposed size: 3
2010-03-23 10:28:47 EDT DEBUG2 remoteWorkerThread_1: SYNC 919 processing
2010-03-23 10:28:47 EDT DEBUG2 remoteWorkerThread_1: syncing set 1 with 0
table(s) from provider 1
2010-03-23 10:28:47 EDT DEBUG2 remoteWorkerThread_1: current local
log_status is 0
2010-03-23 10:28:47 EDT DEBUG2 remoteWorkerThread_1_1: current remote
log_status = 0
2010-03-23 10:28:47 EDT DEBUG2 remoteHelperThread_1_1: 0.001 seconds delay
for first row
2010-03-23 10:28:47 EDT DEBUG2 remoteHelperThread_1_1: 0.004 seconds until
close cursor
2010-03-23 10:28:47 EDT DEBUG2 remoteHelperThread_1_1: inserts=0 updates=0
deletes=0
2010-03-23 10:28:47 EDT DEBUG2 remoteWorkerThread_1: new sl_rowid_seq value:
1000000000000000
2010-03-23 10:28:47 EDT DEBUG2 remoteWorkerThread_1: SYNC 919 done in 0.012
seconds
2010-03-23 10:28:47 EDT DEBUG2 remoteWorkerThread_1: forward confirm 2,900
received by 1
2010-03-23 10:28:50 EDT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 901

Appreciate your time and help.

Thanks & Regards
Hari Kiran
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100323/2556d048/attachment-0001.htm