Feczak Szabolcs feczo
Fri Apr 22 11:21:11 PDT 2005
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


More information about the Slony1-general mailing list