Michel.Diotte at hydro.com Michel.Diotte
Thu Mar 10 19:07:05 PST 2005
The vacuum has been done. But to make sure i did it again and the slave is
still several minutes behind ...
This is the log file of the slave if it can help ...

DEBUG4 remoteHelperThread_1_1: waiting for work
DEBUG2 remoteWorkerThread_1: new sl_rowid_seq value: 1000000000000000
DEBUG2 remoteWorkerThread_1: SYNC 248119 done in 0.138 seconds
DEBUG2 remoteListenThread_1: queue event 1,248120 SYNC
DEBUG2 remoteListenThread_1: queue event 1,248121 SYNC
DEBUG1 cleanupThread:    0.160 seconds for cleanupEvent()
DEBUG1 cleanupThread:    0.262 seconds for delete logs
DEBUG2 remoteListenThread_1: queue event 1,248122 SYNC
DEBUG2 localListenThread: Received event 2,219454 SYNC
DEBUG2 remoteWorkerThread_1: Received event 1,248120 SYNC
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 219455
DEBUG2 remoteWorkerThread_1: SYNC 248120 processing
DEBUG2 remoteWorkerThread_1: syncing set 1 with 17 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.015 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.025 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 248120 done in 0.065 seconds
DEBUG2 remoteListenThread_1: queue event 1,248123 SYNC
DEBUG2 remoteListenThread_1: queue event 1,248124 SYNC
DEBUG2 remoteListenThread_1: queue event 1,248125 SYNC
DEBUG2 remoteListenThread_1: queue event 1,248126 SYNC
DEBUG2 cleanupThread:  197.375 seconds for vacuuming
DEBUG2 remoteListenThread_1: queue event 1,248127 SYNC
DEBUG2 localListenThread: Received event 2,219455 SYNC
DEBUG2 remoteWorkerThread_1: forward confirm 2,219455 received by 1
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 219456
DEBUG2 remoteListenThread_1: queue event 1,248128 SYNC
DEBUG2 remoteListenThread_1: queue event 1,248129 SYNC
DEBUG2 remoteListenThread_1: queue event 1,248130 SYNC
DEBUG2 remoteWorkerThread_1: Received event 1,248121 SYNC
DEBUG2 remoteWorkerThread_1: SYNC 248129 processing
DEBUG2 remoteWorkerThread_1: syncing set 1 with 17 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.122 seconds delay for first row
DEBUG3 remoteHelperThread_1_1: got 57 log rows
DEBUG3 remoteHelperThread_1_1: 6 log buffers deliverd
DEBUG4 remoteHelperThread_1_1: no more log rows
DEBUG2 remoteHelperThread_1_1: 0.140 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
DEBUG4 remoteWorkerThread_1: returning lines to pool
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 248129 done in 0.298 seconds
DEBUG2 remoteListenThread_1: queue event 1,248131 SYNC
DEBUG2 localListenThread: Received event 2,219456 SYNC
DEBUG2 remoteWorkerThread_1: Received event 1,248130 SYNC
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 219457
DEBUG2 remoteWorkerThread_1: SYNC 248131 processing
DEBUG2 remoteWorkerThread_1: syncing set 1 with 17 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.040 seconds delay for first row
DEBUG3 remoteHelperThread_1_1: got 1 log rows
DEBUG3 remoteHelperThread_1_1: 1 log buffers deliverd
DEBUG4 remoteHelperThread_1_1: no more log rows
DEBUG4 remoteWorkerThread_1: returning lines to pool
DEBUG4 remoteWorkerThread_1: waiting for log data
DEBUG2 remoteHelperThread_1_1: 0.057 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 248131 done in 0.087 seconds
DEBUG2 remoteListenThread_1: queue event 1,248132 SYNC



-------------- next part --------------


***********************************************************************
NOTICE: This e-mail transmission, and any documents, files or previous
e-mail messages attached to it, may contain confidential or privileged
information. If you are not the intended recipient, or a person
responsible for delivering it to the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of
any of the information contained in or attached to this message is
STRICTLY PROHIBITED. If you have received this transmission in error,
please immediately notify the sender and delete the e-mail and attached
documents. Thank you.
***********************************************************************



More information about the Slony1-general mailing list