Still having this trigger-war problem. Seems it started when we had a database corruption on one slave server. We reinstalled but upgraded to postgresql 9.3.4 whereas the master uses 9.2.6
Could that be the source of this? Also, when reinstalling bucardo, the first sync built is a pushdelta. It complains that the destination schema "bucardo" doesn't exist yet (it doesn't although it should have been built by the add sync command). Only when we create the 2nd sync (swap synch) does the destination's bucardo schema and functions/triggers get created. This has never happened before. Could we have a perl incompatibility or something else odd going on? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, July 28, 2014 8:00 AM To: [email protected] Subject: Bucardo-general Digest, Vol 82, Issue 12 Send Bucardo-general mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://mail.endcrypt.com/mailman/listinfo/bucardo-general or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of Bucardo-general digest..." Today's Topics: 1. Re: Bucardo-general Digest, Vol 82, Issue 11 (Jonathan Brinkman) ---------------------------------------------------------------------- Message: 1 Date: Sun, 27 Jul 2014 10:56:19 -0400 From: "Jonathan Brinkman" <[email protected]> To: <[email protected]> Subject: Re: [Bucardo-general] Bucardo-general Digest, Vol 82, Issue 11 Message-ID: <000f01cfa9aa$eda03df0$c8e0b9d0$@com> Content-Type: text/plain; charset="us-ascii" Removing those ALWAYS triggers didn't remove the problem... -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Sunday, July 27, 2014 8:00 AM To: [email protected] Subject: Bucardo-general Digest, Vol 82, Issue 11 Send Bucardo-general mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://mail.endcrypt.com/mailman/listinfo/bucardo-general or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of Bucardo-general digest..." Today's Topics: 1. Re: trigger-war? (Jonathan Brinkman) ---------------------------------------------------------------------- Message: 1 Date: Sat, 26 Jul 2014 17:19:51 -0400 From: "Jonathan Brinkman" <[email protected]> To: "'Greg Sabino Mullane'" <[email protected]> Cc: [email protected] Subject: Re: [Bucardo-general] trigger-war? Message-ID: <003a01cfa917$574f4af0$05ede0d0$@com> Content-Type: text/plain; charset="us-ascii" Bucardo 4.5.0 Yes there are some triggers set to ALWAYS ALTER TABLE clientdata.persons_accessids_idsystem_images ENABLE TRIGGER bucardo_add_delta; ALTER TABLE clientdata.persons_accessids_idsystem_images ENABLE TRIGGER bucardo_triggerkick_cmsorca_swap_main_and_gate; ALTER TABLE replication.replication_club_persons ENABLE TRIGGER trcrossschema_updater_clubpersons; ALTER TABLE replication.replication_club_persons ENABLE TRIGGER bucardo_add_delta; ALTER TABLE replication.replication_club_persons ENABLE TRIGGER bucardo_triggerkick_cmsorca_pushdelta_main_to_gate; That was done because the tables are "double-hopping", in that when the slave db updates the cloud db, there is an AFTER trigger that runs on the cloud DB table that needs to ALWAYS fire so that other stuff happens. Maybe I'm doing that wrong? -----Original Message----- From: Greg Sabino Mullane [mailto:[email protected]] Sent: Friday, July 25, 2014 11:42 PM To: Jonathan Brinkman Cc: [email protected] Subject: Re: [Bucardo-general] trigger-war? On Thu, Jul 24, 2014 at 04:58:37PM -0400, Jonathan Brinkman wrote: > Running Bucardo4 on ubuntu 12.04LTS and Postgresql 9.3 What exact version of Bucardo? There was a similar issue with Bucardo 5 that was fixed not too long ago, but I don't think it affected Bucardo 4. Are the sync kick triggers on the tables set as "ALWAYS" perchance? -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8 ------------------------------ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general End of Bucardo-general Digest, Vol 82, Issue 11 *********************************************** ------------------------------ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general End of Bucardo-general Digest, Vol 82, Issue 12 *********************************************** _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
