dario dmenichelli at coresecurity.com
Thu Sep 23 10:35:47 PDT 2010
Hi all,

Slony is working well but when i tail the log, the same entries shows up every second:


2010-09-23 14:34:59 ART DEBUG2 syncThread: new sl_action_seq 1 - SYNC 4501018
2010-09-23 14:35:00 ART DEBUG2 localListenThread: Received event 2,4501018 SYNC
2010-09-23 14:35:00 ART DEBUG2 remoteListenThread_1: queue event 1,8268464 SYNC
2010-09-23 14:35:00 ART DEBUG2 remoteWorkerThread_1: Received event 1,8268464 SYNC
2010-09-23 14:35:00 ART DEBUG3 calc sync size - last time: 1 last length: 10104 ideal: 5 proposed size: 3
2010-09-23 14:35:00 ART DEBUG2 remoteWorkerThread_1: SYNC 8268464 processing
2010-09-23 14:35:00 ART DEBUG2 remoteWorkerThread_1: syncing set 1 with 60 table(s) from provider 1
2010-09-23 14:35:00 ART DEBUG4  ssy_action_list value:
2010-09-23 14:35:00 ART DEBUG2  ssy_action_list length: 0
2010-09-23 14:35:00 ART DEBUG2 remoteWorkerThread_1: current local log_status is 2
2010-09-23 14:35:00 ART DEBUG3 remoteWorkerThread_1: activate helper 1
2010-09-23 14:35:00 ART DEBUG4 remoteWorkerThread_1: waiting for log data
2010-09-23 14:35:00 ART DEBUG4 remoteHelperThread_1_1: got work to do
2010-09-23 14:35:00 ART DEBUG2 remoteWorkerThread_1_1: current remote log_status = 3
2010-09-23 14:35:00 ART DEBUG4 remoteHelperThread_1_1: allocate line buffers
2010-09-23 14:35:00 ART DEBUG4 remoteHelperThread_1_1: fetch from cursor
2010-09-23 14:35:04 ART DEBUG2 remoteHelperThread_1_1: 3.736 seconds delay for first row
2010-09-23 14:35:04 ART DEBUG4 remoteHelperThread_1_1: fetched 0 log rows
2010-09-23 14:35:04 ART DEBUG4 remoteHelperThread_1_1: return 10 unused line buffers
2010-09-23 14:35:04 ART DEBUG2 remoteHelperThread_1_1: 3.737 seconds until close cursor
2010-09-23 14:35:04 ART DEBUG2 remoteHelperThread_1_1: inserts=0 updates=0 deletes=0
2010-09-23 14:35:04 ART DEBUG4 remoteHelperThread_1_1: change helper thread status
2010-09-23 14:35:04 ART DEBUG4 remoteHelperThread_1_1: send DONE/ERROR line to worker
2010-09-23 14:35:04 ART DEBUG3 remoteWorkerThread_1: helper 1 finished
2010-09-23 14:35:04 ART DEBUG4 remoteWorkerThread_1: returning lines to pool
2010-09-23 14:35:04 ART DEBUG3 remoteWorkerThread_1: all helpers done.
2010-09-23 14:35:04 ART DEBUG4 remoteWorkerThread_1: changing helper 1 to IDLE
2010-09-23 14:35:04 ART DEBUG4 remoteWorkerThread_1: cleanup
2010-09-23 14:35:04 ART DEBUG4 remoteHelperThread_1_1: waiting for work
2010-09-23 14:35:04 ART DEBUG2 remoteWorkerThread_1: new sl_rowid_seq value: 1000000000000000
2010-09-23 14:35:04 ART DEBUG2 remoteWorkerThread_1: SYNC 8268464 done in 3.787 seconds
2010-09-23 14:35:04 ART DEBUG2 remoteWorkerThread_1: forward confirm 2,4501018 received by 1


Are they ok?? i have started to doubt becuase the process that handles the connection between the servers (primary and secondary) is using 30/40% of the
main cpu.(it was always around 10% of cpu use)

Thanks in advance,
dario


More information about the Slony1-general mailing list