Antonio Escudero aescudero
Wed Feb 8 16:32:58 PST 2006
Hi, got another question regarding slony.... thanks for your help..
I ran all the steps of slony replication

cluster name = slony;

1.  Initialize the cluster with the first node (INITIALIZE CLUSTER)
 init cluster ( id=1, comment = 'Master Node');
2.  Add more nodes to the cluster (STORE NODE)
 store node (id=2, comment = 'Slave node');

3.  Indicate communications paths between nodes (STORE PATH)
 store path (server = 1, client = 2, conninfo='dbname=database_name host=host_name_1 user=pgsql password=xxxxxx');
 store path (server = 2, client = 1, conninfo='dbname=database_name
  host=host_name_2 user=pgsql password=xxxxxx');

 store listen (origin=1, provider = 1, receiver =2);
 store listen (origin=2, provider = 2, receiver =1);

4.  Create a replication set (CREATE SET)
 create set (id=1, origin=1, comment='HBA Tables');

5.  Add tables to the set (SET ADD TABLE)
 set add table (set id=1, origin=1, id=1, fully qualified name = 'feature.convention_tbl');
 set add sequence (set id=1, origin=1, id=2, fully qualified name = 'feature.convention_seq');

 set add table (set id=1, origin=1, id=3, fully qualified name = 'feature.event_tbl');
 set add sequence (set id=1, origin=1, id=4, fully qualified name = 'feature.event_seq');

6.  Subscribe nodes to the provider (SUBSCRIBE SET)
 subscribe set ( id = 1, provider = 1, receiver = 2, forward = no);
7.  Watch replication happen

-----
1.  Based on the logs all seems to be perfect, I didn't get any errors. 
But 1 haven't seen any update on the slave database. It looks like that it is still
not populating the slave database tables with the data coming from the master database.

2.  What is the purpose of sched_wakeup_node()?

3.  Usually, How long will it take to update the slave database?

-------


When I tailed my slony log file and I got this:
CONFIG main: slon version 1.0.5 starting up
CONFIG main: local node id = 2
CONFIG main: loading current cluster configuration
CONFIG storeNode: no_id=1 no_comment='Master Node'
DEBUG2 setNodeLastEvent: no_id=1 event_seq=1
CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=database_name host=host_name_1 user=user_name password=passwd" pa_connretry=10
CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
DEBUG2 main: last local event sequence = 2
CONFIG main: configuration complete - starting threads
DEBUG1 localListenThread: thread starts
CONFIG enableNode: no_id=1
DEBUG1 main: running scheduler mainloop
DEBUG1 remoteListenThread_1: thread starts
DEBUG2 remoteListenThread_1: start listening for event origin 1
DEBUG1 remoteWorkerThread_1: thread starts
DEBUG1 cleanupThread: thread starts
DEBUG1 syncThread: thread starts
DEBUG1 remoteListenThread_1: connected to 'dbname=database_name host=host_name_1 user=user_name password=passwd'
DEBUG2 remoteListenThread_1: queue event 1,2 STORE_NODE
DEBUG2 remoteListenThread_1: queue event 1,3 ENABLE_NODE

DEBUG2 remoteWorkerThread_1: Received event 1,2 STORE_NODE
DEBUG2 remoteListenThread_1: queue event 1,4 STORE_PATH

DEBUG2 remoteListenThread_1: queue event 1,5 STORE_LISTEN
DEBUG2 remoteListenThread_1: queue event 1,6 STORE_SET

DEBUG2 remoteListenThread_1: queue event 1,7 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,8 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,9 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,10 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,11 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,12 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,13 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,14 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,15 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,16 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,17 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,18 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,19 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,20 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,21 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,22 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,23 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,24 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,25 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,26 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,27 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,28 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,29 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,30 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,31 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,32 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,33 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,34 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,35 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,36 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,37 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,38 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,39 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,40 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,41 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,42 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,43 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,44 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,45 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,46 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,47 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,48 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,49 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,50 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,51 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,52 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,53 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,54 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,55 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,56 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,57 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,58 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,59 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,60 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,61 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,62 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,63 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,64 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,65 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,66 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,67 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,68 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,69 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,70 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,71 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,72 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,73 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,74 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,75 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,76 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,77 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,78 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,79 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,80 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,81 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,82 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,83 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,84 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,85 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,86 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,87 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,88 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,89 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,90 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,91 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,92 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,93 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,94 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,95 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,96 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,97 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,98 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,99 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,100 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,101 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,102 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,103 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,104 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,105 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,106 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,107 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,108 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,109 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,110 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,111 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,112 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,113 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,114 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,115 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,116 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,117 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,118 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,119 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,120 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,121 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,122 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,123 SET_ADD_SEQUENCE
DEBUG2 remoteListenThread_1: queue event 1,124 SET_ADD_TABLE
DEBUG2 remoteListenThread_1: queue event 1,125 SET_ADD_TABLE

DEBUG2 remoteWorkerThread_1: Received event 1,3 ENABLE_NODE
DEBUG2 remoteWorkerThread_1: Received event 1,4 STORE_PATH
DEBUG2 remoteWorkerThread_1: Received event 1,5 STORE_LISTEN
DEBUG2 remoteWorkerThread_1: Received event 1,6 STORE_SET

CONFIG storeSet: set_id=1 set_origin=1 set_comment='HBA Tables'

DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled)
DEBUG2 remoteWorkerThread_1: Received event 1,7 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,8 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,9 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,10 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,11 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,12 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,13 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,14 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,15 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,16 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,17 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,18 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,19 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,20 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,21 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,22 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,23 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,24 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,25 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,26 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,27 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,28 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,29 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,30 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,31 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,32 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,33 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,34 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,35 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,36 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,37 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,38 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,39 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,40 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,41 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,42 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,43 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,44 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,45 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,46 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,47 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,48 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,49 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,50 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,51 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,52 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,53 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,54 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,55 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,56 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,57 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,58 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,59 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,60 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,61 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,62 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,63 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,64 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,65 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,66 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,67 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,68 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,69 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,70 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,71 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,72 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,73 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,74 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,75 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,76 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,77 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,78 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,79 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,80 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,81 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,82 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,83 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,84 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,85 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,86 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,87 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,88 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,89 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,90 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,91 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,92 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,93 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,94 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,95 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,96 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,97 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,98 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,99 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,100 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,101 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,102 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,103 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,104 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,105 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,106 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,107 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,108 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,109 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,110 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,111 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,112 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,113 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,114 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,115 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,116 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,117 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,118 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,119 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,120 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,121 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,122 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,123 SET_ADD_SEQUENCE
DEBUG2 remoteWorkerThread_1: Received event 1,124 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: Received event 1,125 SET_ADD_TABLE
DEBUG2 remoteWorkerThread_1: forward confirm 2,0 received by 1
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 3
DEBUG2 localListenThread: Received event 2,3 SYNC

