[Bucardo-general] Bucardo-general Digest, Vol 82, Issue 12

[Jonathan Brinkman]

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: bucardo-general-bounces at bucardo.org
[mailto:bucardo-general-bounces at bucardo.org] On Behalf Of
bucardo-general-request at bucardo.org
Sent: Monday, July 28, 2014 8:00 AM
To: bucardo-general at bucardo.org
Subject: Bucardo-general Digest, Vol 82, Issue 12

Send Bucardo-general mailing list submissions to
	bucardo-general at bucardo.org

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
	bucardo-general-request at bucardo.org

You can reach the person managing the list at
	bucardo-general-owner at bucardo.org

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" <jb at blackskytech.com>
To: <bucardo-general at bucardo.org>
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: bucardo-general-bounces at bucardo.org
[mailto:bucardo-general-bounces at bucardo.org] On Behalf Of
bucardo-general-request at bucardo.org
Sent: Sunday, July 27, 2014 8:00 AM
To: bucardo-general at bucardo.org
Subject: Bucardo-general Digest, Vol 82, Issue 11

Send Bucardo-general mailing list submissions to
	bucardo-general at bucardo.org

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
	bucardo-general-request at bucardo.org

You can reach the person managing the list at
	bucardo-general-owner at bucardo.org

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" <jb at blackskytech.com>
To: "'Greg Sabino Mullane'" <greg at endpoint.com>
Cc: bucardo-general at bucardo.org
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:greg at endpoint.com]
Sent: Friday, July 25, 2014 11:42 PM
To: Jonathan Brinkman
Cc: bucardo-general at bucardo.org
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 greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8



------------------------------

_______________________________________________
Bucardo-general mailing list
Bucardo-general at bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general


End of Bucardo-general Digest, Vol 82, Issue 11
***********************************************



------------------------------

_______________________________________________
Bucardo-general mailing list
Bucardo-general at bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general


End of Bucardo-general Digest, Vol 82, Issue 12
***********************************************