Jim Archer jim
Wed Sep 7 03:46:06 PDT 2005
Hi All...

Well I have gone and screwed up my test cluster.  I had a cluster running
that consisted of one origin feeding two subscribers, all on seperate
machines.  One was connected with a private wire using fake net IPs while
the other was accross the Internet.

I issued a slonik script with this in it:

     lock set (id = 1, origin = 1);
     wait for event (origin = 1, confirmed = 2);
     wait for event (origin = 1, confirmed = 3);
     move set (id = 1, old origin = 1, new origin = 3);
     wait for event (origin = 1, confirmed = 2);
     wait for event (origin = 1, confirmed = 3);

This hung for quite a while so I aborted it.  Now, none of the 3 nodes
thinks it is the origin.

Two questions.  First, what is wrong with my script and second, is there a
way to gracefully recover from this condition?  If this were to happen to
my production database I would be up the creek...

Thanks...



More information about the Slony1-general mailing list