Christopher Browne cbbrowne
Wed Jun 15 19:30:08 PDT 2005
"Tang, Jason" <Jason.Tang at uk.telstra.com> writes:
>> > ..then it goes quiet. Tried doing an insert, but not a sausage
>> 
>> Hmm.  Maybe the logging isn't turned high enough :-).
>> 
>> Make sure the slon processes have "-d2", maybe?
>
> Umm.. sorry.. my bad. Too much caffeine and brain tired.
>
> Not that sure how to interpret this. Slave stuff I would have a guess is
> getting something back from master?
>
> Jase
>
> MASTER
> 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 42
> DEBUG2 localListenThread: Received event 1,42 SYNC
> DEBUG2 remoteWorkerThread_2: forward confirm 1,42 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

Exactly what I'd expect...

> SLAVE
> DEBUG2 remoteWorkerThread_1: syncing set 1 with 16 table(s) from
> provider 1
> DEBUG2 remoteHelperThread_1_1: 0.004 seconds delay for first row
> DEBUG2 remoteHelperThread_1_1: 0.005 seconds until close cursor
> DEBUG2 remoteWorkerThread_1: new sl_rowid_seq value: 1000000000067786
> DEBUG2 remoteWorkerThread_1: SYNC 41 done in 0.030 seconds
> 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,42 SYNC
> DEBUG2 remoteWorkerThread_1: Received event 1,42 SYNC
> DEBUG2 remoteWorkerThread_1: SYNC 42 processing
> DEBUG2 remoteWorkerThread_1: syncing set 1 with 16 table(s) from
> provider 1
> DEBUG2 remoteHelperThread_1_1: 0.004 seconds delay for first row
> DEBUG2 remoteHelperThread_1_1: 0.005 seconds until close cursor
> DEBUG2 remoteWorkerThread_1: new sl_rowid_seq value: 1000000000067786
> DEBUG2 remoteWorkerThread_1: SYNC 42 done in 0.029 seconds

Exactly what I'd expect if things are working properly...

If you make changes on node 1, I'd expect them to propagate to node 2
fairly promptly.

This looks like things look on a system that's working AOK...
-- 
"cbbrowne","@","ca.afilias.info"
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)


More information about the Slony1-general mailing list