Barry barry
Fri Mar 10 02:21:46 PST 2006
Hi

I am trying to get the slony_example to run with no luck.
My 2 nodes are on 2 different servers (node 1 : 10.0.0.1 ; node 2 : 
10.0.0.2).

Here is the output from slon on node 2:

# slon $CLUSTERNAME "dbname=$SLAVEDBNAME user=$REPLICATIONUSER 
host=$SLAVEHOST"

2006-03-10 10:18:00 SAST CONFIG main: slon version 1.1.5 starting up
2006-03-10 10:18:00 SAST CONFIG main: local node id = 2
2006-03-10 10:18:00 SAST CONFIG main: launching sched_start_mainloop
2006-03-10 10:18:00 SAST CONFIG main: loading current cluster configuration
2006-03-10 10:18:00 SAST CONFIG storeNode: no_id=1 no_comment='Master Node'
2006-03-10 10:18:00 SAST CONFIG storePath: pa_server=1 pa_client=2 
pa_conninfo="dbname=pgbench host=10.0.0.1 user=postgres" pa_connretry=10
2006-03-10 10:18:00 SAST CONFIG storeListen: li_origin=1 li_receiver=2 
li_provider=1
2006-03-10 10:18:00 SAST CONFIG storeSet: set_id=1 set_origin=1 
set_comment='All pgbench tables'
2006-03-10 10:18:00 SAST WARN   remoteWorker_wakeup: node 1 - no worker 
thread
2006-03-10 10:18:00 SAST CONFIG storeSubscribe: sub_set=1 sub_provider=1 
sub_forward='f'
2006-03-10 10:18:00 SAST WARN   remoteWorker_wakeup: node 1 - no worker 
thread
2006-03-10 10:18:00 SAST CONFIG enableSubscription: sub_set=1
2006-03-10 10:18:00 SAST WARN   remoteWorker_wakeup: node 1 - no worker 
thread
2006-03-10 10:18:00 SAST CONFIG main: configuration complete - starting 
threads
2006-03-10 10:18:00 SAST DEBUG1 localListenThread: thread starts
NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=11992
2006-03-10 10:18:00 SAST CONFIG enableNode: no_id=1
2006-03-10 10:18:00 SAST DEBUG1 main: running scheduler mainloop
2006-03-10 10:18:00 SAST DEBUG1 remoteWorkerThread_1: thread starts
2006-03-10 10:18:00 SAST DEBUG1 cleanupThread: thread starts
2006-03-10 10:18:00 SAST DEBUG1 remoteWorkerThread_1: helper thread for 
provider 1 created
2006-03-10 10:18:00 SAST DEBUG1 remoteListenThread_1: thread starts
2006-03-10 10:18:00 SAST DEBUG1 syncThread: thread starts
2006-03-10 10:18:01 SAST DEBUG1 remoteListenThread_1: connected to 
'dbname=pgbench host=10.0.0.1 user=postgres'
2006-03-10 10:18:05 SAST DEBUG1 remoteWorkerThread_1: connected to data 
provider 1 on 'dbname=pgbench host=10.0.0.1 user=postgres'

I am getting a "no worker thread" warning as soon as there is a storeSet.
Would this be why the replication does not take place and how would I 
fix this?

Please let me know if you need more configuration / log information.

Thanks,
Barry





More information about the Slony1-general mailing list