Geoffrey lists at serioustechnology.com
Thu Feb 21 05:01:48 PST 2008
Jan Wieck wrote:

> This is the slon log of node 1. Unless node 1 is the lagging subscriber 
> (which I actually don't expect), this isn't telling us much.
> 
> The question is if the slon for the subscriber is running and if that 
> ones log shows any errors.

I don't see anything that slaps me in the head here either.  Here's the 
tail end of the node 2 (slave) log:

2008-02-21 08:00:49 EST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 13125
2008-02-21 08:00:50 EST DEBUG2 localListenThread: Received event 2,13125 
SYNC
2008-02-21 08:00:58 EST DEBUG2 remoteListenThread_1: queue event 1,15647 
SYNC
2008-02-21 08:00:58 EST DEBUG2 remoteWorkerThread_1: Received event 
1,15647 SYNC2008-02-21 08:00:58 EST DEBUG2 remoteWorkerThread_1: SYNC 
15647 processing
2008-02-21 08:00:58 EST DEBUG2 remoteWorkerThread_1: syncing set 2 with 
75 table(s) from provider 1

2008-02-21 07:58:55 EST DEBUG2  ssy_action_list length: 0
2008-02-21 07:58:55 EST DEBUG2 remoteWorkerThread_1: syncing set 1 with 
20 table(s) from provider 1
2008-02-21 07:58:55 EST DEBUG2  ssy_action_list length: 0
2008-02-21 07:58:55 EST DEBUG2 remoteWorkerThread_1: current local 
log_status is 0
2008-02-21 07:58:55 EST DEBUG2 remoteWorkerThread_1_1: current remote 
log_status = 0
2008-02-21 07:58:55 EST DEBUG2 remoteHelperThread_1_1: 0.006 seconds 
delay for first row
2008-02-21 07:58:55 EST DEBUG2 remoteHelperThread_1_1: 0.007 seconds 
until close cursor
2008-02-21 07:58:55 EST DEBUG2 remoteHelperThread_1_1: inserts=0 
updates=0 deletes=0
2008-02-21 07:58:56 EST DEBUG2 remoteWorkerThread_1: new sl_rowid_seq 
value: 1000000000000000
2008-02-21 07:58:56 EST DEBUG2 remoteWorkerThread_1: SYNC 15632 done in 
0.099 seconds
2008-02-21 07:58:56 EST DEBUG2 remoteWorkerThread_1: forward confirm 
2,13113 received by 1
2008-02-21 07:58:59 EST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 13114
2008-02-21 07:59:00 EST DEBUG2 localListenThread: Received event 2,13114 
SYNC

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin


More information about the Slony1-general mailing list