[Bucardo-general] child_q_ relations linger & entries in q table with no updates/inserts/deletes

Greg Sabino Mullane greg at endpoint.com
Tue Jan 11 03:15:41 UTC 2011

The q stuff gets moved by the bucardo_purge_q function to 
the master_q table, which then gets sent to child 
tables in the freezer schema. If you don't care about 
this old data (and many do not), you can simply drop 
all the child_q_* tables.

> ... un-purged q table entries.  They have NULL values for 
> 'started' or 'aborted', so the bucardo_purge_q_table 
> function doesn't see them, but they also don't have 
> any 'updates', 'deletes', or 'inserts', which seems odd.

Odd, that would seem to indicate a controller starting 
a q entry and a kid never picking it up. It should be 
safe to nuke older ones, and automate that, by using 
the cdate column.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110110/4f55be61/attachment.bin 

More information about the Bucardo-general mailing list