michael at aers.ca michael at aers.ca
Thu Mar 11 13:14:45 PST 2010
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


More information about the Slony1-general mailing list