On 7/14/2004 9:51 AM, Guthrie, Jeremy wrote:

> 1st off, sorry about the difference in mail format, forced to use exchange for webmail.  yuck.
> 
> 1.  Makes sense, seems to work just fine.
> 
> 2.  I trimmed out the cluster name and tried to re-run. 

That's not what I suggested. Your script is missing the lines

     node 1 admin conninfo = ...;
     node 2 admin conninfo = ...;

> lock set (id = 1, origin = 1);
> wait for event (origin = 1, confirmed = 2);
> move set (id = 1, old origin = 1, new origin = 2);
> wait for event (origin = 1, confirmed = 2);
> 
> Same error.
> 
> 
> 3.  I don't see Node_ID in sl_event or sl_confirm.  What am I missing?

select con_origin, con_received,
         max(ev_seqno) as last_event,
         max(con_seqno) as last_replicated,
         max(ev_seqno) - max(con_seqno) as behind
         from _mycluster.sl_confirm, _mycluster.sl_event
         where con_origin = ev_origin
         and con_origin = _mycluster.getLocalNodeId('_mycluster')
         group by 1, 2;

This executed on the origin of the data set (master) will give you the 
desired information.


Jan

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