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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