DEBUG2 localListenThread: Received event 2,4 SUBSCRIBE_SET

CONFIG storeSubscribe: sub_set=1 sub_provider=1 sub_forward='f'

DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled)

Wed Feb  8 15:15:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 5
DEBUG2 localListenThread: Received event 2,5 SYNC
Wed Feb  8 15:16:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 6
DEBUG2 localListenThread: Received event 2,6 SYNC
Wed Feb  8 15:17:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 7
DEBUG2 localListenThread: Received event 2,7 SYNC
Wed Feb  8 15:18:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 8
DEBUG2 localListenThread: Received event 2,8 SYNC
Wed Feb  8 15:19:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 9
DEBUG2 localListenThread: Received event 2,9 SYNC
Wed Feb  8 15:20:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 10
DEBUG2 localListenThread: Received event 2,10 SYNC
Wed Feb  8 15:21:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 11
DEBUG2 localListenThread: Received event 2,11 SYNC
Wed Feb  8 15:22:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 12
DEBUG2 localListenThread: Received event 2,12 SYNC
Wed Feb  8 15:23:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 13
DEBUG2 localListenThread: Received event 2,13 SYNC
Wed Feb  8 15:24:01 PST 2006
DEBUG1 cleanupThread:    0.016 seconds for cleanupEvent()
DEBUG1 cleanupThread:    0.004 seconds for delete logs
DEBUG2 cleanupThread:    0.024 seconds for vacuuming
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 14
DEBUG2 localListenThread: Received event 2,14 SYNC
Wed Feb  8 15:25:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 15
DEBUG2 localListenThread: Received event 2,15 SYNC
Wed Feb  8 15:26:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 16
DEBUG2 localListenThread: Received event 2,16 SYNC
Wed Feb  8 15:27:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 17
DEBUG2 localListenThread: Received event 2,17 SYNC
Wed Feb  8 15:28:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 18
DEBUG2 localListenThread: Received event 2,18 SYNC
Wed Feb  8 15:29:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 19
DEBUG2 localListenThread: Received event 2,19 SYNC
Wed Feb  8 15:30:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 20
DEBUG2 localListenThread: Received event 2,20 SYNC
Wed Feb  8 15:31:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 21
DEBUG2 localListenThread: Received event 2,21 SYNC
Wed Feb  8 15:32:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 22
DEBUG2 localListenThread: Received event 2,22 SYNC
Wed Feb  8 15:33:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23
DEBUG2 localListenThread: Received event 2,23 SYNC
Wed Feb  8 15:34:01 PST 2006
DEBUG1 cleanupThread:    0.006 seconds for cleanupEvent()
DEBUG1 cleanupThread:    0.003 seconds for delete logs
DEBUG2 cleanupThread:    0.019 seconds for vacuuming
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 24
DEBUG2 localListenThread: Received event 2,24 SYNC
Wed Feb  8 15:35:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 25
DEBUG2 localListenThread: Received event 2,25 SYNC
Wed Feb  8 15:36:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 26
DEBUG2 localListenThread: Received event 2,26 SYNC
Wed Feb  8 15:37:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 27
DEBUG2 localListenThread: Received event 2,27 SYNC
Wed Feb  8 15:38:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 28
DEBUG2 localListenThread: Received event 2,28 SYNC
Wed Feb  8 15:39:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 29
DEBUG2 localListenThread: Received event 2,29 SYNC
Wed Feb  8 15:40:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 30
DEBUG2 localListenThread: Received event 2,30 SYNC
Wed Feb  8 15:41:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 31
DEBUG2 localListenThread: Received event 2,31 SYNC
Wed Feb  8 15:42:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 32
DEBUG2 localListenThread: Received event 2,32 SYNC
Wed Feb  8 15:43:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 33
DEBUG2 localListenThread: Received event 2,33 SYNC
Wed Feb  8 15:44:01 PST 2006
DEBUG1 cleanupThread:    0.002 seconds for cleanupEvent()
DEBUG1 cleanupThread:    0.003 seconds for delete logs
DEBUG2 cleanupThread:    0.029 seconds for vacuuming
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 34
DEBUG2 localListenThread: Received event 2,34 SYNC
Wed Feb  8 15:45:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 35
DEBUG2 localListenThread: Received event 2,35 SYNC




			
---------------------------------
 Yahoo! Mail - Helps protect you from nasty viruses.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060209/6632cfb2/attachment-0001.html



More information about the Slony1-general mailing list