Thu Sep 23 10:35:47 PDT 2010
- Previous message: [Slony1-general] Rapid-fire updates to table missed by slony
- Next message: [Slony1-general] Slony1-general Digest, Vol 43, Issue 18
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Rapid-fire updates to table missed by slony
- Next message: [Slony1-general] Slony1-general Digest, Vol 43, Issue 18
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list