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

Greg Sabino Mullane greg at endpoint.com
Mon May 5 14:31:42 UTC 2014


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 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/20140505/8b122f0a/attachment.sig>


More information about the Bucardo-general mailing list