Fri Mar 10 02:21:46 PST 2006
- Previous message: [Slony1-general] Slon not catching up
- Next message: [Slony1-general] Null ev_type for events in sl_event table?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slon not catching up
- Next message: [Slony1-general] Null ev_type for events in sl_event table?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list