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 _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
