Thu Mar 11 13:14:45 PST 2010
- Previous message: [Slony1-general] Slony1 2.0.2 slaves and syncs
- Next message: [Slony1-general] Upgrading Pg
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
This is what I'm seeing in the slave log over and over with log level 4: 2010-03-11 13:09:30 PST DEBUG2 remoteWorkerThread_1: current local log_status is 1 2010-03-11 13:09:30 PST DEBUG3 remoteWorkerThread_1: activate helper 1 2010-03-11 13:09:30 PST DEBUG4 remoteHelperThread_1_1: got work to do 2010-03-11 13:09:30 PST DEBUG4 remoteWorkerThread_1: waiting for log data 2010-03-11 13:09:30 PST DEBUG2 remoteWorkerThread_1_1: current remote log_status = 0 2010-03-11 13:09:30 PST DEBUG4 remoteHelperThread_1_1: allocate line buffers 2010-03-11 13:09:30 PST DEBUG4 remoteHelperThread_1_1: fetch from cursor 2010-03-11 13:09:30 PST DEBUG1 remoteHelperThread_1_1: 0.001 seconds delay for first row 2010-03-11 13:09:30 PST DEBUG4 remoteHelperThread_1_1: fetched 0 log rows 2010-03-11 13:09:30 PST DEBUG4 remoteHelperThread_1_1: return 50 unused line buffers 2010-03-11 13:09:30 PST DEBUG1 remoteHelperThread_1_1: 0.001 seconds until close cursor 2010-03-11 13:09:30 PST INFO remoteHelperThread_1_1: inserts=0 updates=0 deletes=0 2010-03-11 13:09:30 PST INFO remoteWorkerThread_1: sync_helper timing: pqexec (s/count)- provider 0.001/3 - subscriber 0.000/3 2010-03-11 13:09:30 PST INFO remoteWorkerThread_1: sync_helper timing: large tuples 0.000/0 2010-03-11 13:09:30 PST DEBUG4 remoteHelperThread_1_1: change helper thread status 2010-03-11 13:09:30 PST DEBUG4 remoteHelperThread_1_1: send DONE/ERROR line to worker 2010-03-11 13:09:30 PST DEBUG3 remoteHelperThread_1_1: waiting for workgroup to finish 2010-03-11 13:09:30 PST DEBUG3 remoteWorkerThread_1: helper 1 finished 2010-03-11 13:09:30 PST DEBUG4 remoteWorkerThread_1: returning lines to pool 2010-03-11 13:09:30 PST DEBUG3 remoteWorkerThread_1: all helpers done. 2010-03-11 13:09:30 PST DEBUG4 remoteWorkerThread_1: changing helper 1 to IDLE 2010-03-11 13:09:30 PST DEBUG2 remoteWorkerThread_1: cleanup 2010-03-11 13:09:30 PST DEBUG4 remoteHelperThread_1_1: waiting for work 2010-03-11 13:09:30 PST INFO remoteWorkerThread_1: SYNC 39545 done in 0.003 seconds 2010-03-11 13:09:30 PST INFO remoteWorkerThread_1: SYNC 39545 sync_event timing: pqexec (s/count)- provider 0.000/1 - subscriber 0.001/1 - IUD 0.000/0 2010-03-11 13:09:32 PST DEBUG2 remoteListenThread_1: queue event 1,39546 SYNC 2010-03-11 13:09:32 PST DEBUG2 remoteWorkerThread_1: Received event #1 from 39546 type:SYNC 2010-03-11 13:09:32 PST DEBUG1 calc sync size - last time: 1 last length: 2000 ideal: 30 proposed size: 3 2010-03-11 13:09:32 PST DEBUG2 remoteWorkerThread_1: SYNC 39546 processing 2010-03-11 13:09:32 PST INFO about to monitor_subscriber_query - pulling big actionid list 131278976 2010-03-11 13:09:32 PST INFO remoteWorkerThread_1: syncing set 5 with 1 table(s) from provider 1 2010-03-11 13:09:32 PST DEBUG4 ssy_action_list value: 2010-03-11 13:09:32 PST DEBUG2 ssy_action_list length: 0 -----Original Message----- From: slony1-general-bounces at lists.slony.info [mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Vick Khera Sent: Thursday, March 11, 2010 11:15 AM To: slony1-general at lists.slony.info Subject: Re: [Slony1-general] Slony1 2.0.2 slaves and syncs On Thu, Mar 11, 2010 at 12:46 PM, <michael at aers.ca> wrote: > It will send one when the slon process on the slave is first activated but > not past that. what does the log for that node's slon daemon say? crank up the debug level and see if you learn anything. my guess is it is exiting. _______________________________________________ Slony1-general mailing list Slony1-general at lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
- Previous message: [Slony1-general] Slony1 2.0.2 slaves and syncs
- Next message: [Slony1-general] Upgrading Pg
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list