Some slony log info, anyone out there with slony experience ?
slony 10.1.1.2(35428) 2012-02-21 12:56:04 PST 0 LOG: duration: 502.162 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 12:56:44 PST 0 LOG: duration: 547.304 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 12:56:56 PST 0 LOG: duration: 595.473 ms
statement: fetch 500 from LOG;
slony
10.1.1.3(52676) 2012-02-21 12:57:27 PST 0 LOG: duration: 1249.432 ms
statement: select "_slony1".cleanupEvent('10 minutes'::interval,
'false'::boolean);
slony 10.1.1.2(35428) 2012-02-21 12:57:39 PST 0 LOG: duration: 521.751 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 12:58:05 PST 0 LOG: duration:
663.164 ms statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 12:58:33 PST 0 LOG: duration: 584.578 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 12:58:53 PST 0 LOG: duration: 524.076 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 12:59:22 PST 0 LOG: duration: 610.761 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 12:59:42 PST 0 LOG: duration: 629.949 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:00:10 PST 0 LOG: duration: 509.607 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:00:48 PST 0 LOG: duration: 519.203 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:01:00 PST 0 LOG: duration: 527.713 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:01:09 PST 0 LOG: duration:
616.263 ms statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:01:17 PST 0 LOG: duration: 520.641 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:02:13 PST 0 LOG: duration: 519.352 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:02:49 PST 0 LOG: duration: 505.472 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:03:52 PST 0 LOG: duration: 601.902 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:04:50 PST 0 LOG: duration: 643.636 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:06:03 PST 0 LOG: duration: 513.065 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:06:29 PST 0 LOG: duration: 648.466 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:07:08 PST 0 LOG: duration:
645.737 ms statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:07:56 PST 0 LOG: duration: 559.368 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:08:08 PST 0 LOG: duration: 524.154 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:08:20 PST 0 LOG: duration: 594.628 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:08:34 PST 0 LOG: duration: 515.906 ms
statement: fetch 500 from LOG;
slony 10.1.1.2(35428) 2012-02-21 13:08:48 PST 0 LOG: duration: 535.204 ms
statement: fetch 500 from LOG;
slony
10.1.1.3(52676) 2012-02-21 13:08:49 PST 0 LOG: duration: 582.382 ms
statement: select "_slony1".cleanupEvent('10 minutes'::interval,
'false'::boolean);
________________________________
From: Brian Trudal <[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, February 21, 2012 7:30 PM
Subject: [Slony1-general] Replication Lag - fetch 500 from LOG
All of a sudden since a day the lag is increasing and server is not getting
caught; and all I can see if "fetch 500 from LOG" from pg_stat_activity..
restarted slony across and also killed all sessions in "in transaction"; and
still no luck.
Anything that am missing ?
I really appreciate some's answer...
Its on PG 8.4 + slony 2.0.4
Thanks
Brian
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
