On 6/4/2007 7:01 PM, Dmitry Koterov wrote:
> Hmm, possibly
> 
> LOCK SET (ID = 1, ORIGIN = 1);
> UNLOCK SET (ID = 1, ORIGIN = 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...

I just committed the fix for the original problem. Check out the CVS 
branch REL_1_2_STABLE and look at src/ducttape/test_5_... it includes 
tests for SYNC as well as for EXECUTE SCRIPT followed by WAIT FOR EVENT. 
As soon as we have that tested enough we will release 1.2.10 and you 
will have a real solution. Please run your test cases and let us know if 
it fixes your problems. If everything goes well and no more serious bugs 
show up in the next few days, we will have 1.2.10 out this week.


Jan

> 
> On 6/4/07, *Jan Wieck* <JanWieck at yahoo.com <mailto:JanWieck at yahoo.com>> 
> wrote:
> 
>     On 6/4/2007 5:08 AM, Dmitry Koterov wrote:
>      > ...or, better,
>      >
>      > DROP PATH (SERVER = 1, CLIENT = 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>
>      > <mailto:dmitry at koterov.ru <mailto:dmitry at koterov.ru>>> wrote:
>      >
>      >     Could I use
>      >
>      >     DROP PATH (SERVER = 666, CLIENT = 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>
>      >     <mailto: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>>
>      >         >  <mailto: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>>
>     <mailto: 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> >
>      >         <mailto: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>
>      >         <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>
>      >         <http://lists.slony.info/mailman/listinfo/slony1-general>
>      >
>      >
>      >         --
>      >        
>     #======================================================================#
> 
>      >
>      >         # It's easier to get forgiveness for being wrong than for
>     being
>      >         right. #
>      >         # Let's break this rule - forgive
>      >         me.                                  #
>      >         #==================================================
>      >         JanWieck at Yahoo.com <mailto:JanWieck at Yahoo.com>
>     <mailto: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>
>      >         <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
> 
> 
>     --
>     #======================================================================#
>     # It's easier to get forgiveness for being wrong than for being right. #
>     # Let's break this rule - forgive
>     me.                                  #
>     #==================================================
>     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
> 
> 


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #