[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slony1-general
Subject:    [Slony1-general] Waiting for Sync Forever...
From:       Christopher Browne <cbbrowne () ca ! afilias ! info>
Date:       2004-11-19 17:32:27
Message-ID: 60is81g2xg.fsf () dba2 ! int ! libertyrms ! com
[Download RAW message or body]

I have a test I am trying to set up that involves having a fair number
of cascaded slaves, and am running into the following problem...

The provider (node 2) has decided that the subscriber (node 3) needs
to wait for sync 18 to start up the subscription.

2004-11-19 12:19:48 EST WARN   remoteWorkerThread_1: copy set: data provider 2 only \
on sync 18 - sleep 5 seconds

We then proceed to sync #19, 20, 21, and so forth, and the above
message keeps coming up.

It looks as though prov_seqno (in remote_worker.c) isn't being
updated.  I have added in output of event->ev_seqno, giving the following:

2004-11-19 12:31:15 EST DEBUG2 localListenThread: Received event 3,7 SUBSCRIBE_SET
2004-11-19 12:31:15 EST CONFIG storeSubscribe: sub_set=1 sub_provider=2 \
sub_forward='t' 2004-11-19 12:31:15 EST DEBUG2 sched_wakeup_node(): no_id=2 (0 \
threads + worker signaled) 2004-11-19 12:31:16 EST DEBUG2 remoteListenThread_1: queue \
event 1,33 SYNC 2004-11-19 12:31:16 EST DEBUG2 remoteListenThread_1: queue event 1,34 \
ENABLE_SUBSCRIPTION 2004-11-19 12:31:16 EST DEBUG2 remoteWorkerThread_1: Received \
event 1,33 SYNC 2004-11-19 12:31:16 EST DEBUG2 remoteWorkerThread_1: SYNC 33 \
processing 2004-11-19 12:31:16 EST DEBUG2 remoteWorkerThread_1: no sets need syncing \
for this event 2004-11-19 12:31:16 EST DEBUG2 remoteWorkerThread_1: Received event \
1,34 ENABLE_SUBSCRIPTION 2004-11-19 12:31:16 EST WARN   remoteWorkerThread_1: copy \
set: data provider 2 only on sync 20 - sleep 5 seconds for sync 34 2004-11-19 \
12:31:18 EST DEBUG2 remoteListenThread_1: queue event 1,35 SYNC 2004-11-19 12:31:20 \
EST DEBUG2 remoteListenThread_1: queue event 1,36 SYNC 2004-11-19 12:31:21 EST WARN   \
remoteWorkerThread_1: copy set: data provider 2 only on sync 20 - sleep 5 seconds for \
sync 34 2004-11-19 12:31:22 EST DEBUG2 remoteListenThread_1: queue event 1,37 SYNC
2004-11-19 12:31:23 EST DEBUG2 remoteListenThread_1: queue event 1,38 STORE_NODE
2004-11-19 12:31:23 EST DEBUG2 remoteListenThread_1: queue event 1,39 ENABLE_NODE
2004-11-19 12:31:24 EST DEBUG2 syncThread: new sl_action_seq 1 - SYNC 9
2004-11-19 12:31:24 EST DEBUG2 remoteListenThread_1: queue event 1,40 SYNC
2004-11-19 12:31:24 EST DEBUG2 localListenThread: Received event 3,8 STORE_PATH
2004-11-19 12:31:24 EST WARN   storePath: unknown node ID 4 - event pending
2004-11-19 12:31:24 EST CONFIG storeNode: no_id=4 no_comment='<event pending>'
2004-11-19 12:31:24 EST CONFIG storePath: pa_server=4 pa_client=3 \
pa_conninfo="dbname=slony_test4" pa_connretry=10 2004-11-19 12:31:24 EST DEBUG2 \
localListenThread: Received event 3,9 SYNC 2004-11-19 12:31:26 EST WARN   \
remoteWorkerThread_1: copy set: data provider 2 only on sync 20 - sleep 5 seconds for \
sync 34 2004-11-19 12:31:26 EST DEBUG2 remoteListenThread_1: queue event 1,41 SYNC
2004-11-19 12:31:28 EST DEBUG2 remoteListenThread_1: queue event 1,42 SYNC
2004-11-19 12:31:30 EST DEBUG2 remoteListenThread_1: queue event 1,43 STORE_NODE
2004-11-19 12:31:30 EST DEBUG2 remoteListenThread_1: queue event 1,44 ENABLE_NODE
2004-11-19 12:31:30 EST DEBUG2 remoteListenThread_1: queue event 1,45 SYNC
2004-11-19 12:31:31 EST WARN   remoteWorkerThread_1: copy set: data provider 2 only \
on sync 20 - sleep 5 seconds for sync 34 2004-11-19 12:31:33 EST DEBUG2 \
                remoteListenThread_1: queue event 1,46 SYNC
-- 
"cbbrowne","@","ca.afilias.info"
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)


[prev in list] [next in list] [prev in thread] [next in thread]