Jan Wieck JanWieck at Yahoo.com
Fri Jun 1 14:51:34 PDT 2007
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>> 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>
>     "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>
>     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