Fri Apr 22 11:21:11 PDT 2005
- Previous message: [Slony1-general] need node 1?
- Next message: [Slony1-general] No syncron
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I did all what the documentation said. Altough all the example based on master and slave on the same machine, I would like to have the syncron between local and remote. Based on the logs all seems to be perfect, but when an update on the master happens, the query does return the old value on the slave. After running the init script I got no errors at the shell prompt, but I got some strange messages in the attached psql.log file, although I do not know what that means, maybe important. I run out of ideas Im trying to get this done three days by now. Maybe something is missing here, or something wrong ... Any help appreciated: Feczo -------------- next part -------------- CONFIG main: slon version 1.0.5 starting up CONFIG main: local node id = 1 CONFIG main: loading current cluster configuration CONFIG storeNode: no_id=2 no_comment='Slave node' DEBUG2 setNodeLastEvent: no_id=2 event_seq=15 CONFIG storePath: pa_server=2 pa_client=1 pa_conninfo="dbname=fewoking host=10.0.0.2 user=pgsql" pa_connretry=10 CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2 CONFIG storeSet: set_id=1 set_origin=1 set_comment='All pgbench tables' DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled) DEBUG2 main: last local event sequence = 18 CONFIG main: configuration complete - starting threads DEBUG1 localListenThread: thread starts CONFIG enableNode: no_id=2 DEBUG1 main: running scheduler mainloop DEBUG1 remoteWorkerThread_2: thread starts DEBUG1 remoteListenThread_2: thread starts DEBUG2 remoteListenThread_2: start listening for event origin 2 DEBUG1 cleanupThread: thread starts DEBUG1 syncThread: thread starts DEBUG4 remoteWorkerThread_2: update provider configuration DEBUG1 remoteListenThread_2: connected to 'dbname=fewoking host=10.0.0.2 user=pgsql' DEBUG2 remoteWorkerThread_2: forward confirm 1,18 received by 2 DEBUG2 syncThread: new sl_action_seq 1 - SYNC 19 DEBUG2 localListenThread: Received event 1,19 SYNC DEBUG2 remoteWorkerThread_2: forward confirm 1,19 received by 2 DEBUG2 remoteListenThread_2: queue event 2,16 SYNC DEBUG2 remoteWorkerThread_2: Received event 2,16 SYNC DEBUG2 remoteWorkerThread_2: SYNC 16 processing DEBUG2 remoteWorkerThread_2: no sets need syncing for this event DEBUG2 syncThread: new sl_action_seq 1 - SYNC 20 DEBUG2 localListenThread: Received event 1,20 SYNC DEBUG2 remoteWorkerThread_2: forward confirm 1,20 received by 2 DEBUG2 remoteListenThread_2: queue event 2,17 SYNC DEBUG2 remoteWorkerThread_2: Received event 2,17 SYNC DEBUG2 remoteWorkerThread_2: SYNC 17 processing DEBUG2 remoteWorkerThread_2: no sets need syncing for this event INFO remoteListenThread_2: disconnecting from 'dbname=fewoking host=10.0.0.2 user=pgsql' DEBUG1 remoteListenThread_2: thread done DEBUG1 localListenThread: thread done DEBUG1 syncThread: thread done DEBUG1 main: scheduler mainloop returned DEBUG2 sched_wakeup_node(): no_id=2 (0 threads + worker signaled) DEBUG4 remoteWorkerThread_2: update provider configuration DEBUG1 cleanupThread: thread done DEBUG1 remoteWorkerThread_2: thread done DEBUG1 main: done -------------- next part -------------- CONFIG main: slon version 1.0.5 starting up CONFIG main: local node id = 2 CONFIG main: loading current cluster configuration CONFIG storeNode: no_id=1 no_comment='Master Node' DEBUG2 setNodeLastEvent: no_id=1 event_seq=18 CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=fewoking host=10.0.0.1 user=pgsql" 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='f' WARN remoteWorker_wakeup: node 1 - no worker thread DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled) CONFIG enableSubscription: sub_set=1 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 = 15 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 remoteWorkerThread_1: helper thread for provider 1 created DEBUG4 remoteWorkerThread_1: added active set 1 to provider 1 DEBUG4 remoteHelperThread_1_1: waiting for work DEBUG1 remoteListenThread_1: connected to 'dbname=fewoking host=10.0.0.1 user=pgsql' DEBUG2 remoteListenThread_1: queue event 1,19 SYNC DEBUG2 remoteWorkerThread_1: Received event 1,19 SYNC DEBUG2 remoteWorkerThread_1: SYNC 19 processing DEBUG1 remoteWorkerThread_1: connected to data provider 1 on 'dbname=fewoking host=10.0.0.1 user=pgsql' DEBUG2 remoteWorkerThread_1: syncing set 1 with 4 table(s) from provider 1 DEBUG3 remoteWorkerThread_1: activate helper 1 DEBUG4 remoteWorkerThread_1: waiting for log data DEBUG4 remoteHelperThread_1_1: allocate lines DEBUG4 remoteHelperThread_1_1: have 10 line buffers DEBUG2 remoteHelperThread_1_1: 0.003 seconds delay for first row DEBUG3 remoteHelperThread_1_1: got 0 log rows DEBUG3 remoteHelperThread_1_1: 0 log buffers deliverd DEBUG4 remoteHelperThread_1_1: no more log rows DEBUG2 remoteHelperThread_1_1: 0.004 seconds until close cursor DEBUG4 remoteHelperThread_1_1: change helper thread status DEBUG4 remoteHelperThread_1_1: send DONE/ERROR line to worker DEBUG3 remoteHelperThread_1_1: waiting for workgroup to finish DEBUG3 remoteWorkerThread_1: helper 1 finished DEBUG4 remoteWorkerThread_1: returning lines to pool DEBUG3 remoteWorkerThread_1: all helpers done. DEBUG4 remoteWorkerThread_1: changing helper 1 to IDLE DEBUG4 remoteWorkerThread_1: cleanup DEBUG4 remoteHelperThread_1_1: waiting for work DEBUG2 remoteWorkerThread_1: new sl_rowid_seq value: 1000000000000000 DEBUG2 remoteWorkerThread_1: SYNC 19 done in 0.019 seconds DEBUG2 remoteWorkerThread_1: forward confirm 2,15 received by 1 DEBUG2 syncThread: new sl_action_seq 1 - SYNC 16 DEBUG2 localListenThread: Received event 2,16 SYNC DEBUG2 remoteWorkerThread_1: forward confirm 2,16 received by 1 DEBUG2 remoteListenThread_1: queue event 1,20 SYNC DEBUG2 remoteWorkerThread_1: Received event 1,20 SYNC DEBUG2 remoteWorkerThread_1: SYNC 20 processing DEBUG2 remoteWorkerThread_1: syncing set 1 with 4 table(s) from provider 1 DEBUG3 remoteWorkerThread_1: activate helper 1 DEBUG4 remoteWorkerThread_1: waiting for log data DEBUG4 remoteHelperThread_1_1: allocate lines DEBUG4 remoteHelperThread_1_1: have 10 line buffers DEBUG2 remoteHelperThread_1_1: 0.001 seconds delay for first row DEBUG3 remoteHelperThread_1_1: got 0 log rows DEBUG3 remoteHelperThread_1_1: 0 log buffers deliverd DEBUG4 remoteHelperThread_1_1: no more log rows DEBUG2 remoteHelperThread_1_1: 0.002 seconds until close cursor DEBUG4 remoteHelperThread_1_1: change helper thread status DEBUG4 remoteHelperThread_1_1: send DONE/ERROR line to worker DEBUG3 remoteHelperThread_1_1: waiting for workgroup to finish DEBUG3 remoteWorkerThread_1: helper 1 finished DEBUG4 remoteWorkerThread_1: returning lines to pool DEBUG3 remoteWorkerThread_1: all helpers done. DEBUG4 remoteWorkerThread_1: changing helper 1 to IDLE DEBUG4 remoteWorkerThread_1: cleanup DEBUG4 remoteHelperThread_1_1: waiting for work DEBUG2 remoteWorkerThread_1: new sl_rowid_seq value: 1000000000000000 DEBUG2 remoteWorkerThread_1: SYNC 20 done in 0.005 seconds DEBUG2 syncThread: new sl_action_seq 1 - SYNC 17 DEBUG2 localListenThread: Received event 2,17 SYNC DEBUG2 remoteWorkerThread_1: forward confirm 2,17 received by 1 DEBUG1 syncThread: thread done INFO remoteListenThread_1: disconnecting from 'dbname=fewoking host=10.0.0.1 user=pgsql' DEBUG1 remoteListenThread_1: thread done DEBUG1 localListenThread: thread done DEBUG1 cleanupThread: thread done DEBUG1 main: scheduler mainloop returned DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled) DEBUG4 remoteWorkerThread_1: update provider configuration DEBUG1 remoteWorkerThread_1: helper thread for provider 1 terminated DEBUG1 remoteWorkerThread_1: disconnecting from data provider 1 DEBUG1 remoteWorkerThread_1: thread done DEBUG1 main: done -------------- next part -------------- A non-text attachment was scrubbed... Name: psql.log Type: text/x-log Size: 2818 bytes Desc: not available Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050422/bacbaa43/psql.bin -------------- next part -------------- A non-text attachment was scrubbed... Name: slonik_init.sh Type: application/x-shellscript Size: 2677 bytes Desc: not available Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050422/bacbaa43/slonik_init.bin -------------- next part -------------- A non-text attachment was scrubbed... Name: slonik_start.sh Type: application/x-shellscript Size: 248 bytes Desc: not available Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050422/bacbaa43/slonik_start.bin -------------- next part -------------- A non-text attachment was scrubbed... Name: slonik_subscr.sh Type: application/x-shellscript Size: 843 bytes Desc: not available Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050422/bacbaa43/slonik_subscr.bin -------------- next part -------------- A non-text attachment was scrubbed... Name: slonik_start_sl.sh Type: application/x-shellscript Size: 246 bytes Desc: not available Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050422/bacbaa43/slonik_start_sl.bin
- Previous message: [Slony1-general] need node 1?
- Next message: [Slony1-general] No syncron
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list