[Bucardo-general] extremely large bucardo.bucardo_delta table

[Michelle Sullivan]

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
>