Thanks Shoaib.

I could work around the Init cluster issue and made progress, however, now
the subscribe set is taking longer than expected. The logs are getting
updated with the following messages...

2010-07-23 06:08:00 BST DEBUG2 remoteWorkerThread_2: SYNC 897 processing
2010-07-23 06:08:00 BST DEBUG2 remoteWorkerThread_2: no sets need syncing
for this event
2010-07-23 06:08:00 BST DEBUG2 remoteWorkerThread_2: forward confirm 1,905
received by 2
2010-07-23 06:08:03 BST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 906
2010-07-23 06:08:03 BST DEBUG2 localListenThread: Received event 1,906 SYNC
2010-07-23 06:08:04 BST DEBUG2 remoteListenThread_2: queue event 2,898 SYNC
2010-07-23 06:08:04 BST DEBUG2 remoteWorkerThread_2: Received event 2,898
SYNC
2010-07-23 06:08:04 BST DEBUG2 calc sync size - last time: 1 last length:
4002 ideal: 14 proposed size: 3
2010-07-23 06:08:04 BST DEBUG2 remoteWorkerThread_2: SYNC 898 processing
2010-07-23 06:08:04 BST DEBUG2 remoteWorkerThread_2: no sets need syncing
for this event
2010-07-23 06:08:05 BST DEBUG2 remoteWorkerThread_2: forward confirm 1,906
received by 2
2010-07-23 06:08:13 BST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 907
2010-07-23 06:08:13 BST DEBUG2 localListenThread: Received event 1,907 SYNC
2010-07-23 06:08:15 BST DEBUG2 remoteListenThread_2: queue event 2,899 SYNC
2010-07-23 06:08:15 BST DEBUG2 remoteWorkerThread_2: Received event 2,899
SYNC
2010-07-23 06:08:15 BST DEBUG2 calc sync size - last time: 1 last length:
11003 ideal: 5 proposed size: 3
2010-07-23 06:08:15 BST DEBUG2 remoteWorkerThread_2: SYNC 899 processing
2010-07-23 06:08:15 BST DEBUG2 remoteWorkerThread_2: no sets need syncing
for this event
2010-07-23 06:08:15 BST DEBUG2 remoteWorkerThread_2: forward confirm 1,907
received by 2
2010-07-23 06:08:23 BST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 908
2010-07-23 06:08:23 BST DEBUG2 localListenThread: Received event 1,908 SYNC
2010-07-23 06:08:26 BST DEBUG2 remoteListenThread_2: queue event 2,900 SYNC
2010-07-23 06:08:26 BST DEBUG2 remoteWorkerThread_2: Received event 2,900
SYNC
2010-07-23 06:08:26 BST DEBUG2 calc sync size - last time: 1 last length:
11005 ideal: 5 proposed size: 3
2010-07-23 06:08:26 BST DEBUG2 remoteWorkerThread_2: SYNC 900 processing
2010-07-23 06:08:26 BST DEBUG2 remoteWorkerThread_2: no sets need syncing
for this event
2010-07-23 06:08:26 BST DEBUG2 remoteWorkerThread_2: forward confirm 1,908
received by 2
2010-07-23 06:08:33 BST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 909
2010-07-23 06:08:33 BST DEBUG2 localListenThread: Received event 1,909 SYNC
2010-07-23 06:08:37 BST DEBUG2 remoteListenThread_2: queue event 2,901 SYNC
2010-07-23 06:08:37 BST DEBUG2 remoteWorkerThread_2: Received event 2,901
SYNC
2010-07-23 06:08:37 BST DEBUG2 calc sync size - last time: 1 last length:
11003 ideal: 5 proposed size: 3
2010-07-23 06:08:37 BST DEBUG2 remoteWorkerThread_2: SYNC 901 processing
2010-07-23 06:08:37 BST DEBUG2 remoteWorkerThread_2: no sets need syncing
for this event
2010-07-23 06:08:37 BST DEBUG2 remoteWorkerThread_2: forward confirm 1,909
received by 2
2010-07-23 06:08:43 BST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 910
2010-07-23 06:08:43 BST DEBUG2 localListenThread: Received event 1,910 SYNC
2010-07-23 06:08:48 BST DEBUG2 remoteListenThread_2: queue event 2,902 SYNC
2010-07-23 06:08:48 BST DEBUG2 remoteWorkerThread_2: Received event 2,902
SYNC
2010-07-23 06:08:48 BST DEBUG2 calc sync size - last time: 1 last length:
11003 ideal: 5 proposed size: 3
2010-07-23 06:08:48 BST DEBUG2 remoteWorkerThread_2: SYNC 902 processing
2010-07-23 06:08:48 BST DEBUG2 remoteWorkerThread_2: no sets need syncing
for this event
2010-07-23 06:08:48 BST DEBUG2 remoteWorkerThread_2: forward confirm 1,910
received by 2
2010-07-23 06:08:53 BST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 911
2010-07-23 06:08:53 BST DEBUG2 localListenThread: Received event 1,911 SYNC

Just want to make sure that my Slon process is moving ahead and doing an
Initial Sync from Master to Slave.

Thanks for your help

Regards
Hari Kiran

On Fri, Jul 23, 2010 at 9:53 AM, Shoaib Mir <shoaibmir at gmail.com> wrote:

> On Fri, Jul 23, 2010 at 12:09 PM, Hari Kiran <hari.kiran at enterprisedb.com>
>  wrote:
>
>> ====ERROR:
>>
>>
>> *-bash-3.2$ ./slonik_init_cluster -c etc/slon_tools.conf|./slonik
>> <stdin>:6: Possible unsupported PostgreSQL version (80401) 8.4, defaulting
>> to 8.3 support
>> <stdin>:6: loading of file
>> /opt/PostgresPlus/8.4SS/share/postgresql/slony1_base.sql: PGRES_FATAL_ERROR
>> ERROR:  type "_cms_replica.xxid" does not exist
>> LINE 60:  set_locked   "_cms_replica".xxid,
>> *
>>
>
> Have you installed Slony against 8.4? looks like you got 8.3 and 8.4 on
> same machine and Slony not been built properly against 8.4. Make sure you
> have all the required .so and bin files built against 8.4 and not using the
> 8.3 files!
>
> --
> Shoaib Mir
> http://shoaibmir.wordpress.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100723/cf6e4adc/attachment.htm