[Bucardo-general] b5: delta_ rows not being deleted

Greg Sabino Mullane greg at endpoint.com
Fri Jun 28 15:40:52 UTC 2013


> ecommerce=# SELECT COUNT(DISTINCT target) FROM
> bucardo.bucardo_delta_targets WHERE tablename::regclass::text =
> 'saved_cart';
>  count
> -------
>      1

This simplifies things a lot. From here, you should be able to see 
why rows are not being removed from the delta table. They should be 
removed if there is a matching (by txntime) entry in the target table. 
Note that there must be exactly one - not zero, not two. :) So focus on 
a single row from the delta table and make sure it meets all the criteria 
for deletion.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130628/55669699/attachment.sig>


More information about the Bucardo-general mailing list