On Mon, Apr 28, 2014 at 01:47:53PM -0700, Paul Theodoropoulos wrote: > >>INFO: "bucardo_truncate_trigger": found 623880 removable, 181642
I'm still not sure exactly what is going on. The table only ever changes under two times - from a truncate trigger on the target table themselves, and inside Bucardo.pm when it is marking the truncation as "done". The only explanation I can think of is that the truncate sync is failing, and thus the update query runs over and over. I changed the SQL to hopefully avoid this: - 'UPDATE bucardo.bucardo_truncate_trigger SET replicated = now() WHERE sync = ?'; + 'UPDATE bucardo.bucardo_truncate_trigger SET replicated = now() WHERE sync = ? AND replicated IS NULL'; In 4d69b0352cc51d8750d6e7d27865852ac21579b3 -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
