[Bucardo-general] indirect bucardo problem - stuck triggers?

[Paul Theodoropoulos]

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