David Rees wrote:
> On Wed, Feb 20, 2008 at 11:55 AM, Geoffrey <lists at serioustechnology.com> wrote:
>>  I simply don't understand how one table inparticular could get so far
>>  out of sync.  We're talking 300 records.
> 
> Have you checked that replication is up to date (look at the sl_status
> view on the master)?

I'm assuming I should be looking at st_last_event and st_last_received? 
  They are within one on both machines. (9303, 9302 and 7278, 7277).

This would indicate they are keeping up pretty well.  Still, one table 
is out of sync by over 300 records.

> What do the slon logs say? Post them up using pastbin or something for review.

They are huge, so I'm not sure what I should be looking for.  I don't 
see any warnings or errors, only CONFIG, DEBUG1, DEBUG2 references.

>>  Is it possible I should be tweaking the configuration in some way?  I
>>  see a default value for SYNC_CHECK_INTERNAL.  Is 1000 a good value?
> 
> The default values are usually fine. 1000 is fine for sync check
> interval, though a bit overkill for most scenarios, the default of
> 2000 is usually OK.
> 
> -Dave
> 


-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin