Thu Jun 10 14:00:21 PDT 2004
- Previous message: [Slony1-general] slony setup
- Next message: [Slony1-general] slony setup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I think I have things more or less configured, but I still seem to be missing something. When I try to run my second slon process (both databases are in the same cluster), I get the following output: CONFIG main: local node id = 2 CONFIG main: loading current cluster configuration CONFIG storeNode: no_id=1 no_comment='Node 1' DEBUG2 setNodeLastEvent: no_id=1 event_seq=19 CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=pgbench1 port=24101" pa_connretry=10 CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1 CONFIG storeSet: set_id=1 set_origin=1 set_comment='All pgbench tables' WARN remoteWorker_wakeup: node 1 - no worker thread DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled) CONFIG storeSubscribe: sub_set=1 sub_provider=1 sub_forward='t' WARN remoteWorker_wakeup: node 1 - no worker thread DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled) DEBUG2 main: last local event sequence = 10 CONFIG main: configuration complete - starting threads DEBUG1 localListenThread: thread starts CONFIG enableNode: no_id=1 DEBUG1 main: running scheduler mainloop DEBUG1 remoteWorkerThread_1: thread starts DEBUG1 remoteListenThread_1: thread starts DEBUG2 remoteListenThread_1: start listening for event origin 1 DEBUG1 cleanupThread: thread starts DEBUG1 syncThread: thread starts DEBUG4 remoteWorkerThread_1: update provider configuration DEBUG1 remoteListenThread_1: connected to 'dbname=pgbench1 port=24101' DEBUG2 remoteListenThread_1: queue event 1,20 ENABLE_SUBSCRIPTION DEBUG2 remoteListenThread_1: queue event 1,21 SYNC .... DEBUG2 remoteListenThread_1: queue event 1,59 SYNC DEBUG2 remoteListenThread_1: queue event 1,60 SYNC DEBUG2 remoteWorkerThread_1: Received event 1,20 ENABLE_SUBSCRIPTION DEBUG1 copy_set 1 DEBUG1 remoteWorkerThread_1: connected to provider DB DEBUG2 remoteWorkerThread_1: copy table public.accounts DEBUG3 remoteWorkerThread_1: table public.accounts does not require Slony-I serial key ERROR remoteWorkerThread_1: PQputCopyData() - could not receive data from server: Error 0 WARN remoteWorkerThread_1: data copy for set 1 failed - sleep 15 seconds I suspect that the problem has to do with the first WARN log that there is no worker thread, but I don't know if that's relevant, or how that situation can come about. Where should I start looking for configuration mistakes? Thanks. - DAP ====================================================== David Parker Tazz Networks (401) 709-5130
- Previous message: [Slony1-general] slony setup
- Next message: [Slony1-general] slony setup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list