Wed Feb 8 16:32:58 PST 2006
- Previous message: [Slony1-general] Slony Question
- Next message: [Slony1-general] Usage example for store trigger
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony Question
- Next message: [Slony1-general] Usage example for store trigger
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list