On 5/5/14, 7:31 AM, Greg Sabino Mullane wrote:
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
Thanks Greg. I'm going to install the latest momentarily.
--
Paul Theodoropoulos
www.anastrophe.com
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
