Moving the insert to the start of the transaction solved the logtrigger not firing problem. I now have a new symptom: on activating the new partition my insert into the log table is attempted more than once at the subscriber node, aborting the sync.
Everything at the provider node is fine. Activation of the partition consists of: - checking that the old temporary replication set (which was used to bring the partition in to the main set) is gone, by querying the subscribers using dblink - creating a view on the new partition using ddlscript - creating instead-of views on the new partition using ddlscript As other state transitions appeared to work correctly, I am baffled by this behaviour. Investigations continuing... __ Marc On Mon, 2006-05-15 at 10:03 -0700, Marc Munro wrote: > On Mon, 2006-05-15 at 11:17 -0400, Jan Wieck wrote: > > I suspect this is yet another failed attempt to merge before the > > ENABLE_SUBSCRIPTION has been processed. I guess some day we will have to > > remove the whole ENABLE_SUBSCRIPTION part but instead let the > > SUBSCRIBE_SET travel from the origin instead. > > > I'm pretty sure this is not it. My log table was already successfully > merged and synced prior to the state transition call and I am not > performing any merge within my state transition. > > I am next going to try moving the insert to the start of the transaction > to see if the logtrigger dislikes firing after a ddlscript call. > > __ > Marc >
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
