[Bucardo-general] extremely large bucardo.bucardo_delta table

Martin Atukunda matlads at dsmagic.com
Mon Mar 7 12:48:14 UTC 2011


Hi Michelle,

I ended up rebuilding the replication system, and using onetimecopy. My
initial error was to include the bucardo schema in the original backup.

I've enabled the cron job and all looks good so far.

Thanks for your help.

- Martin -

On Fri, Mar 04, 2011 at 10:01:06AM +0100, Michelle Sullivan wrote:
> Martin Atukunda wrote:
> > I'm not using makedelta using swap, and there is a sync that is saying WAIT:17h
> 
> 
> I said makedelta not the delta sync (there is a difference - you can use 
> makedelta on a swap sync)
> 
> Run a kick on all syncs and restart your bucardo instance - just got 
> good measure - the logs will indicate if it couldn't update.
> 
> Michelle
> 
> >
> > - Martin -
> >
> > On 2011-03-04, at 11:32 AM, Michelle Sullivan wrote:
> >
> >> Martin Atukunda wrote:
> >>> Hi,
> >>>
> >>> I'm getting some unexpected output. bucardo_purge_delta returns 0 rows deleted, and yet the table definitely has data. Something is wrong.
> >>>
> >>> =>   SELECT bucardo.bucardo_purge_delta('10 minutes'::interval);
> >>>
> >>>                            bucardo_purge_delta
> >>> -----------------------------------------------------------------------
> >>>   Rows deleted from bucardo_delta: 0 Rows deleted from bucardo_track: 0
> >>> (1 row)
> >>>
> >>> =>    SELECT count(*) FROM bucardo.bucardo_delta\g
> >>>     count
> >>> -----------
> >>>   174166527
> >>> (1 row)
> >>>
> >>> =>   select max (txntime) FROM bucardo.bucardo_delta;
> >>>                max
> >>> -------------------------------
> >>>   2011-03-04 15:26:18.805188+07
> >>> (1 row)
> >>>
> >>> Time: 6.192 ms
> >>> =>   select min (txntime) FROM bucardo.bucardo_delta;
> >>>                min
> >>> -------------------------------
> >>>   2010-12-10 15:48:39.186257+07
> >>> (1 row)
> >>>
> >>
> >>
> >> Do you have a sync that is currently failed or not running?  Are you
> >> using makedelta?
> >>
> >> Michelle
> >> _______________________________________________
> >> Bucardo-general mailing list
> >> Bucardo-general at bucardo.org
> >> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
> >
> 
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general

-- 
- Martin -


More information about the Bucardo-general mailing list