On 12-02-22 01:04 AM, Brian Trudal wrote:
> 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;

You might want to read up on slony bug #167.  If replication fall behind 
(for whatever reason) versions of slony prior to 2.1 can exhibit the 
behaviour your describing until they have caught up.



> 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 <dbrb2002-sql at yahoo.com>
> *To:* "slony1-general at lists.slony.info" <slony1-general at lists.slony.info>
> *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
> Slony1-general at lists.slony.info <mailto:Slony1-general at lists.slony.info>
> http://lists.slony.info/mailman/listinfo/slony1-general
>
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general