Hmm, possibly

LOCK SET (ID =3D 1, ORIGIN =3D 1);
UNLOCK SET (ID =3D 1, ORIGIN =3D 1);

would be a better choise? I just want to explicitly wait until all schema
changes are finished on all nodes, no more... And I guarantees that there is
no reading or writing activity at that moment, I just want to sit and
wait...

On 6/4/07, Jan Wieck <JanWieck at yahoo.com> wrote:
>
> On 6/4/2007 5:08 AM, Dmitry Koterov wrote:
> > ...or, better,
> >
> > DROP PATH (SERVER =3D 1, CLIENT =3D 1);
>
> If this works at all, you have to use the node ID of the node that you
> want the event to come from.
>
>
> Jan
>
>
> >
> > where 1 is the master node ID. I think there is no side-effect of
> > deleting 1<->1 path?
> >
> > On 6/4/07, * Dmitry Koterov* <dmitry at koterov.ru
> > <mailto:dmitry at koterov.ru>> wrote:
> >
> >     Could I use
> >
> >     DROP PATH (SERVER =3D 666, CLIENT =3D 6666)
> >
> >     instead of STORE PATH to generate an event, where 666 and 6666 are
> >     non-existed node IDs? It is easier than STORE PATH, because I may
> >     not specify conninfo manually and do not depend on it.
> >
> >     Would it work?
> >
> >
> >     On 6/2/07, *Jan Wieck* < JanWieck at yahoo.com
> >     <mailto:JanWieck at yahoo.com>> wrote:
> >
> >         On 6/1/2007 3:50 PM, Dmitry Koterov wrote:
> >         >  So, is there ANY method to wait for ending of EXECUTE SCRIPT?
> >         >  Let it work not over the slonik, but - any method?
> >
> >         what would currently work is a redundant STORE PATH (identical
> >         to an
> >         existing one) followed by a WAIT. The event for STORE PATH is
> always
> >         generated on the client node.
> >
> >
> >         Jan
> >
> >         >
> >         >  E.g., if just after slonik EXECUTE SCRIPT I fetch the last
> >         ev_timestamp
> >         >  from _my_cluster.sl_event and then - periodically check
> >         sl_status to
> >         >  wait until all slave nodes are processed events with greater
> >         timestamps,
> >         >  would it work?
> >         >
> >         >
> >         >
> >         >
> >         >  On 6/1/07, *Andrew Sullivan* < ajs at crankycanuck.ca
> >         <mailto:ajs at crankycanuck.ca>
> >         >  <mailto:ajs at crankycanuck.ca <mailto:ajs at crankycanuck.ca>>>
> wrote:
> >         >
> >         >     On Fri, Jun 01, 2007 at 12:26:06PM -0400, Jan Wieck wrote:
> >         >      > Looking at the code, it seems that EXECUTE SCRIPT
> >         doesn't actually
> >         >      > record the events seqno in the admin conninfo. Which
> >         means that
> >         >     WAIT FOR
> >         >      > EVENT will wait for an earlier event, or even nothing.
> >         >
> >         >     This sounds like a serious bug to me.  But this. . .
> >         >
> >         >      > Unfortunately the
> >         >      > same is true for SYNC in 1.2.9.
> >         >
> >         >     . . . sounds even worse.  Does this mean that some syncs
> >         could never
> >         >     get recorded?
> >         >
> >         >     A
> >         >
> >         >     --
> >         >     Andrew Sullivan  | ajs at crankycanuck.ca
> >         <mailto:ajs at crankycanuck.ca> <mailto: ajs at crankycanuck.ca
> >         <mailto:ajs at crankycanuck.ca>>
> >         >     "The year's penultimate month" is not in truth a good way
> >         of saying
> >         >     November.
> >         >                     --H.W. Fowler
> >         >     _______________________________________________
> >         >     Slony1-general mailing list
> >         >     Slony1-general at lists.slony.info
> >         <mailto:Slony1-general at lists.slony.info>
> >         <mailto:Slony1-general at lists.slony.info
> >         <mailto:Slony1-general at lists.slony.info>>
> >         >     http://lists.slony.info/mailman/listinfo/slony1-general
> >         <http://lists.slony.info/mailman/listinfo/slony1-general>
> >         >
> >         >
> >         >
> >         >
> >
> ------------------------------------------------------------------------
> >         >
> >         >  _______________________________________________
> >         >  Slony1-general mailing list
> >         >  Slony1-general at lists.slony.info
> >         <mailto:Slony1-general at lists.slony.info>
> >         >  http://lists.slony.info/mailman/listinfo/slony1-general
> >         <http://lists.slony.info/mailman/listinfo/slony1-general>
> >
> >
> >         --
> >
> #=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D#
> >
> >         # It's easier to get forgiveness for being wrong than for being
> >         right. #
> >         # Let's break this rule - forgive
> >         me.                                  #
> >         #=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D
> >         JanWieck at Yahoo.com <mailto:JanWieck at Yahoo.com> #
> >         _______________________________________________
> >         Slony1-general mailing list
> >         Slony1-general at lists.slony.info
> >         <mailto:Slony1-general at lists.slony.info>
> >         http://lists.slony.info/mailman/listinfo/slony1-general
> >
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Slony1-general mailing list
> > Slony1-general at lists.slony.info
> > http://lists.slony.info/mailman/listinfo/slony1-general
>
>
> --
> #=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me.                                  #
> #=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D JanWieck at Yahoo.com #
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070605/=
77c9ebab/attachment.htm