Dear, In the node master the log file have these lines: 2007-03-01 14:21:39 BRT DEBUG2 remoteWorkerThread_2: SYNC 22997 processing 2007-03-01 14:21:39 BRT DEBUG2 remoteWorkerThread_2: no sets need syncing for this event 2007-03-01 14:21:48 BRT DEBUG2 localListenThread: Received event 1,24354 SYNC 2007-03-01 14:21:49 BRT DEBUG2 syncThread: new sl_action_seq 10354 - SYNC 24355 2007-03-01 14:21:49 BRT DEBUG2 remoteListenThread_2: queue event 2,22998 SYNC 2007-03-01 14:21:49 BRT DEBUG2 remoteWorkerThread_2: Received event 2,22998 SYNC 2007-03-01 14:21:49 BRT DEBUG3 calc sync size - last time: 1 last length: 10406 ideal: 5 proposed size: 3 2007-03-01 14:21:49 BRT DEBUG2 remoteWorkerThread_2: SYNC 22998 processing 2007-03-01 14:21:49 BRT DEBUG2 remoteWorkerThread_2: no sets need syncing for this event 2007-03-01 14:21:50 BRT DEBUG2 localListenThread: Received event 1,24355 SYNC 2007-03-01 14:21:58 BRT DEBUG2 remoteListenThread_2: queue event 2,22999 SYNC 2007-03-01 14:21:58 BRT DEBUG2 remoteWorkerThread_2: Received event 2,22999 SYNC 2007-03-01 14:21:58 BRT DEBUG3 calc sync size - last time: 1 last length: 9094 ideal: 6 proposed size: 3 2007-03-01 14:21:58 BRT DEBUG2 remoteWorkerThread_2: SYNC 22999 processing 2007-03-01 14:21:58 BRT DEBUG2 remoteWorkerThread_2: no sets need syncing for this event 2007-03-01 14:21:59 BRT DEBUG2 syncThread: new sl_action_seq 10354 - SYNC 24356 2007-03-01 14:22:05 BRT DEBUG2 syncThread: new sl_action_seq 10356 - SYNC 24357 2007-03-01 14:22:07 BRT DEBUG2 remoteListenThread_2: LISTEN 2007-03-01 14:22:08 BRT DEBUG2 remoteListenThread_2: queue event 2,23000 SYNC 2007-03-01 14:22:08 BRT DEBUG2 remoteListenThread_2: UNLISTEN 2007-03-01 14:22:08 BRT DEBUG2 localListenThread: Received event 1,24356 SYNC 2007-03-01 14:22:08 BRT DEBUG2 localListenThread: Received event 1,24357 SYNC 2007-03-01 14:22:08 BRT DEBUG2 remoteWorkerThread_2: Received event 2,23000 SYNC 2007-03-01 14:22:08 BRT DEBUG3 calc sync size - last time: 1 last length: 9698 ideal: 6 proposed size: 3 2007-03-01 14:22:08 BRT DEBUG2 remoteWorkerThread_2: SYNC 23000 processing 2007-03-01 14:22:08 BRT DEBUG2 remoteWorkerThread_2: no sets need syncing for this event 2007-03-01 14:22:15 BRT DEBUG2 syncThread: new sl_action_seq 10356 - SYNC 24358 2007-03-01 14:22:16 BRT DEBUG2 localListenThread: Received event 1,24358 SYNC
---------------- In the node slave the log file have these lines: 2007-03-01 14:24:24 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23022 2007-03-01 14:24:33 BRT DEBUG2 localListenThread: Received event 2,23022 SYNC 2007-03-01 14:24:34 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23023 2007-03-01 14:24:35 BRT DEBUG2 localListenThread: Received event 2,23023 SYNC 2007-03-01 14:24:44 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23024 2007-03-01 14:24:53 BRT DEBUG2 localListenThread: Received event 2,23024 SYNC 2007-03-01 14:24:54 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23025 2007-03-01 14:24:55 BRT DEBUG2 localListenThread: Received event 2,23025 SYNC 2007-03-01 14:25:00 BRT ERROR remoteListenThread_1: timeout for event selection 2007-03-01 14:25:00 BRT DEBUG1 remoteListenThread_1: thread done 2007-03-01 14:25:00 BRT DEBUG1 syncThread: thread done 2007-03-01 14:25:00 BRT DEBUG1 localListenThread: thread done 2007-03-01 14:25:00 BRT DEBUG1 cleanupThread: thread done 2007-03-01 14:25:00 BRT DEBUG1 main: scheduler mainloop returned 2007-03-01 14:25:00 BRT DEBUG2 main: wait for remote threads 2007-03-01 14:25:00 BRT DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled) 2007-03-01 14:25:00 BRT DEBUG4 remoteWorkerThread_1: update provider configuration 2007-03-01 14:25:00 BRT DEBUG1 remoteWorkerThread_1: thread done 2007-03-01 14:25:00 BRT DEBUG1 main: done 2007-03-01 14:25:00 BRT DEBUG2 slon: child terminated status: 0; pid: 91012, current worker pid: 91012 2007-03-01 14:25:00 BRT DEBUG1 slon: restart of worker 2007-03-01 14:25:00 BRT CONFIG main: slon version 1.2.6 starting up 2007-03-01 14:25:00 BRT DEBUG2 slon: watchdog process started 2007-03-01 14:25:00 BRT DEBUG2 slon: watchdog ready - pid = 90970 2007-03-01 14:25:00 BRT DEBUG2 slon: worker process created - pid = 91111 2007-03-01 14:25:00 BRT CONFIG main: local node id = 2 2007-03-01 14:25:00 BRT DEBUG2 main: main process started 2007-03-01 14:25:00 BRT CONFIG main: launching sched_start_mainloop 2007-03-01 14:25:00 BRT CONFIG main: loading current cluster configuration 2007-03-01 14:25:00 BRT CONFIG storeNode: no_id=1 no_comment='Nodo Master' 2007-03-01 14:25:00 BRT DEBUG2 setNodeLastEvent: no_id=1 event_seq=61 2007-03-01 14:25:00 BRT CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=ciclista host=200.xxx.xx.xxx user=xxxxxx password=xxxx" pa_connretry=10 2007-03-01 14:25:00 BRT CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1 2007-03-01 14:25:00 BRT CONFIG storeSet: set_id=1 set_origin=1 set_comment='Replicando tabela Cliente' 2007-03-01 14:25:00 BRT WARN remoteWorker_wakeup: node 1 - no worker thread 2007-03-01 14:25:00 BRT DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled) 2007-03-01 14:25:00 BRT CONFIG storeSubscribe: sub_set=1 sub_provider=1 sub_forward='f' 2007-03-01 14:25:00 BRT WARN remoteWorker_wakeup: node 1 - no worker thread 2007-03-01 14:25:00 BRT DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled) 2007-03-01 14:25:00 BRT DEBUG2 main: last local event sequence = 23025 2007-03-01 14:25:00 BRT CONFIG main: configuration complete - starting threads 2007-03-01 14:25:00 BRT DEBUG1 localListenThread: thread starts 2007-03-01 14:25:00 BRT DEBUG4 version for "dbname=ciclista user=xxxxxx password=xxxxxxxx host=200.xxx.xx.xxx" is 80003 2007-03-01 14:25:00 BRT CONFIG enableNode: no_id=1 2007-03-01 14:25:00 BRT DEBUG1 main: running scheduler mainloop 2007-03-01 14:25:00 BRT DEBUG1 remoteWorkerThread_1: thread starts 2007-03-01 14:25:00 BRT DEBUG1 remoteListenThread_1: thread starts 2007-03-01 14:25:00 BRT DEBUG2 remoteListenThread_1: start listening for event origin 1 2007-03-01 14:25:00 BRT DEBUG1 cleanupThread: thread starts 2007-03-01 14:25:00 BRT DEBUG4 cleanupThread: bias = 16807 2007-03-01 14:25:00 BRT DEBUG1 syncThread: thread starts 2007-03-01 14:25:01 BRT DEBUG4 version for "dbname=ciclista user=xxxxxxx password=xxxxxxx host=200.xxx.xx.xxx" is 80003 2007-03-01 14:25:01 BRT DEBUG4 version for "dbname=ciclista user=xxxxxxxx password=xxxxxxx host=200.xxx.xx.xxx" is 80003 2007-03-01 14:25:01 BRT DEBUG4 version for "dbname=ciclista user=xxxxxxxxx password=xxxxxx host=200.xxx.xx.xxx" is 80003 2007-03-01 14:25:01 BRT DEBUG4 remoteWorkerThread_1: update provider configuration 2007-03-01 14:25:03 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23026 2007-03-01 14:25:09 BRT DEBUG2 localListenThread: Received event 2,23026 SYNC 2007-03-01 14:25:13 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23027 2007-03-01 14:25:17 BRT DEBUG2 localListenThread: Received event 2,23027 SYNC 2007-03-01 14:25:23 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23028 2007-03-01 14:25:25 BRT DEBUG2 localListenThread: Received event 2,23028 SYNC 2007-03-01 14:25:33 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23029 2007-03-01 14:25:40 BRT DEBUG4 version for "dbname=ciclista host=200.xxx.xx.xxx user=xxxxxxxx password=xxxxxxx" is 80003 2007-03-01 14:25:40 BRT DEBUG1 remoteListenThread_1: connected to 'dbname=ciclista host=200.xxx.xxx.xxx user=xxxxxxxx password=xxxxxxx' 2007-03-01 14:25:43 BRT DEBUG2 localListenThread: Received event 2,23029 SYNC 2007-03-01 14:25:43 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23030 2007-03-01 14:25:45 BRT DEBUG2 localListenThread: Received event 2,23030 SYNC 2007-03-01 14:25:53 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23031 2007-03-01 14:26:03 BRT DEBUG2 localListenThread: Received event 2,23031 SYNC 2007-03-01 14:26:03 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23032 2007-03-01 14:26:05 BRT DEBUG2 localListenThread: Received event 2,23032 SYNC 2007-03-01 14:26:13 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23033 2007-03-01 14:26:23 BRT DEBUG2 localListenThread: Received event 2,23033 SYNC 2007-03-01 14:26:23 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 23034 2007-03-01 14:26:25 BRT DEBUG2 localListenThread: Received event 2,23034 SYNC in the master node (Ip 200.x.x.1) have these process: 72656 ?? S 1:00.46 /usr/local/bin/slon ciln dbname=ciclista user=xxx password=xxx host=200.x.x.1 71574 p1- I 0:00.01 /usr/local/bin/slon ciln dbname=ciclista user=xxx password=xxx host=200.x.x.1 in the slave node (Ip 200.x.x.2) have these process: 90970 p0 I 0:00.06 /usr/local/bin/slon ciln dbname=ciclista user=xxx password=xxx host=200.x.x.2 91123 p0 S 0:00.10 /usr/local/bin/slon ciln dbname=ciclista user=xxx password=xxx host=200.x.x.2 what to make ? Thanks to Advance, Marco Aurélio V. da Silva Prodata Inf. e Cad. Ltda. [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] ----- Original Message ----- From: "Christopher Browne" <[EMAIL PROTECTED]> To: "Marco Aurelio V. da Silva" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Thursday, March 01, 2007 1:10 PM Subject: Re: [Slony1-general] Doubt´s about stop sync > Marco Aurelio V. da Silva wrote: >> Dears, >> >> After stop the comunication between master and slave for hours, the >> replication stop and log file have many lines with: >> >> 2007-03-01 08:45:39 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC >> 21205 >> 2007-03-01 08:45:39 BRT DEBUG2 localListenThread: Received event 2,21205 >> SYNC >> 2007-03-01 08:45:49 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC >> 21206 >> 2007-03-01 08:45:57 BRT DEBUG2 localListenThread: Received event 2,21206 >> SYNC >> 2007-03-01 08:45:59 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC >> 21207 >> 2007-03-01 08:46:05 BRT DEBUG2 localListenThread: Received event 2,21207 >> SYNC >> 2007-03-01 08:46:09 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC >> 21208 >> 2007-03-01 08:46:13 BRT DEBUG2 localListenThread: Received event 2,21208 >> SYNC >> 2007-03-01 08:46:19 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC >> 21209 >> 2007-03-01 08:46:21 BRT DEBUG2 localListenThread: Received event 2,21209 >> SYNC >> 2007-03-01 08:46:29 BRT DEBUG2 syncThread: new sl_action_seq 1 - SYNC >> 21210 >> 2007-03-01 08:46:29 BRT DEBUG2 localListenThread: Received event 2,21210 >> SYNC >> >> have solution for prevent this ? >> >> i don´t use pgpool, or perltools, i use the basic script for replication. >> i don´t use failover or switchover, these options are recommended in this >> cases ? >> >> > > Well, the fact that you don't have two log files suggests to me that one > of the slon processes wasn't running. > > If *that* is the case, then replication will have a tough time > proceeding, because both slon processes need to run in order to get > replication to work. > > - There needs to be a slon running against the node(s) originating > replication sets, otherwise nothing marks SYNC events on that node, and > subscriber nodes won't know what data to pull from the origin. > > - There needs to be a slon running against each subscriber, as that is > the only way that changes will be pulled and applied. > > It seems to me that one of your slon processes fell over, and > replication will naturally stop at that point. _______________________________________________________ Yahoo! Mail - Sempre a melhor opção para você! Experimente já e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/ _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
