Jan Wieck JanWieck at Yahoo.com
Mon Jun 4 11:24:09 PDT 2007
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>> 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>> 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>
> 
> 
>         --
>         #======================================================================#
> 
>         # 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
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> 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 #


More information about the Slony1-general mailing list